Compare Joined String to an Array in a Query Filter

Kyle Jorgensen over 7 years ago

I am trying to compare a field that is a joined array of customer locations (ex: "Factory A; Factory X; Factory Y") to an array locations put in as a filter (user selects "Factory X"). Essentially what I would like to have happen is if any part of this array {"Factory X", "Factory Z"} is present in this field "Factory A; Factory X; Factory Y" then I'd like to return that record.

Is this possible?

Discussion posts and replies are publicly visible

Parents

0 georgej over 7 years ago

Can't we just us the "in" operator with ri!inputValues defined as "Array"
a!queryEntity(
entity:cons!XXXX,
query:a!query(
filter:a!queryFilter(
field:"FLD1",
operator:"in",
value:ri!inputValues
),
pagingInfo:rule!genericPagingInfoAll()
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 georgej over 7 years ago

Can't we just us the "in" operator with ri!inputValues defined as "Array"
a!queryEntity(
entity:cons!XXXX,
query:a!query(
filter:a!queryFilter(
field:"FLD1",
operator:"in",
value:ri!inputValues
),
pagingInfo:rule!genericPagingInfoAll()
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data