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
2 replies
Subscribers
7 subscribers
Views
2471 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Is there a way to search through a CDT array variable on select set of fields?
briank538
over 10 years ago
Is there a way to search through a CDT array variable on select set of fields? I do not want to match on all fields. Thanks.
OriginalPostID-201084
OriginalPostID-201084
Discussion posts and replies are publicly visible
0
Jacob Cohen - Project Leader - Macedon Technologies
over 10 years ago
I'd recommend using wherecontains in combination with intersection. This will allow you to look at each field individually, then combine the results. Something like this:
intersection(
index(ri!cdtList, wherecontains(val1, ri!cdtList.field1), {}),
index(ri!cdtList, wherecontains(val2, ri!cdtList.field2), {}),
index(ri!cdtList, wherecontains(val3, ri!cdtList.field3), {})
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
briank538
over 10 years ago
Yeah, I was trying to avoid multiple searches and having to intersect them. Just looking to see if there was a more efficient way of doing this. But, it works. Thanks Jacob.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel