ConditionalGet

This function will return values from specified field/column in specified tablethat satisfy specified condition.

Syntax

ConditionalGet("source","fieldName","conditionalFieldName","operator","conditionalValue","separator");

Function arguments

  • source – (String) Name of the table from which data is to be retrieved. This can be nested table (i.e. 'table1>table2′)
  • fieldName – (String) Name of the field/column from which data is to be retrieved
  • conditionalFieldName – (String) Name of the field which value is to be tested as condition
  • operator – (String) Logical operator to be used when comparing conditional field actual value with expected one. Allowed values: [ = | == | != | <> | < | > | <= | >= ]
  • conditionalValue – (String) Expected value that conditional field is being compared to using specfied operator
  • separator – (String) Char sign, that will separate individual values concatenated in output string

Return value

This function returns String.
Returns string containg all returned values separated by specified separator.

Examples

Example 1:
This will get all values from 'column1′ in 'table1′ from all rows in which 'column5′ is equal to '5′ and store output as single string with individual values separated by '#’.

output = ConditionalGet("table1","column1","column5","==","5","#");
Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.