Mashables and Mashups : Mashups in Business Analytics Wires : Creating Mashups in Wires : Add Actions or Other Blocks : Filter Results
Filter Results
Filter Block Video rectFilter Block Video
The Filter action selects specific repeating items from a result based on matching characters or on meeting a numeric relationship. Connect the block with document-type results that you want to filter as input to this action.
Note:  
If there are no matching items, Filter return an empty document that typically contains just the root node with no repeating items or data.
apply condition
If you set multiple filter conditions, use this option to determine whether all conditions or only one must be met for an item to be selected in the filtered results.
left filter condition field
Click the Path Selector button to find the field in each repeating item that you want to use to filter results. See Select Fields or Paths for Block Properties with the Path Selector for more information.
Or click in this field and begin typing a field name. Select one of the suggested fields (with its full path).
comparison function
If needed, change the comparison function for the filter condition:
*Contains = checks to see that the text characters you are filtering for are present somewhere in the field you have chosen to filter by. The comparison is not case sensitive, unless you set the Case Sensitive option.
*Does not contain = checks to see that the text characters you are filtering for are not present somewhere in the field you have chosen to filter by. The comparison is not case sensitive, unless you set the Case Sensitive option.
*Is Empty = checks to see that the field is present, but contains no value. This is also sometimes called null.
*Matches = checks to see that the characters you are filtering for are present somewhere in the field you have chosen to filter.
*Does not match = checks to see that the characters you are filtering for are not present somewhere in the field you have chosen to filter.
*Is Present = checks to see that this field exists within the current row.
*Is Not Present = checks to see that this field does not existing within the current row.
*= (equals), != (does not equal), > (is greater than), < ()is less than, >= (is greater than or equals) or <= ()is less than or equals = compares the entire value of the field you select with the value you set for the filter condition using standard numeric comparisons.
right filter condition field
Set the value to check for in the right side of the filter condition. You can:
*Enter a value, word or phrase directly in the right side of the filter condition.
Note:  
Filter conditions do not check for separate words unless you use wildcards. So a match for Dow Jones would look for both words together, but would not match a result containing the word"window."
See Filtering Techniques for tips on using wildcards.
*Use an input field to provide the value dynamically. See Selecting Existing Input Blocks for Block Properties or Add Input Fields Directly to Block Properties for instructions.
*Use a Business Analytics global or user attribute to provide the value. See Use Business Analytics Global or User Attributes in Block Properties for instructions.
Note:  
This property is not available when the type of comparison that you have selected does not require a right field.
Case Sensitive
Set this option if the condition should be case sensitive.
Add Condition
Add another filter condition.
Note:  
Business Analytics developers who know XPath well can use the Advanced Mode button to customize the XPath expressions for conditions. Use the advance mode with care, however, as it disables the display of conditions in basic mode. If you return the condition to basic mode, your customized XPath expression for the condition is lost.
Copyright © 2013-2016 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback