Trace:
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
visionx:faq_tech [2021/06/30 10:54] admin |
visionx:faq_tech [2021/06/30 11:04] admin |
||
---|---|---|---|
Line 28: | Line 28: | ||
No problem, just drag another search field from the bottom of the screen. Choose a column and condition (equal, smaller, ...) for each field. All of them will be combined with an AND. A search field without specific condition will act as full-text search for "all columns". | No problem, just drag another search field from the bottom of the screen. Choose a column and condition (equal, smaller, ...) for each field. All of them will be combined with an AND. A search field without specific condition will act as full-text search for "all columns". | ||
+ | |||
+ | ==== Is it possible to create a drop down based on a query? ==== | ||
+ | |||
+ | For example: ''select distinct (S_YEAR) from PERSON_LIST'' | ||
+ | |||
+ | Be careful because distinct queries are usually "slow", because of the force full table scan at the database level. | ||
+ | To use a custom query for a drop down you do the following: | ||
+ | |||
+ | * Add the table/view as data object in the bottom of the VisionX designer e.g. PERSON_LIST | ||
+ | * Change the query in the data wizard in the bottom right corner e.g. add the distinct keyword before the query columns | ||
+ | * Go to your base table where the drop down should be used, define a manual combobox there, and choose PERSON_LIST object from previous step | ||
+ | |||
+ | Additional information: | ||
+ | |||
+ | [[visionx:data_modeling_and_representation#views_and_storages|Views and Storages]] \\ | ||
+ | [[visionx:data_modeling_and_representation#create_dropdown_without_foreign-key_relation|Create Dropdown Without Foreign-Key Relation]] |