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 Kyle Jorgensen over 7 years ago

@ravitejavj, @Tyler The looping method with "includes" ended up working. Here is the code I used:
local!filterFabSelection: if(
rule!APN_isBlank(local!filterFab),
{},
a!queryLogicalExpression(
operator: "OR",
filters: {
a!applyComponents(
a!queryFilter(
field: "customerFab",
operator: "includes",
value: _
),
local!filterFab
)
}
)
),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Kyle Jorgensen over 7 years ago

@ravitejavj, @Tyler The looping method with "includes" ended up working. Here is the code I used:
local!filterFabSelection: if(
rule!APN_isBlank(local!filterFab),
{},
a!queryLogicalExpression(
operator: "OR",
filters: {
a!applyComponents(
a!queryFilter(
field: "customerFab",
operator: "includes",
value: _
),
local!filterFab
)
}
)
),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data