Combo box list display parameters

You can only use this parameter when a particular column is defined as a combo box and retrieves records from client application data as drop down list.

Note: Column to display a list of records from the client application data must be part of the query parameter that needs to be set with value. CODE columns do not require defining a list as it automatically retrieves its list from the Code table.

JSON Identifier: MFS@DisplayList


Parameter	Description	Possible values
`Col`	These are the columns shown in the drop-down list. These columns become searchable. This is the SELECT statement in the client's query to the local database.	`["Table.column, Table.column,…"]`
`Tbl`	This parameter indicates the tables where records are retrieved from.	`["Table, Table",..]`
`Join or LeftJoin`	This parameter joins two or more tables to retrieve the record from. This is for the FROM statement in the client's query to the local database. Note: The key column of the table is always defined as PrimaryKey as column reference. The joining columns are defined depending on the order of the tables in the `Tbl` property.	`["Table.column, Table.column"] OR ["Table.column, Table.column"],["Table.column, Table.column"]`
`Ftr`	This parameter defines what records are to be displayed or not. This is for the WHERE statement in the client's query to the local database. Note: When defining a single filter, only `Ftr` is used. This would contain the column, the operator, and the value or column to take the value from. When defining multiple filters, `Ftr`, `Val`, and `Op` are used. `Ftr` only contains the column and the operator. Each corresponding entry is separated by comma.	`["Table.column=Table.column"] OR ["Table.column=(value)"] OR ["Table.column=","Table.column!=", "Table.column",...]`
`Val`	Use this parameter only when applying multiple filters. Define values that correspond to the filter columns by specifying the appropriate column names. Separate multiple values with commas, following the order of the columns specified in `Ftr`. MFS references these values to determine whether to apply the current value as filter.	`["Table.column", "(value)", "IS NULL",...]`
`Op`	This parameter is only used for multiple filters. This parameter defines how filters are joined in the WHERE statement. Note: A single operator is used to connect all of the filters defined.	`AND` or `OR`
`SetVal`	This parameter defines which column to be set with a value based on the record retrieved and selected. The columns are included in the SELECT statement.	`["Table.column"] OR ["Table.column", "Table.column",...]`
`Pk`	This parameter is used when the primary key of the first table defined in `Tbl` is not used as a value but uses another column from the same first table instead.	`["Table.column"]`
`Clr`	This parameter clears a certain column value when a record has been selected.	`["Table.column"] OR ["Table.column", "Table.column",...]`
`BTreeFilter`	This parameter defines which records to display. This is for the WHERE clause in the query of the client to the local database. If this parameter is defined, the `Ftr` parameter is ignored. This parameter allows greater control over the groupings of conditions in the WHERE clause. The `BTreeFilter` must be a Boolean element with an Op, Left, and Right elements. The Op element only accepts `OR` or `AND`. The Left and Right elements are Boolean elements or Condition elements. Condition Elements must contain Ftr and Val elements.

See this example:

MFS@DisplayList={"Col":["Product.ProductNo","ProductDescription.ProductName"],"Tbl":["ProductDescription","Product","ProductWarehouse"],"LeftJoin":[["ProductID","PrimaryKey"],["PrimaryKey","ProductID"]],"Ftr":["ProductWarehouse.WarehouseID=","ProductWarehouse.WarehouseLocationID","Product.ItemCategory","Product.ItemGroupID=","Product.ItemTypeCODE=","Product.InventoryAccounting="],"Val":["ServiceLine.WarehouseID","IS NULL","IN (0,4,7)","Product.ItemGroupID","Product.ItemTypeCODE","Product.InventoryAccounting"],"Op":["AND"],"SetVal":["ProductWarehouse.StockQuantity","Product.BasicUnitCODE=ServiceLine.QtyBasicUnitCODE","ProductDescription.ProductName=ServiceLine.ProductName","Product.ProductNo=ServiceLine.ProductNo","ProductWarehouse.IssueMethod=ServiceLine.IssueMethod","Product.LotControl","Product.ItemTypeCODE","Product.ItemGroupID","Product.SalesPrice=ServiceLine.SalesPrice"],"Pk":"Product.ProductID","Clr":["ServiceLine.SerialNumber"]}