Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
7 subscribers
Views
882 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi everyone, I would need an advise on how I can structure a Filter on a c
danielem
over 9 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
OriginalPostID-152118
OriginalPostID-152118
Discussion posts and replies are publicly visible
Parents
0
PhilB
A Score Level 1
over 9 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
Reply
0
PhilB
A Score Level 1
over 9 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
Children
No Data