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 )
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
Hello sandeepkumarn185922_Coforge
Your code looks fine. Have you tried refreshing the tab? Or may be some issue with your records sync.
Thank you Query filter is working fine.Regards,Sandeep