Class actuate.data.FilterSpecifies filter conditions to be used by other classes when processing data. A filter has three components: a column, an operator, and a value or set of values. The condition is expressed as "value1 operator value2". For some operators, like "IN", the expression will be "value1 IN value2" where value2 is an array of strings.Format numbers and date/time values in a locale neutral format, for example "2.5" or "09/31/2008 01:02:03 AM".String. The operator can be any operator. Table 4-10 lists the valid filter operators and the number of arguments to pass to the constructor or setValues( ).
Table 4-10 Number of
arguments Matches the bottom percent of the values Not between an inclusive range Does not match any value in a set of values Search for values that do not match a pattern String or array of strings. The first value to compare to the column value for the BETWEEN or NOT_BETWEEN operators.String or array of strings. This parameter is only required for the BETWEEN or NOT_BETWEEN operators.To select all of the rows matching a list of countries in their country fields, use code similar to the following:var filter = new actuate.data.Filter("COUNTRY", actuate.data.Filter.IN,["Canada" , "USA", "UK", "Australia"]);var cityfilter = new actuate.data.Filter("CITY", actuate.data.Filter.EQ, "NYC");Table 4-11 lists actuate.data.Filter functions.
Table 4-11 function retrieveColumnName(myFilter){function retrieveFilterOperator(myFilter){Returns the evaluated results of this filter. When the filter is constructed or set with a single argument, the returned value corresponds to the single argument. When two arguments or an array are set in the filter, the return value is an array of values.function retrieveValues(myFilter){function setFilterSales( myfilter ){Sets filter operator. The operator determines the comparison made between the data in the column and the value or values set in the filter.String. The operator can be any valid operator. Table 4-10 lists the valid filter operators and the number of arguments to pass to Filter.setValues( ).Sets string values for the filter to compare to the data in the column according to the operator. Table 4-10 lists the valid filter operators and the values they use. Takes either one or two values, or one array of values.function setFilter( myfilter ){
|
|
Copyright Actuate Corporation 2012 |