The SqlTokenToolBox type exposes the following members.
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
  | SqlTokenToolBox | |
 | SqlTokenToolBox | Initializes a new instance of the SqlTokenToolBox class |
Methods
| Name | Description | |
|---|---|---|
| ColumnValuePairAsFilterQuery |
Combines a set of column value pair objects back into an SqlQuery object.
|
| CombineFilterQueries |
Appends the second filter query object to the first using the AND connector.
Expects a coded core filter criteria query.
|
| CopyFilter |
Copies only a filter entry into a new filter entry. Returns the name of the new filter and the destination user id in the return object.
|
| CopyFilterReportsAndStatisticsToCreatedFilter(String, String, String, String, String) |
Copies a filter's reports and statistics to a new filter created by this method, does force a rename of the filter.
|
| CopyFilterReportsAndStatisticsToCreatedFilter(String, String, String, String, Boolean, String) |
Copies a filter's reports and statistics to a new filter created by this method. Optionally forces a rename of the filter to a safeName.
|
| CopyFilterReportsAndStatisticsToNewFilter(String, String, String, String) |
Copies a filter's reports and statistics to a new, already existing filter. SUSPECT - NEEDS TESTING
|
| CopyFilterReportsAndStatisticsToNewFilter(FilterObj, String, String, String) |
Copies a filter's reports and statistics to a new, already existing filter.
|
| CopyReport |
Copies a report and all supporting data.
|
| CopyStatistic |
Copies a statistic and all supporting data.
|
| FilterQueryAsColumnValuePair |
Parses an SqlQuery objects SqlToken array and creates a list of SqlColumnValuePair objects.
Provides easier traversal of column value pairs for use with web forms.
Expects a coded core filter criteria query.
|
| FilterQueryAsColumnValuePairForColumnName(List SqlColumnValuePair , String) |
Filter a filter query object of column value pairs with a given column name.
|
| FilterQueryAsColumnValuePairForColumnName(SqlQuery, String) |
Filter a filter query object of column value pairs with a given column name.
|
| FilterQueryAsColumnValuePairForTableName(List SqlColumnValuePair , String) |
Filter a filter query object of column value pairs with a given table name.
|
| FilterQueryAsColumnValuePairForTableName(SqlQuery, String) |
Filter a filter query object of column value pairs with a given table name.
|
| FilterQueryAsHtml |
Returns an HTML representation of the passed in core criteria.
Will not render full queries correctly, designed only to render filter criteria.
|
| FilterQueryAsText |
Renders a core criteria filter as text.
|
| FilterReportsSelectionPanel(FilterObj, Int32, String, ControlCollection, Int32, Boolean, Boolean, String) |
Creates a report selection panel with show new report panels set to off.
|
| FilterReportsSelectionPanel(FilterObj, Int32, String, ControlCollection, Int32, Boolean, Int32, Boolean, String) |
Creates a report selection panel with the given parameter settings.
|
| FilterReportsSelectionPanel(FilterObj, Int32, String, ControlCollection, Int32, Boolean, Int32, String, Boolean, String) |
Creates a report selection panel with the given parameter settings.
|
| FilterReportsSelectionPanel(FilterObj, Int32, String, ControlCollection, Int32, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, String) |
Creates a report selection panel with the given parameter settings.
|
| FilterReportsSelectionPanel(FilterObj, Int32, String, ControlCollection, Int32, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Int32, Boolean, String) |
Creates a report selection panel with the given parameter settings.
|
| FilterReportsSelectionPanel(FilterObj, Int32, String, ControlCollection, Int32, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Int32, String, Boolean, String) |
Creates a report selection panel with the given parameter settings.
|
| FilterStatisticsSelectionPanel(FilterObj, Int32, String, ControlCollection, Int32, Boolean, Boolean, String) |
Creates a statistic selection panel with show new statistic panels set to off.
|
| FilterStatisticsSelectionPanel(FilterObj, Int32, String, ControlCollection, Int32, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, String) |
Creates a statistic selection panel with the given parameter settings.
|
| FilterStatisticsSelectionPanel(FilterObj, Int32, String, ControlCollection, Int32, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Int32, Boolean, String) |
Returns the html controls for a filter statistic selection panel.
|
| GetAnchorTableToken |
Returns an anchor table token.
|
| GetAndToken(Int32) |
Returns a default and token.
|
| GetAndToken(String, Int32) |
Returns a default and token. Default name should be 'and'.
|
| GetAscToken(Int32) |
Creates an order clause ASC token.
|
| GetAscToken(String, Int32) |
Creates an order clause ASC token.
|
| GetAsToken(Int32) |
Returns a defualt as token.
|
| GetAsToken(String, Int32) |
Returns a default as token. Default name is 'as'.
|
| GetBasicCrashDataQuery |
Generates a select query given an SqlQuery object.
Expects a coded core filter criteria query.
|
| GetBasicTableReportQuery |
Returns an SqlQuery that represents a basic table report, i.e. a select statement on a core table.
|
| GetBasicTableReportResultQrp(SqlQuery, String) |
Runs the given full SqlQuery and returns the QueryResultPacket.
|
| GetBasicTableReportResultQrp(SqlQuery, String, DataTable, DataTable, String, String) |
Returns a basic table report result packet with the execution results.
|
| GetBetweenToken(Int32) |
Returns a default between token.
|
| GetBetweenToken(String, Int32) |
Returns a default between token. Defualt name should be 'operator'.
|
| GetCastFunctionToken(Int32) |
Returns a cast function token.
|
| GetCastFunctionToken(String, Int32) |
Returns a cast function token.
|
| GetCloseFunctionToken(Int32) |
Returns a close token function.
|
| GetCloseFunctionToken(String, Int32) |
Returns a close token function with the given name.
|
| GetCloseGroupToken(Int32) |
Returns the close group token, sets the name and token index.
Indexes can be fixed using the normalize call on an SqlQuery object.
|
| GetCloseGroupToken(String, Int32) |
Returns the close group token, sets the name and token index.
Indexes can be fixed using the normalize call on an SqlQuery object.
Should use 'groupClose' as the default name.
|
| GetClusterFinderNoWeightCountyQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report without weighting.
|
| GetClusterFinderNoWeightMuniQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report without weighting.
|
| GetClusterFinderNoWeightQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report without weighting.
|
| GetClusterFinderNoWeightSriQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report without weighting.
|
| GetClusterFinderNoWeightSriSegmentQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report without weighting.
|
| GetClusterFinderWithWeightCountyQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report with weighting.
|
| GetClusterFinderWithWeightMuniQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report with weighting.
|
| GetClusterFinderWithWeightQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report with weighting.
|
| GetClusterFinderWithWeightSriQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report with weighting.
|
| GetClusterFinderWithWeightSriSegmentQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cluster finder report with weighting.
|
| GetCoalesceFunctionToken(Int32) |
Returns a select clause coalesce function token.
|
| GetCoalesceFunctionToken(String, Int32) |
Returns a select clause coalesce function token.
|
| GetColumnToken(String, String, Int32) |
Returns a custom, default column token. Default name should be 'column'.
|
| GetColumnToken(String, String, String, Int32) |
Returns a custom, default column token.
|
| GetColumnTokenNoBrackets(String, String, Int32) |
Returns a column token with no brackets around the column.
|
| GetColumnTokenNoBrackets(String, String, String, Int32) |
Returns a custom column token with no brackets around the column.
|
| GetColumnValuePairBetween |
Returns a simple column value pair SqlQuery.
|
| GetColumnValuePairBetweenLower |
Returns a simple column value pair SqlQuery with lower case operators for literal query use.
|
| GetColumnValuePairIn |
Returns a simple column value pair SqlQuery.
|
| GetColumnValuePairInLower |
Returns a simple column value pair SqlQuery with lower case operators for literal query use.
|
| GetColumnValuePairSimple |
Returns a simple column value pair SqlQuery.
|
| GetCommaToken(Int32) |
Returns a default comma token.
|
| GetCommaToken(String, Int32) |
Returns a default comma token. Default name should be 'comma'.
|
| GetConvertFunctionToken(Int32) |
Returns a select clause convert function token.
|
| GetConvertFunctionToken(String, Int32) |
Returns a select clause convert function token.
|
| GetCountFunctionToken(Int32) |
Returns a select clause count function token.
|
| GetCountFunctionToken(String, Int32) |
Returns a select clause count function token.
|
| GetCrashOrientationBikeCountyQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for pedestrian crash orientations.
|
| GetCrashOrientationBikeMuniQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for pedestrian crash orientations.
|
| GetCrashOrientationBikeQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for bike crash orientations.
|
| GetCrashOrientationBikeSriQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for pedestrian crash orientations.
|
| GetCrashOrientationBikeSriSegmentQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for pedestrian crash orientations.
|
| GetCrashOrientationCrossMedianCountyQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cross median crash orientations.
|
| GetCrashOrientationCrossMedianMuniQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cross median crash orientations.
|
| GetCrashOrientationCrossMedianQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cross median crash orientations.
|
| GetCrashOrientationCrossMedianSriQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cross median crash orientations.
|
| GetCrashOrientationCrossMedianSriSegmentQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for cross median crash orientations.
|
| GetCrashOrientationLeftTurnCountyQuery |
Returns a crash orientation left turn county query.
|
| GetCrashOrientationLeftTurnMuniQuery |
Returns a crash orientation left turn muni query.
|
| GetCrashOrientationLeftTurnQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for right angle crash orientations.
|
| GetCrashOrientationLeftTurnSriQuery |
Returns a crash orientation left turn SRI query.
|
| GetCrashOrientationLeftTurnSriSegmentQuery |
Returns a crash orientation left turn SRI segment query.
|
| GetCrashOrientationPedCountyQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for pedestrian crash orientations.
|
| GetCrashOrientationPedMuniQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for pedestrian crash orientations.
|
| GetCrashOrientationPedQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for pedestrian crash orientations.
|
| GetCrashOrientationPedSriQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for pedestrian crash orientations.
|
| GetCrashOrientationPedSriSegmentQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for pedestrian crash orientations.
|
| GetCrashOrientationRightAngleCountyQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for right angle crash orientations.
|
| GetCrashOrientationRightAngleMuniQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for right angle crash orientations.
|
| GetCrashOrientationRightAngleQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for right angle crash orientations.
|
| GetCrashOrientationRightAngleSriQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for right angle crash orientations.
|
| GetCrashOrientationRightAngleSriSegmentQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for right angle crash orientations.
|
| GetCrashOrientationRunOffRoadCountyQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for fixed object crash orientations.
|
| GetCrashOrientationRunOffRoadMuniQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for fixed object crash orientations.
|
| GetCrashOrientationRunOffRoadQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for fixed object crash orientations.
|
| GetCrashOrientationRunOffRoadSriQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for fixed object crash orientations.
|
| GetCrashOrientationRunOffRoadSriSegmentQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for fixed object crash orientations.
|
| GetCrosstabAnalysisQuery |
Returns a valid cross tab analysis query based on the given criteria.
|
| GetDecimalToken(Int32) |
Returns a select clause decimal token.
|
| GetDecimalToken(String, Int32) |
Returns a select clause decimal token.
|
| GetDecodeFunctionToken(String, Int32) |
Returns a token used for running P4S decode functions, uses default token name.
|
| GetDecodeFunctionToken(String, String, Int32) |
Returns a token used for running P4S decode functions, uses specified token name.
|
| GetDescToken(Int32) |
Creates an order clause DESC token.
|
| GetDescToken(String, Int32) |
Creates an order clause DESC token.
|
| GetDistinctColumnCount |
Returns a query that represents a distinct column count.
|
| GetDistinctColumnValues(DataTable, String) |
Returns a data table with distinct column values from the given criteria.
|
| GetDistinctColumnValues(String, String) |
Returns a data table with distinct column values from the given criteria.
|
| GetDistinctCrashDataQuery |
Generates a select distinct query given an SqlQuery object.
Expects a coded core filter criteria query.
|
| GetDistinctCrashIdQuery |
Generates a distinct crash ID sql query from the givne filter criteria.
|
| GetDistinctToken(Int32) |
Returns a default distinct token.
|
| GetDistinctToken(String, Int32) |
Returns a default distinct token. Default name should be 'distinct'.
|
| GetElderlyWorkflowCountyRanking |
Returns the proper SQL to drive the elderly workflow county ranking.
|
| GetElderlyWorkflowCountyRankingGis |
Returns the proper SQL to drive the elderly workflow county ranking.
|
| GetElderlyWorkflowCrashRanking |
Returns the proper elderly workflow crash ranking query.
|
| GetElderlyWorkflowMuniRanking |
Returns the proper SQL to drive the elderly workflow municipality ranking.
|
| GetElderlyWorkflowMuniRankingCountyGis |
Returns the proper SQL to drive the elderly workflow municipality ranking, county GIS query.
|
| GetElderlyWorkflowMuniRankingMuniGis |
Returns the proper SQL to drive the elderly workflow municipality ranking, muni GIS query.
|
| GetEqToken(Int32) |
Returns a default equals token.
|
| GetEqToken(String, Int32) |
Returns a default equals token. Default name should be 'operator'.
|
| GetFilterPopulationStatisticResultTableQrs |
Generates population statistics for a given filter object.
Returns a QueryResultSet that details the SQL execution.
|
| GetForToken(Int32) |
Returns a for object.
|
| GetForToken(String, Int32) |
Returns a for object.
|
| GetFrequencyAnalysisQuery(FilterObj, DataTable, DataTable, String, String) |
Generates a valid frequency analysis query for the given criteria.
|
| GetFrequencyAnalysisQuery(FilterObj, DataTable, DataTable, String, String, String) |
Generates a valid frequency analysis query for the given criteria.
|
| GetFrequencyAnalysisQuery2 |
Generates a valid frequency analysis query for the given criteria.
|
| GetFromToken(Int32) |
Returns a from object.
|
| GetFromToken(String, Int32) |
Returns a from object. Should have a default name of 'from'.
|
| GetFullJoinToken(Int32) |
Returns a full join token with the default name, 'fulljoin'.
|
| GetFullJoinToken(String, Int32) |
Returns a full join token with a custom name.
|
| GetGisCrashMapQuery |
Returns a basic crash query for viewing on GIS map.
|
| GetGisCrashTypeMapQuery |
Returns a basic crash query for viewing on GIS map.
|
| GetGisRefinementQuery |
Returns a report used in the refinement of filter results via a GIS map.
|
| GetGroupByToken(Int32) |
Returns a group by token with the default name.
|
| GetGroupByToken(String, Int32) |
Returns a group by token with a provided name, default name is groupby.
|
| GetGtEqToken(Int32) |
Returns a default greater than equal to token.
|
| GetGtEqToken(String, Int32) |
Returns a default greater than equal to token. Default name should be 'operator'.
|
| GetGtToken(Int32) |
Returns a default greater than token.
|
| GetGtToken(String, Int32) |
Returns a default greater than token. Default name should be 'operator'.
|
| GetHavingToken(Int32) |
Returns a having object.
|
| GetHavingToken(String, Int32) |
Returns a having object. Should have a default name of 'having'.
|
| GetHiddenToken(String, Int32) |
Creates an invisible token for encoding data into an SqlQuery object.
|
| GetHiddenToken(String, String, Int32) |
Creates an invisible token for encoding data into an SqlQuery object.
|
| GetInnerJoinToken(Int32) |
Returns an inner join token with the default name, 'innerjoin'.
|
| GetInnerJoinToken(String, Int32) |
Returns an inner join token with a custom name.
|
| GetIntegerToken(String, Int32) |
Returns an integer valued token, uses the default name.
|
| GetIntegerToken(String, String, Int32) |
Returns an integer valued token, uses the specified name.
|
| GetIntersectionCrashRecords |
Returns an intersection crash records query.
|
| GetIntersectionDetailsCoreQuery |
Returns the core query that the intersection details queries are based on.
|
| GetIntersectionDetailsCrashTypeAndSeverityQuery |
Returns an intersection details query by crash type and severity.
|
| GetIntersectionDetailsQueries |
Returns a set of intersection details queries.
|
| GetIntersectionDiagramCrashData |
Returns a crash data list for the given information.
|
| GetIntersectionDiagramCrashList |
Returns a crash list for the given information
|
| GetIntersectionDiagramCrashTypeList |
Returns a crash type list for the given information.
|
| GetIntersectionRankingCountyQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for intersection rankings by county.
|
| GetIntersectionRankingMuniQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for intersection rankings by municipality.
|
| GetIntersectionRankingQuery |
Takes in a filter object and some arguments, returns an SqlQuery object for intersection rankings.
|
| GetInToken(Int32) |
Returns a default in token.
|
| GetInToken(String, Int32) |
Returns a default in token. Default name should be 'operator'.
|
| GetInValueToken(String, Int32) |
Returns an IN clause value token.
|
| GetInValueToken(String, String, Int32) |
Returns an IN clause value token.
|
| GetIsNotToken(Int32) |
Returns an IS NOT token.
|
| GetIsNotToken(String, Int32) |
Returns an IS NOT token.
|
| GetIsToken(Int32) |
Returns an IS token.
|
| GetIsToken(String, Int32) |
Returns an IS token.
|
| GetLeftJoinToken(Int32) |
Returns the default left join token.
|
| GetLeftJoinToken(String, Int32) |
Returns the default left join token. Default name should be 'leftjoin'.
|
| GetLikeToken(Int32) |
Returns a default like token.
|
| GetLikeToken(String, Int32) |
Returns a default like token. Defualt name should be 'operator'.
|
| GetLtEqToken(Int32) |
Returns a default less than equal to token.
|
| GetLtEqToken(String, Int32) |
Returns a default less than equal to token. Default name should be 'operator'.
|
| GetLtToken(Int32) |
Returns a default greater than token.
|
| GetLtToken(String, Int32) |
Returns a default greater than token. Default name should be 'operator'.
|
| GetMathConnectorToken(String, Int32) |
Returns a math connector token +, -, /, * based on the specified operator.
|
| GetMathConnectorToken(String, String, Int32) |
Returns a math connector token +, -, /, * based on the specified operator.
|
| GetNeqToken(Int32) |
Returns a default not equals token.
|
| GetNeqToken(String, Int32) |
Returns a default not equals token. Default name should be 'operator'.
|
| GetNullStringToken(Int32) |
Returns a null string token, uses default token name.
|
| GetNullStringToken(String, Int32) |
Returns a null string token, uses specified token name.
|
| GetNullToken(Int32) |
Returns a db-null value token, uses default token name.
|
| GetNullToken(String, Int32) |
Returns a db-null value token, uses specified token name.
|
| GetOnToken(Int32) |
Returns a default on token.
|
| GetOnToken(String, Int32) |
Returns a default on token. Default name should be 'on'.
|
| GetOpenFunctionToken(Int32) |
Returns an open function token.
|
| GetOpenFunctionToken(String, Int32) |
Returns an open function token with the default name.
|
| GetOpenGroupToken(Int32) |
Returns the open group token, sets the name and token index.
Indexes can be fixed using the normalize call on an SqlQuery object.
|
| GetOpenGroupToken(String, Int32) |
Returns the open group token, sets the name and token index.
Indexes can be fixed using the normalize call on an SqlQuery object.
Should use 'groupOpen' as the default name.
|
| GetOperatorToken(String, Int32) |
Returns a custom, default operator token.
|
| GetOperatorToken(String, String, Int32) |
Returns a custom, default operator token. Defualt name should be 'operator'.
|
| GetOrderByToken(Int32) |
Returns an SQL word ORDER BY token.
|
| GetOrderByToken(String, Int32) |
Returns an SQL word ORDER BY token.
|
| GetOrToken(Int32) |
Returns a default or token.
|
| GetOrToken(String, Int32) |
Returns a default or token. Default name should be 'or'.
|
| GetPedCrashAllByAgeGroup |
Returns all ped crash query by age group.
|
| GetPedCrashFatalByAgeGroup |
Returns a ped fatal crash query by age group.
|
| GetPedCrashInjuredByAgeGroup |
Returns a crash injured query by age group.
|
| GetPedCrashKsiByAgeGroup |
Returns a crash KSI query by age group.
|
| GetPedPopulationByAgeGroup |
Returns ped population by age group.
|
| GetPivotToken(Int32) |
Returns a PIVOT token.
|
| GetPivotToken(String, Int32) |
Returns a PIVOT token.
|
| GetReplaceFunctionToken(Int32) |
Returns a select clause replace function token.
|
| GetReplaceFunctionToken(String, Int32) |
Returns a select clause replace function token.
|
| GetReportQuery(FilterObj, DataTable, Int32, String) |
Returns an SqlQuery object for the given filter report information.
|
| GetReportQuery(FilterObj, DataTable, DataTable, Int32, String) |
Returns an SqlQuery object for the given filter report information.
|
| GetReportQuery(FilterObj, DataTable, DataTable, Int32, String, String, Boolean) |
Returns an SqlQuery object for the given filter report information.
|
| GetReportResultTableQrp |
Calculates a report result for the given criteria, returns a QueryResultPacket for the report query execution results.
|
| GetReportResultTableQrs(FilterObj, DataTable, String) |
Returns a query result table for each report in a filter objects report set.
|
| GetReportResultTableQrs(FilterObj, DataTable, DataTable, String) |
Returns a query result table for each report in a filter objects report set.
|
| GetReportResultTableQrs(FilterObj, DataTable, Int32, String) |
Returns a query result table for a specific report index.
|
| GetReportResultTableQrs(FilterObj, DataTable, DataTable, Int32, String, String) |
Returns a query result table for the given report index.
|
| GetReportResultTableQrs(FilterObj, DataTable, DataTable, Int32, String, String, Boolean) |
Get a query return set for the given report.
|
| GetRightJoinToken(Int32) |
Returns a right join token with the default name, 'rightjoin'.
|
| GetRightJoinToken(String, Int32) |
Returns a right join token with a custom name.
|
| GetRoadwayHistogramCountyQuery |
Returns a road histogram county query for the given information.
|
| GetRoadwayHistogramMuniQuery |
Returns a road histogram municipality query for the given information.
|
| GetRoadwayHistogramQuery(FilterObj, DataTable, DataTable, String, String, String, String, String, String, String, String) |
Generates a valid roadway histogram query for the given criteria.
|
| GetRoadwayHistogramQuery(FilterObj, DataTable, DataTable, String, String, String, String, String, String, String, String, String) |
Generates a valid roadway histogram query for the given criteria.
|
| GetRoadwayHistogramSriQuery |
Returns a road histogram SRI query for the given information.
|
| GetRoadwayHistogramSriSegmentQuery |
Returns a road histogram SRI segment query for the given information.
|
| GetRoundFunctionToken(Int32) |
Returns a select clause round function token.
|
| GetRoundFunctionToken(String, Int32) |
Returns a select clause round function token.
|
| GetSelectAliasToken |
Returns a select clause alias token.
|
| GetSelectAsToken |
Returns a select clause as token.
|
| GetSelectFunctionColumnToken(String, String, Int32) |
Returns a select clause function column token.
|
| GetSelectFunctionColumnToken(String, String, String, Int32) |
Returns a select clause function column token.
|
| GetSelectToken(Int32) |
Returns a default select token.
|
| GetSelectToken(String, Int32) |
Returns a default select token. Should have 'select' as the default name.
|
| GetSqlWordToken |
Returns a custom, default sql word/phrase token.
|
| GetStatisticQuerySet |
LEGACY USED FOR TESTING, DOESN'T CALCULATE FORMULAS
Get a set of statistic sql query objects, does not handle formulas.
Expects a loaded filter object.
|
| GetStatisticResultTableQrs |
Returns a table of values for the statistics in a given filter.
Expects a loaded filter object.
Returns a QueryResultSet object that has information about the query executed, if it failed, etc.
|
| GetStatisticSqlSet |
LEGACY USED FOR TESTING, DOESN'T CALCULATE FORMULAS
Get a set of statistic sql queries, does not handle formulas.
Expects a loaded filter object.
|
| GetSumFunctionToken(Int32) |
Returns a select clause sum function token.
|
| GetSumFunctionToken(String, Int32) |
Returns a select clause sum function token.
|
| GetTableColumnSetForReport(ReportObj) |
For the given report object return a set of tables and columns used by the report query.
|
| GetTableColumnSetForReport(SqlQuery) |
For the given report object return a set of tables and columns used by the report query.
|
| GetTableFormulaSetForReport |
Returns a list of formulas in a given report object.
|
| GetTableGeoRowCountSql(String, FilterObj, DataTable) |
Returns a geo coded row count query in sql form.
|
| GetTableGeoRowCountSql(String, SqlQuery, DataTable) |
Returns a geo coded row count query in sql form.
|
| GetTableRowCountSql(String, FilterObj, DataTable) |
Generate a table row count sql query.
|
| GetTableRowCountSql(String, SqlQuery, DataTable) |
Generate a table row count sql query.
|
| GetTableRowCountSqlQuery(String, FilterObj, DataTable) |
Returns a table row count SqlQuery object.
|
| GetTableRowCountSqlQuery(String, FilterObj, DataTable, Boolean) |
Returns a table row count query using GPS encoding check in the where clause.
|
| GetTableRowCountSqlQuery(String, SqlQuery, DataTable, Boolean) |
Generate a table row count sql query object.
|
| GetTableSetForReport(ReportObj) |
Returns a unique list of tables used by the given ReportObj.
|
| GetTableSetForReport(SqlQuery, SqlQuery) |
Returns a list of table reference by a report query.
|
| GetTableSetForReportWithCrash |
Returns a unique list of tables used by the given SqlQuery objects.
|
| GetTableSubset(DataTable, String, List String ) |
Returns a sub table based on column matches against a data table.
|
| GetTableSubset(DataTable, String, String, String, String) |
Returns a sub table based on column matches against a data table.
|
| GetTableToken |
Returns a tbale token.
|
| GetTopCountToken(String, Int32) |
Returns a select clause COUNT token.
|
| GetTopCountToken(String, String, Int32) |
Returns a select clause COUNT token.
|
| GetTopToken(Int32) |
Returns a select clause TOP token.
|
| GetTopToken(String, Int32) |
Returns a select clause TOP token.
|
| GetUnionToken(Int32) |
Returns UNION token.
|
| GetUnionToken(String, Int32) |
Returns UNION token.
|
| GetValueToken(String, Int32, SqlDataType) |
Returns a custom, default value token.
|
| GetValueToken(String, String, Int32, SqlDataType) |
Returns a custom, default value token. Default name should be 'value'.
|
| GetWhereToken(Int32) |
Returns a default where token.
|
| GetWhereToken(String, Int32) |
Returns a default where token. Defualt name should be 'where'.
|
| SearchDataTable(DataTable, String, String) |
Searches a data table for a row that has a specific value at the specified column.
Uses string ToLower().ToTrim() comparison.
|
| SearchDataTable(DataTable, String, String, String, String) |
Searches the given DataTable for matches on both column value parameters passed in.
|
| SearchDataTable(DataTable, String, String, String, String, String, String) |
Searches a datatable and returns the first row that matches on the 3 column, value pairs.
|
| SearchForColumnValuePair |
Search a list for a column value pair.
|
| SelectEntryAsStatisticQuery |
Combines a set of SqlSelectEntry objects into an SqlQuery object.
|
| StatisticQueryAsHtml |
Returns an HTML representation of the passed in SqlQuery object.
Expects a coded or literal core select criteria query.
|
| StatisticQueryAsSelectEntry |
Parses a valid statistic query and returns a list of select entry objects.
Expects a coded core select criteria query.
|
Fields
| Name | Description | |
|---|---|---|
 | STAT_RESULTS_ERROR_LOG |
Holds a list of web service errors from running a stat query set.
Deprecated, updated method uses a QueryResultSet.
|
| STAT_RESULTS_SQL_LOG |
Holds a list of SQL queries generated when calculating statistics.
Deprecated, updated method uses a QueryResultSet.
|
See Also