|
ColdBox Platform Version 2.6.3 | ||||
FRAMES |
WEB-INF.cftags.componentcoldbox.system.frameworkSupertype
coldbox.system.plugin
coldbox.system.plugins.queryHelper
public class queryHelper
A query helper plugin.
Constructor Summary | |
---|---|
init(any controller)
|
Method Summary | |
---|---|
private query |
QrySetCell(query qryFrom, query qryTo, array ArrayCols, numeric FromRowNumber, numeric ToRowNumber)
Insert value into query |
query |
doInnerJoin(query qryLeft, query qryRight, string LeftJoinColumn, string RightJoinColumn, [string OrderByElement=''], [boolean CaseSensitive='false'])
Return inner-joined Query |
query |
doLeftOuterJoin(query qryLeft, query qryRight, string LeftJoinColumn, string RightJoinColumn, [string OrderByElement=''], [boolean CaseSensitive='false'])
Return left outer-joined Query |
query |
doQueryAppend(query qryFrom, query qryTo)
Append Query1 into Query2 |
query |
filterNull(query qry, string field, [string null='NULL'])
Filters a query by NULL |
query |
filterQuery(query qry, string field, string value, [string cfsqltype='cf_sql_varchar'], [boolean list='false'])
Filters a query by the given value |
any |
getColumnArray(query qry, string ColumnName)
Returns an array of the values |
numeric |
getCountDistinct(query qry, string ColumnName)
Returns total/count disninct values |
numeric |
getRowNumber(query qry, string ColumnValue, string ColumnName)
Returns the row number of the first match |
private string |
getUnMatchedElements(string FirstList, string secondList)
Returns element which are only present in second-list |
private any |
getUniqueElements(string FirstList, string secondList)
Returns unique elements from two list |
query |
sortQuery(query qry, string sortBy, [string sortOrder='ASC'])
Sorts a query by the given field |
Methods inherited from class coldbox.system.plugin |
---|
getPluginDescription, getPluginName, getPluginVersion, getpluginPath, setPluginDescription, setPluginName, setPluginVersion
|
Methods inherited from class WEB-INF.cftags.component |
---|
|
Constructor Detail |
---|
public init(any controller)
Method Detail |
---|
private query QrySetCell(query qryFrom, query qryTo, array ArrayCols, numeric FromRowNumber, numeric ToRowNumber)
qryFrom
qryTo
ArrayCols
FromRowNumber
ToRowNumber
public query doInnerJoin(query qryLeft, query qryRight, string LeftJoinColumn, string RightJoinColumn, [string OrderByElement=''], [boolean CaseSensitive='false'])
qryLeft
qryRight
LeftJoinColumn
- the column name, not the value of columnRightJoinColumn
- the column name, not the value of columnOrderByElement
CaseSensitive
public query doLeftOuterJoin(query qryLeft, query qryRight, string LeftJoinColumn, string RightJoinColumn, [string OrderByElement=''], [boolean CaseSensitive='false'])
qryLeft
qryRight
LeftJoinColumn
- the column name, not the value of columnRightJoinColumn
- the column name, not the value of columnOrderByElement
CaseSensitive
public query doQueryAppend(query qryFrom, query qryTo)
qryFrom
- Append Query1 into Query2qryTo
- Query2 will have all record from Query1public query filterNull(query qry, string field, [string null='NULL'])
qry
- Query to filterfield
- Field to filter onnull
- NULL by default, also accepts NOT NULLpublic query filterQuery(query qry, string field, string value, [string cfsqltype='cf_sql_varchar'], [boolean list='false'])
qry
- Query to filterfield
- Field to filter onvalue
- Value to filter oncfsqltype
- The cf sql type of the value.list
- Whether to do a where IN list.public any getColumnArray(query qry, string ColumnName)
qry
- cf queryColumnName
- column namepublic numeric getCountDistinct(query qry, string ColumnName)
qry
- cf queryColumnName
- column/s namepublic numeric getRowNumber(query qry, string ColumnValue, string ColumnName)
qry
- cf queryColumnValue
- column valueColumnName
- column nameprivate string getUnMatchedElements(string FirstList, string secondList)
FirstList
- first list which be compared to second listsecondList
- second list which be compared from first listprivate any getUniqueElements(string FirstList, string secondList)
FirstList
- first list which be compared to second listsecondList
- second list which be compared from first listpublic query sortQuery(query qry, string sortBy, [string sortOrder='ASC'])
qry
- Query to sortsortBy
- Sort by column(s)sortOrder
- ASC/DESC
|
ColdBox Platform Version 2.6.3 | ||||
FRAMES |