Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

FilterList

Use this function to create a new list which is filtered in a specified condition. This function is only available in a procedure as part of the SET VARIABLE command.

Copy

Syntax

FILTERLIST ("VariableName", "Condition")        

where:

  • VariableName is the name of a list variable.
  • Condition is a condition that evaluates to a TRUE/FALSE (1/0) result. It can also be an Attribute-based filter (if the list contains objects that have Attributes, for example, a list of users, user groups, or symbols).
Copy

Syntax example

CREATE VARIABLE X[] AS STRING
CREATE VARIABLE Y[] AS STRING
SET VARIABLE X = CreateList ("SYMBOLS", "DATABASE", "Accounts", "TrialBal###")
SET VARIABLE Y = FilterList ("X", "[[SYMBOL, ZGPNativeCurrency, THIS]]==CAD'')        
Published:

FilterList

Use this function to create a new list which is filtered in a specified condition. This function is only available in a procedure as part of the SET VARIABLE command.

Copy

Syntax

FILTERLIST ("VariableName", "Condition")        

where:

  • VariableName is the name of a list variable.
  • Condition is a condition that evaluates to a TRUE/FALSE (1/0) result. It can also be an Attribute-based filter (if the list contains objects that have Attributes, for example, a list of users, user groups, or symbols).
Copy

Syntax example

CREATE VARIABLE X[] AS STRING
CREATE VARIABLE Y[] AS STRING
SET VARIABLE X = CreateList ("SYMBOLS", "DATABASE", "Accounts", "TrialBal###")
SET VARIABLE Y = FilterList ("X", "[[SYMBOL, ZGPNativeCurrency, THIS]]==CAD'')        
For an optimal Community experience, Please view on Desktop