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

Parents Reply Children
No Data