Hi
I am trying to filter the record type that should filter either phone or email are not blank AND effectivedatefuturechange = today(). The code below doesnt seem to work
Code below:
a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}Address Change Participant Update Extract.fields.{929ea42f-0313-4410-8b8f-2049b30883bc}phonenumber', operator: "not null"), a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}Address Change Participant Update Extract.fields.{c8a513f8-9294-4156-9e62-a68d1204107f}emailaddress', operator: "not null"), } ) a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}Address Change Participant Update Extract.fields.{f4749c47-5f0a-4b1b-ab9a-0cd2a6045e2b}effectivedateforfturechange', operator: "=", value: today()), } )
Any help is appreciated
Thanks
Discussion posts and replies are publicly visible
Is there an error message?
The operator "is null" only hits values that are "NULL". Appian writes empty strings to DB. "is null" will not match these.
no error message
You will want to combine these into one parent a!queryLogicalExpression() that combines them with "AND", such as:
a!queryLogicalExpression( operator: "AND", logicalExpressions: { a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}.fields.{929ea42f-0313-4410-8b8f-2049b30883bc}', operator: "not null"), a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}.fields.{c8a513f8-9294-4156-9e62-a68d1204107f}', operator: "not null"), } ), a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}.fields.{f4749c47-5f0a-4b1b-ab9a-0cd2a6045e2b}', operator: "=", value: today()), } ) } )