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 Chaitanya,I have refreshed tab and manually record synced. Still in output getting records which have "reviewedOn" is null. In Query filter do i need to add any additional filter?Regards,Sandeep
Thank you Query filter is working fine.Regards,Sandeep