Namespace: Consultingwerk.OERA.QueryBuilder
Class 
TableQuery Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.OERA.QueryBuilder.TableQuery

Inherits: Progress.Lang.Object
Inherited by: Consultingwerk.SmartFramework.Authentication.SmartUserProfileQuery Consultingwerk.SmartFramework.Authentication.SmartUserQuery Consultingwerk.SmartFramework.Authorization.PossibleGroupQuery Consultingwerk.SmartFramework.Authorization.SmartFieldSecurityItemQuery Consultingwerk.SmartFramework.Authorization.SmartGroupQuery Consultingwerk.SmartFramework.Authorization.SmartMenuGroupQuery Consultingwerk.SmartFramework.Authorization.SmartParentGroupQuery Consultingwerk.SmartFramework.Authorization.SmartSecurityAssignmentQuery Consultingwerk.SmartFramework.Authorization.SmartSecurityObjectQuery Consultingwerk.SmartFramework.Authorization.SmartSecurityObjectTokenQuery Consultingwerk.SmartFramework.Authorization.SmartSecurityRealmQuery Consultingwerk.SmartFramework.Authorization.SmartSecurityTokenQuery Consultingwerk.SmartFramework.Authorization.SmartToolbarSecurityItemQuery Consultingwerk.SmartFramework.Authorization.SmartUserGroupQuery Consultingwerk.SmartFramework.Authorization.UserGroupPossibleAssignmentsQuery Consultingwerk.SmartFramework.Context.SmartContextStoreQuery Consultingwerk.SmartFramework.Lock.SmartLockQuery Consultingwerk.SmartFramework.Menu.SmartFunctionQuery Consultingwerk.SmartFramework.Menu.SmartMenuQuery Consultingwerk.SmartFramework.Menu.SmartMenuStyleQuery Consultingwerk.SmartFramework.Menu.SmartModuleQuery Consultingwerk.SmartFramework.Web.SmartRouteQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowActivityQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowInstanceQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowStatusActivityQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowStatusQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowSwimlaneQuery Consultingwerk.SmartFramework.Scheduler.SmartSchedulerJobPlanQuery Consultingwerk.SmartFramework.Scheduler.SmartSchedulerJobQuery Consultingwerk.SmartFramework.Scheduler.SmartSchedulerJobStatusQuery Consultingwerk.SmartFramework.Scheduler.SmartSchedulerQueueQuery Consultingwerk.SmartFramework.System.ImportFileStatus.SmartImportFileStatusQuery Consultingwerk.SmartFramework.System.SmartAttachmentQuery Consultingwerk.SmartFramework.System.SmartAttachmentRoleQuery Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery Consultingwerk.SmartFramework.System.SmartBusinessEntityTableQuery Consultingwerk.SmartFramework.System.SmartCache.SmartCacheQuery Consultingwerk.SmartFramework.System.SmartCommentRoleQuery Consultingwerk.SmartFramework.System.SmartConfigurationValueQuery Consultingwerk.SmartFramework.System.SmartDeletionQuery Consultingwerk.SmartFramework.System.SmartKeyFieldAssignmentTypeQuery Consultingwerk.SmartFramework.System.SmartLanguageQuery Consultingwerk.SmartFramework.System.SmartLoginCompanyQuery Consultingwerk.SmartFramework.System.SmartMessageQuery Consultingwerk.SmartFramework.System.SmartModifiedStateQuery Consultingwerk.SmartFramework.System.SmartRelationQuery Consultingwerk.SmartFramework.System.SmartTableQuery Consultingwerk.SmartFramework.System.SmartTranslationQuery Consultingwerk.SmartFramework.System.SmartUiTranslationQuery Consultingwerk.SmartFramework.System.SmartValueListEntryQuery Consultingwerk.SmartFramework.System.SmartValueListQuery Consultingwerk.SmartFramework.System.Tags.SmartTagQuery Consultingwerk.SmartFramework.Menu.SmartProductQuery Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaBusinessEntity.MetaBusinessEntityQuery Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaBusinessEntity.MetaDataRelationQuery Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaBusinessEntity.MetaEntityTableQuery Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaBusinessEntity.MetaRestAddressQuery Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaDataSource.MetaDataSourceQuery Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaEntityTable.MetaDataFieldQuery Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaEntityTable.MetaEntityTableQuery Consultingwerk.SmartFramework.Repository.Class.SmartAttributeGroupQuery Consultingwerk.SmartFramework.Repository.Class.SmartAttributeQuery Consultingwerk.SmartFramework.Repository.Class.SmartAttributeValueQuery Consultingwerk.SmartFramework.Repository.Class.SmartClassTypeQuery Consultingwerk.SmartFramework.Repository.Class.SmartLinkTypeQuery Consultingwerk.SmartFramework.Repository.Class.SmartObjectTypeQuery Consultingwerk.SmartFramework.Repository.Class.SmartSupportedInstanceObjectTypeQuery Consultingwerk.SmartFramework.Repository.Class.SmartSupportedLinkQuery Consultingwerk.SmartFramework.Repository.Customization.SmartCustomizationQuery Consultingwerk.SmartFramework.Repository.Customization.SmartCustomizationResultQuery Consultingwerk.SmartFramework.Repository.Customization.SmartCustomizationTypeQuery Consultingwerk.SmartFramework.Repository.Field.SmartEntityFieldMappingQuery Consultingwerk.SmartFramework.Repository.Object.SmartLinkQuery Consultingwerk.SmartFramework.Repository.Object.SmartObjectInstanceQuery Consultingwerk.SmartFramework.Repository.Object.SmartObjectMasterQuery Consultingwerk.SmartFramework.Repository.Object.SmartPageQuery Consultingwerk.SmartFramework.Repository.ScreenMapping.SmartEntityTableMappingQuery Consultingwerk.SmartFramework.Repository.ScreenMapping.SmartScreenTypeQuery Consultingwerk.SmartFramework.Repository.ScreenMapping.SmartUiTypeQuery
ABSTRACT

