How to retrieve all DOM instances containing a reference to another DOM instance

Solved473 viewsAutomation Script DOM
7
0 Comments

I have a DOM instance with a DomInstanceFieldDescriptor holding references to multiple other DOM instances.

Given a list of references (i.e. guids), what would be a filter to retrieve all DOM instances that contain at least 1 of these references?

This doesn't seem to do the job, tested in combination with an ORFilterElement:

DomInstanceExposers.FieldValues.DomInstanceField(fieldDescriptor).Contains(guid)

Jochen Dewachter [SLC] [DevOps Advocate] Selected answer as best 30th August 2024

1 Answer

3
4.80K 1 Comment

Hi Jochen,

The filter you provided should actually work fine. I just tried it out on my local dev agent and it seems to be working as expected. Even with an OR clause, and when using a multiple value DomInstanceFieldDescriptor. Can you share what database you are using?

This is my filter:

DomInstanceExposers.FieldValues.DomInstanceField(fieldDescriptorId)
.Contains(Guid.Parse("7e638a4e-f202-4526-b149-5287ab872b5a"));

Jochen Dewachter [SLC] [DevOps Advocate] Selected answer as best 30th August 2024
Jochen Dewachter [SLC] [DevOps Advocate] commented

There was a bug in the code right before this filtering. You’re right, the method I already tried worked anyhow. 🙂