In TGV multi value list datatype is present & we need to filter data based on comma separated selection value. but In operator is not present in where conditions. If we select 1 record it is working fine but if we select multiple record in dropdown it is not working.
Regards,
Suhas
Any progress in this topic? we are facing the same issue where we want to use a multiselect in TGV and to use that to filter down the query with the selection.
Works with 1 value but not several values and can´t find how the get a equivalent function as "SQL IN" within the query definition.
Hello
Try something like this, combination of AND and OR
(is_current = 1) AND (
(State = 'Released') OR
(State = 'Preliminary') OR
(State = 'In Review')
)
Michael