File:TableQuery
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Mon May 01 13:45:21 CEST 2017

Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
# Consultingwerk.OERA.QueryBuilder.TableQuery AndImpl () Sets the pending Join qualifier to And
# Consultingwerk.OERA.QueryBuilder.TableQuery AndImpl (QueryEntry) Add's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery AndImpl (QueryEntry, QueryEntry) And's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery AndImpl (QueryEntry, QueryEntry, QueryEntry) And's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery AndNotImpl () Sets the pending Join qualifier to AndNot
# Consultingwerk.OERA.QueryBuilder.TableQuery AndNotImpl (QueryEntry) Add not's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery AndNotImpl (QueryEntry, QueryEntry) And not's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery AndNotImpl (QueryEntry, QueryEntry, QueryEntry) And not's a QueryEntry to the current list
+ InsertQueryEntry (QueryEntry) Inserts a Query Entry to the current list of Query Entries
# Ccs.BusinessLogic.JoinEnum JoinOperator (JoinEnum, JoinEnum) Determines the resulting Join operator based on the entries Join and the position in the Query
# Consultingwerk.OERA.QueryBuilder.TableQuery OrImpl () Sets the pending Join qualifier to Or
# Consultingwerk.OERA.QueryBuilder.TableQuery OrImpl (QueryEntry) Or's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery OrImpl (QueryEntry, QueryEntry) Or's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery OrImpl (QueryEntry, QueryEntry, QueryEntry) Or's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery OrNotImpl () Sets the pending Join qualifier to OrNot
# Consultingwerk.OERA.QueryBuilder.TableQuery OrNotImpl (QueryEntry) Or not's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery OrNotImpl (QueryEntry, QueryEntry) Or not's a QueryEntry to the current list
# Consultingwerk.OERA.QueryBuilder.TableQuery OrNotImpl (QueryEntry, QueryEntry, QueryEntry) Or not's a QueryEntry to the current list
+ Consultingwerk.OERA.Ccs.QueryDefinition ToQueryDefinition () Returns a QueryDefinition for this query
+ Consultingwerk.OERA.Ccs.QueryEntry ToQueryEntry () Returns a QueryGroup or QueryPredicate representing this query
+ CHARACTER ToQueryString (logical) Returns the ABL Query String representing this query string

Top Constructor Summary
Options Name Purpose
# TableQuery (character) Constructor for the TableQueryBuilder class

Top Property Summary
Options Name Purpose
- CHARACTER TableName


