Skip to main content
Question

Pipeline Filters using AND and OR

  • Jun 18, 2026 2:39 PM UTC
  • 2 replies
  • 117 views

RoyWanyoike
Forum|alt.badge.img+13

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

2 replies

AD47471
Forum|alt.badge.img+4
  • Qrew Cadet
  • Jun 19, 2026 1:07 AM UTC

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.


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 16, 2026 8:57 PM UTC

Advanced Query on Search Records is Quickbase query syntax, not Jinja and not regex. Group the name ORs in parentheses, then AND the school.

Swap in your real field IDs (this example uses 6 = School Name, 7 = Student Name):

{6.EX.'Your School Name'}AND({7.CT.'John'}OR{7.CT.'Michael'}OR{7.CT.'Joan'}OR{7.CT.'Name4'}OR{7.CT.'Name5'})

Keep AND/OR uppercase. CT is "contains" for text; use EX if you need an exact match on the full name.

With about 24 names the query gets long, but it's valid. If the list changes often, a cleaner pattern is a helper checkbox on the student ("Include in this pipeline") that you maintain once, then search:

{6.EX.'Your School Name'}AND{IncludeFid.EX.'1'}

https://help.quickbase.com/docs/use-the-quickbase-channel

https://help.quickbase.com/docs/api-doquery