ID refId Title Status 1 10 Test1 Approved 2 10 Test2 In-Review 3 10 Test3 Approved 4 10 Test4 Approved How to write query filter to fetch refId=10 when status all rows should be Approved

Question

Filtering by multiple conditions

Forum|Forum|3 years ago
June 30, 2023
7 replies
0 views

`ID`	`refId`	`Title`	`Status`
1	10	Test1	`Approved`
2	10	Test2	`In-Review`
3	10	Test3	`Approved`
4	10	Test4	`Approved`

How to write query filter to fetch refId=10 when status all rows should be Approved

S

sanchitg0002

I don't think this is a challenge for a Certified Associate Dev. Just write two query filters with "AND" operator in queryLogicalExpression(). One for refId=10 and other for Status="Approved".

sivakrishnam0002Author

is it possible to write single filter without using refId=10

S

sanchitg0002

What? No. Can you please explain the requirements more clearly?

mathieud0001

Brainy

Personally, the easiest way to do this if you are using Records would be to do a aggregate related record (custom record field) on the parent record where you count all the records <> approved. You then make a query that filters on the ref ids that have 0 "unapproved" records.

Sign up

Login with SSO

Login to the community

Login with SSO