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

Inherits: Consultingwerk.OERA.QueryBuilder.TableQuery

File:SmartBusinessEntityQuery
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:14/10/2017 08:26:00,756+02:00

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



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

Top Constructor Summary
Options Name Purpose
+ SmartBusinessEntityQuery () Constructor for the SmartBusinessEntityQuery class
+ SmartBusinessEntityQuery (character) Constructor for the SmartBusinessEntityQuery class

Top Property Summary
Options Name Purpose
+ Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery And
+ Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate BusinessEntityGuid
+ Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate BusinessEntityName
+ Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate BusinessEntityPackage
+ Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate BusinessEntityPurpose
+ Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryLogicalPredicate DBRequired
+ Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery Or
+ Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryLogicalPredicate TrackDeletions


Method Detail
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery And (SmartBusinessEntityQuery)
Purpose: Joins a Query Entry using AND
Notes:

Parameters:
poQuery Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The SmartBusinessEntityQuery instance to join using AND
Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The reference to the instance the call was issued on
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery And (SmartBusinessEntityQuery, SmartBusinessEntityQuery)
Purpose: Joins two Query Entries using AND
Notes:

Parameters:
poQuery1 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The first SmartBusinessEntityQuery instance to join using AND
poQuery2 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The second SmartBusinessEntityQuery instance to join using AND
Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The reference to the instance the call was issued on
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery And (SmartBusinessEntityQuery, SmartBusinessEntityQuery, SmartBusinessEntityQuery)
Purpose: Joins three Query Entries using AND
Notes:

Parameters:
poQuery1 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The first SmartBusinessEntityQuery instance to join using AND
poQuery2 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The second SmartBusinessEntityQuery instance to join using AND
poQuery3 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The third SmartBusinessEntityQuery instance to join using AND
Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The reference to the instance the call was issued on
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery AndImpl ()
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Add's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry 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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: And's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 QueryEntry
The first Query entry to And to the current list
poQueryEntry2 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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: And's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 QueryEntry
The first Query entry to And to the current list
poQueryEntry2 QueryEntry
The second Query entry to And to the current list
poQueryEntry3 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 ()
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Add not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry 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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: And not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 QueryEntry
The first Query entry to And to the current list
poQueryEntry2 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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: And not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 QueryEntry
The first Query entry to And to the current list
poQueryEntry2 QueryEntry
The second Query entry to And to the current list
poQueryEntry3 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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Inserts a Query Entry to the current list of Query Entries
Notes: Applies the pending Join specifier to the Query Entry

Parameters:
poQueryEntry QueryEntry
The QueryEntry to insert to the query
Top

PROTECTED JoinEnum JoinOperator (JoinEnum, JoinEnum)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Determines the resulting Join operator based on the entries
Join and the position in the Query
Notes:

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

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery Or (SmartBusinessEntityQuery)
Purpose: Joins a Query Entry using OR
Notes:

Parameters:
poQuery Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The SmartBusinessEntityQuery instance to join using OR
Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The reference to the instance the call was issued on
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery Or (SmartBusinessEntityQuery, SmartBusinessEntityQuery)
Purpose: Joins two Query Entries using OR
Notes:

Parameters:
poQuery1 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The first SmartBusinessEntityQuery instance to join using OR
poQuery2 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The second SmartBusinessEntityQuery instance to join using OR
Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The reference to the instance the call was issued on
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery Or (SmartBusinessEntityQuery, SmartBusinessEntityQuery, SmartBusinessEntityQuery)
Purpose: Joins three Query Entries using OR
Notes:

Parameters:
poQuery1 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The first SmartBusinessEntityQuery instance to join using OR
poQuery2 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The second SmartBusinessEntityQuery instance to join using OR
poQuery3 Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The third SmartBusinessEntityQuery instance to join using OR
Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
The reference to the instance the call was issued on
Top

PROTECTED Consultingwerk.OERA.QueryBuilder.TableQuery OrImpl ()
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Or's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry 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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Or's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 QueryEntry
The first Query entry to Or to the current list
poQueryEntry2 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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Or's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 QueryEntry
The first Query entry to Or to the current list
poQueryEntry2 QueryEntry
The second Query entry to Or to the current list
poQueryEntry3 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 ()
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Or not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry 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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Or not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 QueryEntry
The first Query entry to Or to the current list
poQueryEntry2 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)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
Purpose: Or not's a QueryEntry to the current list
Notes:

Parameters:
poQueryEntry1 QueryEntry
The first Query entry to Or to the current list
poQueryEntry2 QueryEntry
The second Query entry to Or to the current list
poQueryEntry3 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 QueryDefinition ToQueryDefinition ()
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
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 QueryDefinition
The QueryDefinition representing this query
Top

PUBLIC QueryEntry ToQueryEntry ()
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
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 QueryEntry
The QueryGroup or QueryPredicate representing this query
Top

PUBLIC CHARACTER ToQueryString (logical)
Inherited from Consultingwerk.OERA.QueryBuilder.TableQuery
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

PUBLIC SmartBusinessEntityQuery ()
Purpose: Constructor for the SmartBusinessEntityQuery class
Notes:

Top

PUBLIC SmartBusinessEntityQuery (character)
Purpose: Constructor for the SmartBusinessEntityQuery class
Notes:

Parameters:
pBusinessEntityGuid CHARACTER
The filter value for the eSmartBusinessEntity.BusinessEntityGuid field


Property Detail
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery And

Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate BusinessEntityGuid

Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate BusinessEntityName

Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate BusinessEntityPackage

Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate BusinessEntityPurpose

Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryLogicalPredicate DBRequired

Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryLogicalPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery Or

Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQuery
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryLogicalPredicate TrackDeletions

Returns Consultingwerk.SmartFramework.System.SmartBusinessEntityQueryLogicalPredicate


©2006-2020 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       04.02.2020 23:28:43