Table of Contents
Overview
This Custom Field returns TRUE if the first parameter contains any of the subsequent parameters.
Syntax
CONTAINSANY(FIELDSTR(Description),cyan,magenta)
| Element | Description |
|---|---|
| FIELDSTR(Description) | The string to search in. |
| Values | The string to search for. |
Example
CONTAINSANY(FIELDSTR(‘Colours’), ‘Blue’, ‘Dark’)
In the following list of colours, the above Custom Field query will return the following:
| Colours | CONTAINSANY(FIELDSTR(‘Colours’), ‘Blue’, ‘Dark’) |
| Green | FALSE |
| Dark Green | TRUE |
| Light Green | FALSE |
| Yellow | FALSE |
| Light Blue | TRUE |
| Royal Blue | TRUE |
| Dark Blue | TRUE |
| Orange | FALSE |
| Purple | FALSE |