You are viewing content for 5.1 | 5.0 | 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | Previous Releases


inList

Returns true if a string expression contains any string constants in a list of constants in a variable.

Example

In this example, country_list contains the two element list “Spain” and “Germany”.

inList(SALES.COUNTRIES.COUNTRY_NAME, $country_list)

Syntax

inList(string expr field, list)

Parameters

  • field : string expression to search
  • list : variable containing one or more string values

    Returns

    bool

Notes

Function inList takes a field expression and a variable containing a list of items, and returns true if any of the items can match all or part of the expression. It returns false if no match can be found.

A variable can be supplied as the second argument which might contain a large list of data. As an example, inList might be used to define a data security filter either i the Table Details page or in an Insight.


© Incorta, Inc. All Rights Reserved.