Method Detail
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery AndImpl ()
Purpose: Sets the pending Join qualifier to And
Notes:

Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery AndImpl (QueryEntry)
Purpose: Add's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry Consultingwerk.OERA.Ccs.QueryEntry
The Query entry to And to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery AndImpl (QueryEntry, QueryEntry)
Purpose: And's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 Consultingwerk.OERA.Ccs.QueryEntry
The first Query entry to And to the current list
poQueryEntry2 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to And to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery AndImpl (QueryEntry, QueryEntry, QueryEntry)
Purpose: And's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 Consultingwerk.OERA.Ccs.QueryEntry
The first Query entry to And to the current list
poQueryEntry2 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to And to the current list
poQueryEntry3 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to And to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery AndNotImpl ()
Purpose: Sets the pending Join qualifier to AndNot
Notes:

Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery AndNotImpl (QueryEntry)
Purpose: Add not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry Consultingwerk.OERA.Ccs.QueryEntry
The Query entry to And to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery AndNotImpl (QueryEntry, QueryEntry)
Purpose: And not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 Consultingwerk.OERA.Ccs.QueryEntry
The first Query entry to And to the current list
poQueryEntry2 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to And to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery AndNotImpl (QueryEntry, QueryEntry, QueryEntry)
Purpose: And not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 Consultingwerk.OERA.Ccs.QueryEntry
The first Query entry to And to the current list
poQueryEntry2 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to And to the current list
poQueryEntry3 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to And to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PUBLIC InsertQueryEntry (QueryEntry)
Purpose: Inserts a Query Entry to the current list of Query Entries
Notes: Applies the pending Join specifier to the Query Entry

Parameters:
poQueryEntry Consultingwerk.OERA.Ccs.QueryEntry
The QueryEntry to insert to the query
Top

PROTECTED Ccs.BusinessLogic.JoinEnum JoinOperator (JoinEnum, JoinEnum)
Purpose: Determines the resulting Join operator based on the entries
Join and the position in the Query
Notes:

Parameters:
poTargetJoin Ccs.BusinessLogic.JoinEnum
The requests Join operator for the entry
poEntryJoin Ccs.BusinessLogic.JoinEnum
The current Join operator of the entry
Returns Ccs.BusinessLogic.JoinEnum
The resulting JoinEnum value
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery OrImpl ()
Purpose: Sets the pending Join qualifier to Or
Notes:

Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery OrImpl (QueryEntry)
Purpose: Or's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry Consultingwerk.OERA.Ccs.QueryEntry
The Query entry to Or to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery OrImpl (QueryEntry, QueryEntry)
Purpose: Or's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 Consultingwerk.OERA.Ccs.QueryEntry
The first Query entry to Or to the current list
poQueryEntry2 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to Or to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery OrImpl (QueryEntry, QueryEntry, QueryEntry)
Purpose: Or's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 Consultingwerk.OERA.Ccs.QueryEntry
The first Query entry to Or to the current list
poQueryEntry2 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to Or to the current list
poQueryEntry3 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to Or to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery OrNotImpl ()
Purpose: Sets the pending Join qualifier to OrNot
Notes:

Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery OrNotImpl (QueryEntry)
Purpose: Or not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry Consultingwerk.OERA.Ccs.QueryEntry
The Query entry to Or to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery OrNotImpl (QueryEntry, QueryEntry)
Purpose: Or not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 Consultingwerk.OERA.Ccs.QueryEntry
The first Query entry to Or to the current list
poQueryEntry2 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to Or to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery OrNotImpl (QueryEntry, QueryEntry, QueryEntry)
Purpose: Or not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 Consultingwerk.OERA.Ccs.QueryEntry
The first Query entry to Or to the current list
poQueryEntry2 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to Or to the current list
poQueryEntry3 Consultingwerk.OERA.Ccs.QueryEntry
The second Query entry to Or to the current list
Returns Consultingwerk.OERA.QueryBuilder.TableQuery
The reference to the TableQueryInstance for fluid style coding
Top

PUBLIC Consultingwerk.OERA.Ccs.QueryDefinition ToQueryDefinition ()
Purpose: Returns a QueryDefinition for this query
Notes: Unlike the ToQueryEntry() method, this method does also return a valid
QueryDefinition when this TableQuery instance has no entries

Returns Consultingwerk.OERA.Ccs.QueryDefinition
The QueryDefinition representing this query
Top

PUBLIC Consultingwerk.OERA.Ccs.QueryEntry ToQueryEntry ()
Purpose: Returns a QueryGroup or QueryPredicate representing this query
Notes: Returns ? when no entries are present, the QueryPredicate when exactly a single
entry is present and a QueryGroup when multiple entries are present

Returns Consultingwerk.OERA.Ccs.QueryEntry
The QueryGroup or QueryPredicate representing this query
Top

PUBLIC CHARACTER ToQueryString (logical)
Purpose: Returns the ABL Query String representing this query string
Notes:

Parameters:
plQualifyFieldsWithTable LOGICAL
Logical value indicating if the fields should be qualified with the table name
Returns CHARACTER
The ABL Query String representing this query


Constructor Detail
Top

PROTECTED TableQuery (character)
Purpose: Constructor for the TableQueryBuilder class
Notes:

Parameters:
pcTableName CHARACTER
The name of the table


Property Detail
Top

PRIVATE CHARACTER TableName

Returns CHARACTER


©2006-2023 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       15.04.2024 05:52:56