Help using Multiselect fields in a pipeline with more than one item selected

Challenge Accepted!

This seems to do the trick.

1. "set" the multi-select field into a Jinja list using the 'split' variable on the semicolon
2. Iterate on the list using the "for" statement to create the advanced query expression
3. Use "if" and "loop.last" to avoid adding an 'OR' at the end of the query

To learn more about using Jinja in Pipelines, I have created a course called Intro to Jinja for Pipelines.

{% set list = a.food.split(';') %}
{% for item in list %}
{% if loop.last %}{23.HAS.'{{item}}'}
{% else %}
{23.HAS.'{{item}}'}OR{% endif %}
{% endfor %}​

------------------------------
Quick Base Junkie
------------------------------