Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.sql
Class andorfilter

WEB-INF.cftags.component
        datafaucet.system.sql.duck
            datafaucet.system.sql.simplefiltergroup
                datafaucet.system.sql.andorfilter

public class andorfilter
extends simplefiltergroup
extends simplefiltergroup

applies a collection of and/or keyword filters to a specified set of columns

Constructor Summary
`init(string columns, string searchphrase, [any table=''])`

Method Summary
`private any`	`addFilter(any filter, [any group='[runtime expression]'])`
`private any`	`getFilter(string classpath, [any table='[runtime expression]'])`
`struct`	`getKeywords()`
`private array`	`getPhrases(string searchphrase, string separator)`
`boolean`	`hasFilters()`
`private void`	`makeFilters()`
`private any`	`newFilter(string column, string content)`
`private any`	`newGroup(string include)`
`private array`	`preparePhrase(string searchphrase)` converts a user-provided search phrase into an array of arrays using provided keywords and removes any empty array elements
`any`	`setProperties(struct collection)` ensures that properties are set in the correct order to split the search phrase properly
`private any`	`set_columns(string propertyname, string propertyvalue)`
`private any`	`set_searchphrase(string propertyname, string propertyvalue)`

Methods inherited from class datafaucet.system.sql.simplefiltergroup
`appendFilter, bindFilters, clearFilters, columnNotFoundException, execute, filtersExist, getAvailableColumnList, getDatasource, getFilters, getFirstFilter, getGroupSource, getSource, getSyntax, getTable, getTableArray, getTableForColumn, get_column, hasGroupSource, hasJoinSource, hasJoinTables, isGroup, raiseFilterExceptions, setTable, typeMismatchException`

Methods inherited from class datafaucet.system.sql.duck
`arg, getDefaultLocalization, getLocalization, getNext, getObject, getProperties, getProperty, getPropertylist, getTail, getValue, hasNext, identifyAccessorOrMutator, insertAfter, onMissingMethod, parseDate, parseNumber, raiseAbstractClassException, raiseMissingMethodException, removeAfter, setLocalization, setNext, setProperty, setValue, simplify`

Methods inherited from class WEB-INF.cftags.component

Constructor Detail

init

public init(string columns, string searchphrase, [any table=''])

Parameters:: columns - a comma delimited list of columns to filter; searchphrase - a search phrase containing and-or keywords in the current users preferred language or in english if localized keywords are unavailable; table - an object of type statement.cfc

Method Detail

addFilter

private any addFilter(any filter, [any group='[runtime expression]'])

Parameters:: filter; group

getFilter

private any getFilter(string classpath, [any table='[runtime expression]'])

Parameters:: classpath; table

getKeywords

public struct getKeywords()

getPhrases

private array getPhrases(string searchphrase, string separator)

Parameters:: searchphrase; separator

hasFilters

public boolean hasFilters()

Overrides:: hasFilters in class simplefiltergroup

makeFilters

private void makeFilters()

Overrides:: makeFilters in class simplefiltergroup

newFilter

private any newFilter(string column, string content)

Parameters:: column; content

newGroup

private any newGroup(string include)

Parameters:: include

preparePhrase

private array preparePhrase(string searchphrase)

converts a user-provided search phrase into an array of arrays using provided keywords and removes any empty array elements

setProperties

public any setProperties(struct collection)

ensures that properties are set in the correct order to split the search phrase properly

set_columns

private any set_columns(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

set_searchphrase

private any set_searchphrase(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

Overview

Package