Query Record Type filter issue

Certified Associate Developer

Hi Team,

I have written query record type with filters to get the records which are reviewed one year back. Filtering based on field "reviewedOn".
Currently when i am testing this rule, getting records those have "reviewedOn" is null. How to eliminate these records which have "reviewedOn" is null.
Attached Query and output for your reference:
Please suggest if any solution available to fix this.

a!localVariables(
  local!lastOneYearReviewedAttestations: index(
    a!queryRecordType(
      recordType: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation',
      filters: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          a!queryFilter(
            field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation.fields.{9cc9f1c8-8b6c-4200-94d0-b992949d4303}reviewedOn',
            operator: "not null"
          ),
          a!queryFilter(
            field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation.fields.{9cc9f1c8-8b6c-4200-94d0-b992949d4303}reviewedOn',
            operator: ">=",
            value: today() - 365
          )
        },

      ),
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: cons!TRICS_BATCH_SIZE[5]
      )
    ),
    "data",
    {}
  ),
  local!lastOneYearReviewedAttestations
  )


Test output:
List of Attestation - 2 items
Attestation
workflowIdnull(Number (Integer))
dueDate 08/05/2025(Date)
reviewedOn null(Date)
reviewedBy ""(Text)

Attestation
workflowIdnull(Number (Integer))
dueDate08/05/2025(Date)
reviewedOn null(Date)
reviewedBy ""(Text)

Regards,
Sandeep

  Discussion posts and replies are publicly visible