NetQuarry Core Help
Namespaces
NetQuarry.Data
MapperKernel Class
MapperKernel Methods
AddField Method
AddMapperCommand Method
ApplyViewState Method
BindElements Method
BindPage Method
BuildClientExpression Method
BuildQueryFilter Method
BuildQueryFrom Method
BuildTableInfo Method
BulkDeleteBegin Method
BulkDeleteEnd Method
BulkInsertBegin Method
BulkInsertEnd Method
BulkUpdateBegin Method
BulkUpdateEnd Method
ClearAllUserFilters Method
Clone Method
Close Method
CreateBndLkup Method
CreateField Method
CurrentGrouping Method
DataChanged Method
DefaultGrouping Method
DefaultSortClause Method
Delete Method
DeleteAll Method
DeleteRelatedFiles Method
DependencyOrderFields Method
DetermineGrouping Method
Dispose Method
DoCommand Method
DupeCheck Method
EscapeExpression Method
Exec Method
ExtractSchemaInfo Method
FieldBehaviorOpts Method
FieldFilterOpts Method
FieldLabel Method
FieldLog Method
FireEvent Method
FireFieldEvent Method
FireRowCurrentEvent Method
GenDataRow Method
GetCaption Method
GetCascadedText Method
GetDescription Method
GetFieldList Method
GetFieldText Method
GetFilter Method
GetFireAndForgetCountHelper Method
GetFrom Method
GetKeyset Method
GetLink Method
GetMapperText Method
GetMissingRequiredFields Method
GetRecordCount Method
GetRecordCountSafe Method
GetRowKeyFields Method
GetSelectedKeys Method
GetSort Method
GrouperField Method
HasPermission Method
Init Method
Insert Method
InternalSetRecordCount Method
IsAttrSet Method
IsCellAttrSet Method
IsConfiguredFor Method
IsGroupedInDatasheet Method
IsGroupingColumns Method
IsOptional Method
IsRequestAction Method
IsUserHidden Method
Layout Method
LayoutOnPost Method
Load Method
LogFieldCounts Method
MapperLog Method
MergeSort Method
MoveBOF Method
MoveFirst Method
MoveLast Method
MoveNew Method
MoveNext Method
MovePrev Method
MoveRelative Method
MoveTo Method
OpenOperationalData Method
PerformExpressionModification Method
Permissions Method
PicklistRefresh Method
PopulateDefaultsFromParent Method
PopulateFields Method
PopulateFromDefaults Method
PopulateFromPage Method
PopulateFromSource Method
PostRequery Method
PreRequery Method
QueryAggregateData Method
QueryOperationalData Method
RegisterMapperLog Method
Requery Method
ResolveExpression Method
ResolveSortSpec Method
ReuseGridData Method
RowDigest Method
RowKeyFilter Method
RowRequery Method
Save Method
SavedFilterApply Method
SaveFilter Method
SelectedKeys Method
Send Method
SetDataSource Method
SetFieldList Method
SetupClientExpressions Method
SetUpFromPageInfo Method
SetValuesFromForm Method
Signature Method
SortSpec Method
SortSpecFieldKey Method
TryGetRowKeys Method
Update Method
UserCanFilter Method
UserOrderedFieldList Method
UseSmartTemplatePopulation Method
Click or drag to resize

MapperKernelBuildQueryFrom Method

Build the FROM clause for the operational data query.

Namespace:  NetQuarry.Data
Assembly:  EAP.Mapper (in EAP.Mapper.dll) Version: 2.0.0.0 (4.6.8.0)
Syntax
Copy
protected string BuildQueryFrom(
	StringList sortSubqueries,
	StringList sortOnClauses,
	StringList sortJoinClauses = null
)

Parameters

sortSubqueries
Type: NetQuarryStringList
Subqueries required to sort on picklist items, if any.
sortOnClauses
Type: NetQuarryStringList
SQL ON clauses for sort subqueries.
sortJoinClauses (Optional)
Type: NetQuarryStringList
SQL JOIN clauses for sort subqueries (INNER or LEFT).

Return Value

Type: String
The SQL FROM clause, including the FROM keyword.
See Also