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.

Discussion posts and replies are publicly visible

Parents

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

Reply

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

Children

No Data