The IN operator

There are some other operators that allow for more specific selections. The IN operator selects records based on a list of possible matching values for a field element. This list can either be determined by a comma-separated list of characters, by an array table returned by a tag, or by a tag or tag filter.

<BOUCLEx(TABLES){field IN a,b,c}>
<BOUCLEx(TABLES){field IN #ARRAY{0,a,1,b,2,c}}>
<BOUCLEx(TABLES){field IN (#VAL{a:b:c}|explode{:})}>

The inverse operator !IN selects records that have field values that do not match any of those listed after the operator.

<BOUCLEx(TABLES){field !IN a,b,c}>

Example

Select the images linked to an article:

<BOUCLE_documents(DOCUMENTS){id_article}{extension IN png,jpg,gif}>
  - #FICHIER<br />
</BOUCLE_documents>

Select the sections, except for 3 specific ones:

<BOUCLE_sections(RUBRIQUES){id_rubrique !IN 3,4,5}>
  - #TITRE<br />
</BOUCLE_sections>

Author Mark Baber Published : Updated : 30/05/10

Translations : English, français