I have a pipeline which has a search step from a list of students. In the filter I want to include the names I want and not the entire list.
SchoolName is xxx AND
Student Name contains John OR
Student name contains Michael OR
Student Name contains Joan OR
.......they are 24
how can I approach this using using advance filters
Roy, have you considered REGEX EXTRACT or REGEX MATCH? A pipeline function call - you can put what you're needing to extract into an AI prompt to develop the REGEX EXTRACT expression that works for you. Then, each of the names that match the regular expression will be piped into the left column of your available pipeline variables. Similarly, the REGEX MATCH will ring true or false if your names match the expression.
Let me give it a try and I'll let you know.
