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.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.Workflow.SmartWorkflowActivityQuery 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 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.Web.SmartRouteQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowInstanceQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowStatusActivityQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowStatusQuery Consultingwerk.SmartFramework.Workflow.SmartWorkflowSwimlaneQuery 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.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
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Parameters:
pcTableName CHARACTER
The name of the table


Property Detail
Top

CHARACTER TableName

Returns CHARACTER


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       30.03.2026 11:05:22