Hi everyone, I would need an advise on how I can structure a Filter on a c

danielem over 8 years ago

Hi everyone,
I would need an advise on how I can structure a Filter on a child of a multiple data type in a Query Entity I am defining.

My main Issue is to apply a filter of a child of a multiple data type : in my case ("LEASE_RequestItems") is the Multiple Cdt.
see attachment for more Info of the cdt Structure
Attached there is also my query Entity definition.
Thank you to provide me an insight on how I can reach my requirement.
I tried already to define an Ad-Hoc record type thinking to define a default Filter on that field but I got the Same Issue

query.zip

Discussion posts and replies are publicly visible

0 PhilB
Certified Lead Developer
over 8 years ago

You're dealing with an array of complex objects, each element of which contains an array of complex objects - I don't believe this is possible. Have you considered building a view which flattens the data and makes it more suitable for your query?

You've also got 2 or more levels of nesting in that CDT, which may not be best practice - have you thought about building separate CDTs for LEASE_RequestItem and LEASE_Request, and then running a nested query entity using an IN condition?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel