EditAttachPrintable
r1 - 05 May 2006 - 03:32:39 - TanDunlinYou are here: TWiki >  Main Web  >  ElixirEnsemble > ElixirEnsembleCookbook > FilterProcessor

Using Filter Processor

Filter processor is a tool with which you can manipulate and group the database records to filter out those records which meet specific criteria.


All the Filter tabs have the following columns:

  • Column - Row numbers
  • Name - Field names
  • Type - Data Type
  • When - Type of Filter Condition
  • Condition - Value of filter condition (Dynamic Parameter allowed)


When Condition Remarks

  • Equal / Not Equal

  • More Than / Not More Than

  • Less Than / Not Less Than

 Type :

Comparable types : String, Numeric, Data, Timestamp

Example :

10

1961-08-26 		This condition uses a simple comparison of values, which must both be of comparable types. For example, strings can be compared with strings, but not with dates.
  • Matches / Not Mataches
 Type :

String

Example :

US|Mex 		This condition allows a regular expression to be used. Use of operators like "|" for OR and "&&" for AND relationship. This example will match USA or Mexico strings.
  • In Range / Not In Range
 Type :

Numeric, Date, Timestamp with "~" as separator

Example :

1998-01-01~1998-12-31 		 
  • In DataSet? / Not in DataSet?
 Type :

Matching field type from another datasource

Example :

See Remarks 		repository:/Sample/DataSource.ds:Field1

This retrieves the matching field from
another datasource for filtering values.
  • Null / Not Null
 Nothing to enter Check whether if there is no content. Note
that zero value is not considered null.
Enter a script condition by specifying the matching type.

Example :

Field1==5|Field2=="US|Mex"
where Field1 is numeric and
Field2 is string.

This is useful for enter multiple conditions
or complex conditions using standard
JavaScript.


-- TanDunlin - 05 May 2006

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r1 | More topic actions
 
Powered by TWiki
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback