Filter Value

Question

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)

mikes0011 · Answer

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))
)

Sign up

Login with SSO

Login to the community

Login with SSO