Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.sql
Class timespanfilter

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

public class timespanfilter
extends simplefiltergroup
extends simplefiltergroup

filters a query to provide results where one time-span overlaps or does not overlap another time-span

Constructor Summary
`init(string startcolumn, string endcolumn, string starttime, string endtime, [string overlap='true'], [any table=''])`

Method Summary
`private any`	`addFilter(string column, datafaucet.system.sql.date content, string comparison, [string include='and'])`
`boolean`	`bindFilters()`
`private string`	`get_column()`
`boolean`	`hasFilters()`
`private void`	`makeFilters()`
`private any`	`raiseDateException(string propertyname, string propertyvalue)`
`private void`	`setDate(string propertyname, string propertyvalue)`
`any`	`setProperties(struct collection)`
`private void`	`set_endtime(string propertyname, string propertyvalue)`
`private void`	`set_overlap(string propertyname, string propertyvalue)`
`private void`	`set_starttime(string propertyname, string propertyvalue)`

Methods inherited from class datafaucet.system.sql.simplefiltergroup
`appendFilter, clearFilters, columnNotFoundException, execute, filtersExist, getAvailableColumnList, getDatasource, getFilters, getFirstFilter, getGroupSource, getSource, getSyntax, getTable, getTableArray, getTableForColumn, 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 startcolumn, string endcolumn, string starttime, string endtime, [string overlap='true'], [any table=''])

Parameters:: startcolumn - identifies a column representing the beginning of a span of time; endcolumn - identifies a column representing the end of a span of time; starttime - the beginning of a time-span which should or should not overlap the span indicated in the columns; endtime - the end of a time-span which should or should not overlap the span indicated in the columns; overlap - indicates if the specified time-spans should overlap or should not overlap; table - an object of type statement.cfc

Method Detail

addFilter

private any addFilter(string column, datafaucet.system.sql.date content, string comparison, [string include='and'])

Parameters:: column; content; comparison; include

bindFilters

public boolean bindFilters()

Overrides:: bindFilters in class simplefiltergroup

get_column

private string get_column()

Overrides:: get_column in class simplefiltergroup

hasFilters

public boolean hasFilters()

Overrides:: hasFilters in class simplefiltergroup

makeFilters

private void makeFilters()

Overrides:: makeFilters in class simplefiltergroup

raiseDateException

private any raiseDateException(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

setDate

private void setDate(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

setProperties

public any setProperties(struct collection)

Overrides:: setProperties in class duck

Parameters:: collection

set_endtime

private void set_endtime(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

set_overlap

private void set_overlap(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

set_starttime

private void set_starttime(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

Overview

Package