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
9 subscribers
Views
2273 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 9 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 9 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 9 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