Issue on default filter record type

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

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

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

Children
No Data