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.

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).

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.

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).

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