DataFaucet 1.0 Beta

datafaucet.system.sql
Class andorcollectionfilter

WEB-INF.cftags.component
        extended by datafaucet.system.sql.duck
            extended by datafaucet.system.sql.simplefiltergroup
                extended by datafaucet.system.sql.collectionfilter
                    extended by datafaucet.system.sql.andorcollectionfilter

public class andorcollectionfilter
extends collectionfilter

filters a query using a collection (typically form input) to generate and-or filters for each column indicated in the collection


Constructor Summary
init(struct content, [boolean include], [boolean bindFilters='[runtime expression]'], [struct keywords], [any table=''])
 
Method Summary
private any initFilter(any filter, string column, string content, any keywords)
private void makeFilters()
 
Methods inherited from class datafaucet.system.sql.collectionfilter
getFilterDates, getFilterNumbers, getORMCollection, hasFilters, makeDateFilter, makeNumericFilter, newFilter, setRangeFilter, set_content
 
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, setProperties, setProperty, setValue, simplify
 
Methods inherited from class WEB-INF.cftags.component
 

Constructor Detail

init

public init(struct content, [boolean include], [boolean bindFilters='[runtime expression]'], [struct keywords], [any table=''])

Parameters:
content - a structure containing search phrases for each key in the structure
include - and / or -- determines whether the filters are cumulative or exclusive
bindFilters - indicates if the created group of filters should be returned as a contained group (adds parenthesis around the sql syntax)
keywords - a structure containing the keys and/or containing localized strings for use in parsing the searchphrase
table - an object of type statement.cfc
Method Detail

initFilter

private any initFilter(any filter, string column, string content, any keywords)

Parameters:
filter
column
content
keywords

makeFilters

private void makeFilters()

Overrides:
makeFilters in class collectionfilter

DataFaucet 1.0 Beta