Hi all,
I need to filter the data based on dropdown which have a value {"P","NP"} from Date field ,
if dropdown value is P then i need to filter all not null dates value in grid and if it NP then all null value in date field .
is there any way to achieve the requirement,
a!queryFilter(field: "dates",operator: "=",value: ri!dates)
Discussion posts and replies are publicly visible
The first thing I'd try is something along the lines of this:
a!queryFilter( field: "dates", operator: if( local!filter = "P", "not null", local!filter = "NP", "is null", null() ), applyWhen: not(isnull(local!filter)) )