One to Many (1-Many)

(1-Many) module displays and manages data fields for multiple records in the database. It shows data in tabular form. The One to Many (1-Many) module is based on grid and card layout design and allow users to handle large number of items and columns.


The 1-Many Module configuration provides a list of property settings with 2 icons as shown below:



  1.   -   This icon is used to open "Module Configuration" property window. 1-Many Module configuration property window provides a list of settings which can be helpful in specific needs or special purposes. All 1-Many Module configuration settings along with their usage are listed in table below:


Module Item

Default value

Mandatory

Description

Module ID

N/A

Y

Module ID is the unique ID and it is generated by system automatically.

Module Name

1-Many Module

Y

The appropriate name for a module.

Table Name

N/A

Y

The table associated with that module.

Template Code

Responsive2016

Y

Default is set to same as Entity Template. No Edit Required.

Theme Code

Responsive2016

Y

Default is set to same as Entity Theme. No Edit Required.

Show List Layout

GRID

Y

Select GRID Layout or Card layout for the list for 1- Many.

Module Key

N/A

Y

This is set the field to be used as the Key to the Module.

Prefix

N/A

This is used to add to configure Prefix that will be added to the beginning of the key when automatically generated.

Postfix

N/A


Used to configure suffix that will be added to the end of the key when automatically generated.

KeyLen

N/A

Key Len is to set size of key.

Sequence

N/A

Y/N

Database Sequence to be used for key generation.

SQL Show List

N/A


This is used to set the manual SQL Command used to query data to display in Module in Tabular Format (Only used in 1- Many Modules).

SQL Work Queue

N/A

This is used to set the manual SQL Command to query data to display in Search Results. Only for 1-1 Modules

SQL Select Row

N/A

This is used to write the manual SQL Command to be used to query data in 1-1 Module. Only used in 1-1 Module.

SQL Duplicate Function

N/A

-

View Mode Flag

N

SetMake your module in View/Read Mode only.

Paging Flag

N

Enables paging for 1- Many Module.

Ordering Flag

N

Enabled sorting in the header of data grid.

Multiple table Flag

N

-


  1.   - This Icon is used to delete a Module from your Smart Form Layout.