query record result

Question

I need to make a record-like query for a 1 to N relationship, in which it only returns the values ​​of the parent record if all the values ​​in the N relationship meet a condition. Example : 
 I have a record called "Need" and it is related to another called "needchangestate" through a relationship 1 to N, I need it to return only the needs where all the needchangestate meet a condition, if all the elements of the relationship N do not meet the condition, the element Need should not appear 
 Currently it returns me an investment where the condition is met in at least one of the records of the relationship N but this is not what I am looking for.

Andrew Hickingbotham · Accepted Answer

Apologies, it needs a third custom record team to do the comparison.

Mathieu Drouin · Answer

I think the best way to accomplish this is via a View unfortunately. 
 There is a way to do it via queryRecordType but it involves excluding IDs from a previous query but this approach has limitations.

Stefan Helzle · Answer

What about one or two custom fields that hold the number of these states?

Andrew Hickingbotham · Answer

This does depend on how dynamic you want this functionality but if there is one (or not many) specific things you want then custom record fields do work. One way to do this is to have two "Aggregate Related Record Fields" custom record fields in the parent record (in your case, the "Need" record) that looks at the child record. One counts the number of children where decision is FALSE (`countOfNoDecision`) and the other counts the number of child records (`countOfAllDecisions`). 
 Then in your query you ask for only Need records where `countOfNoDecision` = `countOfAllDecisions`.

query record result

Top Replies