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
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()), } ) } )