Hello,
I have a table in which status values are. these are grouped by type.
I would like to display these in dropdown fields.
Is it possible to filter this or do I have to make a single query for each type
Because I have a lot of types, I would dislike to create a separate query for each type.
Query Result:
|DisplayValue|Type|
|open|State|
|started|State|
|finished|State|
|open|Approval|
|approved|Approval|
|declined|Approval|
Dropdown A:
Open
Started
Finished
Dopdown B:
Open
Approved
Declined