Hello ,
From one of the view we have , i want few of the records to be excluded which doesn't satisfy the conditions passed from a!query()
For example :
SELECT * FROM TABLE
WHERE NOT(col1=0 AND col2=null)
Just like the condition used in above sql where clause i want to use it in a!query(), how do i add NOT in the queryLogicalExpression ?
Thank You!
Discussion posts and replies are publicly visible
That will not help, Lets consider the below examples
Your condition will return 0 records, when you use NOT(col1=0 AND col2=null) the query returns 2 records.
Try this
a!query( a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: "col1", operator: "<>", value: 0 ), a!queryFilter( field: "col2", operator: "not null" ) } ) )