...
Attribute | Value | Explanation |
---|---|---|
name | adrsubtyp | The field which is initially displayed in the input field (closed DynSelect). In this case it is the calculated field |
EntityName | Osiv.BusinessLogic.ipar.AdrSubtyp.AdrSubtypBE | The Business Entity class of the 'child' table |
EntityTable | eAdrSubtyp | The 'child' table to populate the DynSelect with |
FieldLabel | Basistyp | The label to show in the viewer |
LookupKeyField | adrsubtyp | The field to be displayed after an entry is selected (normally the same as attribute 'name'). Can also be a comma-separated list of fields and constants, for example: |
LookupKeyValueBinding | adrsubtyp_id | This represents the DataSource (of the viewer) its DataField where the value from attribute 'LookupKeyValueColumn' will be stored in, in this case the relational |
LookupKeyValueColumn | adrsubtyp_id | The key field from the Business Entity of attribute 'Entityname', in this case the relational AdrSubtyp.Adrsubtyp_ID field |
Template | GenericAutocompleteSearchTemplateDynSelect | |
templateOptions | |adrsubtyp|bez | The format of an entry in the drop-down. The format is: The format can also contain constants, for example: |
VisualizationType | FILL-IN | |
WIDTH-CHARS | 230 | This is not the same as other fields. The value must be set much higher. |
LookupFields | A comma separated list of fields which will be assigned after an entry is selected. Those values will be saved as well | |
LookupControls | The corresponding UI controls of attribute 'LookupFields' | |
MULTIPLE | If more entries can be selected (currently not implemented in a Viewer) | |
maximumSelectionLength | How many entries can be selected. Works only with attribute MULTIPLE (currently not implemented in a Viewer) | |
minimumInputLength | The minimum characters which must be typed before any result is displayed in the DynSelect | |
closeOnSelect | Leave the drop-down open or not. Nice feature with MULTIPLE attribute | |
tags | The value typed-in will be added to the drop-down list | |
initialFetch | Default expression when building the DynSelect for the first time. Works together with method Override the Be aware that the | |
onBeforeFetch | Event: This is an event which is triggered every time the DynSelect is opened. This is usefull when another DynSelect needs to use the value of another DynSelect. | |
validateEvent | Event: This event is triggered every time an entry is selected. This is usefull for validations | |
resultListMenuCode | Contains the name of a menu-structure, and will be displayed at the end of the DynSelect |
Create a DynSelect in as a filter in a grid
To add a DynSelect as filter in a grid, the SmartComponent Object Master Maintenance window must be used. The Akioma Web Designer does not support this functionallity.
- Open the grid in Object Master Maintenance
- Make sure the grid has SUBTYPE 'grid2' value
- Remove the column for which the filter becomes a DynSelect
- Add a new record
- Object Master:
SimpleSwatSelect
- Instance Name: The name of field in the grid column, in this case:
AdrSubtyp
- Save the record
- Object Master:
Attributes for DynSelect in a Grid
Select the SimpleSwatSelect input field and set the following attributes (be aware, some attributes are case-sensitive):
Info | ||
---|---|---|
| ||
If the filter is based on LIST-ITEMS or LIST-ITEM-PAIRS, then the attributes EntityName, EntityTable,LookupKeyField, LookupKeyValueColumn, ObjectType, Template and TemplateOptions can be left blank. |
Attribute | Value | Explanation |
---|---|---|
CanFilter | true | To enable the DynSelect |
CanSort | Enable to have the column sortable | |
closeOnSelect | Leave the drop-down open or not. Nice feature with MULTIPLE attribute | |
EntityName | Osiv.BusinessLogic.ipar.AdrSubtyp.AdrSubtypBE | The Business Entity class of the 'child' table |
EntityTable | eAdrSubtyp | The 'child' table to populate the DynSelect with |
filter | #dynselect_filter | |
LABEL | Basistyp | The label of the column |
LookupKeyField | adrsubtyp | The field to be displayed after an entry is selected (normally the same as attribute 'name'). It will show the selected enty as a 'tag/label'. Can also be a comma-separated list of fields and constants, for example: |
LookupKeyValueColumn | adrsubtyp_id | The key field from the Business Entity, in this case the relational Adresstyp.Adrsubtyp_ID field |
ObjectType | dynselect | |
Template | GenericAutocompleteSearchTemplateDynSelect | |
TemplateOptions | |adrsubtyp|bez | The format of an entry in the drop-down. The format is: The format can also contain constants, for example: |
For other attributes see the chapter above with the DynSelect in a Viewer