Developing Apama Applications > Dashboard Function Reference > Tabular Functions > Filter By Row
Filter By Row
Returns a table containing all rows from a specified table in which the values of specified columns matches the values in specified lists of values.
Arguments
This function has the following arguments:
*Table: Table from which matching rows are to be extracted.
*Filter Column Name: Text string that specifies a list of column names, the columns of Table to be searched for matches. Separate column names with
*Filter Value: Text string that specifies a list of lists of values to be matched. Separate values with a coma. Separate lists with a semicolon (for example, val1,val2;val3,val4;val5,val6). Enter * for Filter Value in order to display all rows in the table. To use * as a literal comparative value, enclose it in single quotes. To use ; as a literal comparative value, enclose it in single quotes. If a filter value contains a space or a semicolon, enclose the entire value in single quotes.
A row from Table is included in the returned table if and only if the nthFilter Column Name matches a value in FilterValue’s nth list, for all n from 1 to the number of specified column names.
This function returns a table.
Copyright © Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or its Subsidiaries and or/its Affiliates and/or their licensors.
Use, reproduction, transfer, publication or disclosure is prohibited except as specifically provided for in your License Agreement with Software AG.