query record result

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.

hi [mention:a2a33cb01839432998847be591819973:e9ed411860ed4f2ba0265705b8793d05]  I agree with what [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05]  has mentioned; there will be many limitations. However, I'm not entirely sure. Could you try implementing a custom field in your main record type? This custom field should incorporate conditions based on the child records, such as counting the statuses from the child records. You could then filter these in your query. Please give this a try.

Hello. As I understand it, to implement what you need, you can use the following code as an example. But it requires iterating the list to be able to filter the data, and if your case is to bring a large batch of data this can affect performance. Also, you can use [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05]  suggestion as a reference and query directly to the view. Regarding pagination, if you need to show it in an interface you could use pagination and pass it as a parameter to your rule and bring only what is necessary per page.

a!localVariables(
  local!data: a!queryRecordType(
    recordType: 'recordType!SB Need',
    fields: {
      'recordType!SB Need.fields.name',
      'recordType!SB Need.relationships.needDetail.fields.decision'
    },
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 10,
      sort: a!sortInfo(
        field: 'recordType!SB Need.fields.id',
        ascending: false
      )
    )
  ).data,
  local!filteredData: a!forEach(
    items: local!data,
    expression: a!localVariables(
      local!relatedData: fv!item['recordType!SB Need.relationships.needDetail.fields.decision'],
      if(
        and(
          a!isNotNullOrEmpty(local!relatedData),
          count(local!relatedData) =  length(wherecontains(false, toboolean(local!relatedData))),
        ),
        fv!item,
        {}
      )
    )
  ),
  local!filteredData
)

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

Thank you all for the answers, we are testing to see what is the best option, I am surprised that Appian does not have a simple way to get values of the 1 to N ratio that meet the specific conditions. I think a is a very typical case that wanting to retrieve records only if the relationship N all records meet a condition. For example: 

Give me all the investments that have all the approved amounts