Hi everyone, Can appian do this query? I would like to query all of the data of the merchant without transaction between a specified date range and show it in the read-only grid, I already have view table but I can show all of the merchant without transaction between a specified date range.
Discussion posts and replies are publicly visible
To query record IN a specific range, you do something like "datefield >= START AND datefield <= END". The opposite would be "datefield <= START AND datefield >= END". I think it is not the question whether Appian can do this query ....
Hey Stefan, I achieved it through following code, Could you please check it & tell me whether it's acceptable or not.(in place of today he can use his dates)
a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "HolidayDate", operator: "not in", value: a!forEach(items: enumerate(1+tointeger(a!addDateTime(today(),"","",30,"","","","","")-today())), expression: today()+fv!item) ) }, ignoreFiltersWithEmptyValues: true)
I think this is not a good idea. You need to compare each item in DB against a list of 31 values! This cries for bad performance.