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