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
You would simply include multiple a!queryFilter() entries in your logicalExpression's filters list.
Also:
Thanks Mike, that did the trick!
Cool, thanks for confirming!