In a queryEntity expression, is it possible to filter on both a primary entity and a related entity?

Certified Associate Developer

Here is a very rough ERD:



Each case has many subcases; each subcase deals with a software and each software has a status 

I have a Rule Input "dcmCaseID" that is populated with the parentCaseID for the Case entity.

When the query is run, I get data for all the subcases that are linked to the case ID

The query looks something like this:

a!queryEntity(
entity: cons!DSE_SUBCASE,
query: a!query(
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "case.parentID",
operator: "=",
value: ri!dcmCaseID
)
},
ignoreFiltersWithEmptyValues: false
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1)
),
fetchTotalCount: false
).data,

I need to modify the query to return only subcases where the software statusID is null.

Using a queryRecordType either breaks the process completely, or returns no subcases at all.

Any help will be greatly appreciated!

Blessings

Stephen

  Discussion posts and replies are publicly visible