Compare Joined String to an Array in a Query Filter

you can try using wherecontains function, it will give you array index of the matching value

More information on wherecontains() - forum.appian.com/.../Array_Functions.html

Can wherecontains() be used within a a!queryFilter()?

As far as i understood, you will provide input as single string "Factory A; Factory X; Factory Y" and you are expecting to search any matches which have any of those factories. if that is the case you code must be like as follows

local!searchItems:fn!split("FACTORY A;FACTORY B;FACTORY C",";"),

/*-----


a!queryEntity(
entity:----
a!query(
-----

*/

logicalExpression:if(rule!APN_isEmpty(local!searchItems),{},a!queryLogicalExpression(
operator: "OR",
filters: {
a!applyComponents( a!queryFilter(
field: "field",
operator: "=",
value: _
),local!searchItems)
}
)

You can apply any number of query filters on same field with proper conditions it works. Let me know if you need any help.

Instead of "=" you can use "includes" if you want to get any partial matches too

In the query rule, set up rule inputs to contain the value you seek to use in the Query Convictions with the operator "includes"?

@ravitejavj, hmm so loop a queryFilter using a!applyComponents; I'll try that out.

@Sally Mason, I've tried using the operator includes, but it has trouble with an string array as the value parameter, I get the error below:
"Expression evaluation error in rule 'pd_getopportunitiesforbudgetreport' at function a!queryEntity: Cannot apply operator [INCLUDES] to field [customerFab] when comparing to value [TypedValue[it=103,v={Intel - F42}]]."

Yes, i used a!applyComponents on queryFilters in past and it works. Regarding error, you need to do typecasting to avoid it.

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()
)
)

Kyle - I think in this case you would need to use Reviteja's idea of looping over your fabs to create one query filter for each. Then your logical expression would use OR logic, so that you'd get results where either the string includes Fab1 OR it includes Fab 2.