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

Inherits: Consultingwerk.OERA.QueryBuilder.TableQuery

File:SmartLockQuery
Author(s):Richard Kelters / Consultingwerk Ltd.
Created:02/12/2018 14:57:16.729+01:00

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



Top Method Summary
Options Name Purpose
+ Consultingwerk.SmartFramework.Lock.SmartLockQuery And (SmartLockQuery) Joins a Query Entry using AND
+ Consultingwerk.SmartFramework.Lock.SmartLockQuery And (SmartLockQuery, SmartLockQuery) Joins two Query Entries using AND
+ Consultingwerk.SmartFramework.Lock.SmartLockQuery And (SmartLockQuery, SmartLockQuery, SmartLockQuery) 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.Lock.SmartLockQuery Or (SmartLockQuery) Joins a Query Entry using OR
+ Consultingwerk.SmartFramework.Lock.SmartLockQuery Or (SmartLockQuery, SmartLockQuery) Joins two Query Entries using OR
+ Consultingwerk.SmartFramework.Lock.SmartLockQuery Or (SmartLockQuery, SmartLockQuery, SmartLockQuery) 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
+ SmartLockQuery () Constructor for the SmartLockQuery class
+ SmartLockQuery (character) Constructor for the SmartLockQuery class

Top Property Summary
Options Name Purpose
+ Consultingwerk.SmartFramework.Lock.SmartLockQuery And
+ Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate KeyValues
+ Consultingwerk.SmartFramework.Lock.SmartLockQueryDateTimeTzPredicate LockCreated
+ Consultingwerk.SmartFramework.Lock.SmartLockQueryDateTimeTzPredicate LockExpires
+ Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate LockGuid
+ Consultingwerk.SmartFramework.Lock.SmartLockQueryDateTimeTzPredicate LockRefreshed
+ Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate LockResourceIdentifier
+ Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate LockSessionId
+ Consultingwerk.SmartFramework.Lock.SmartLockQuery Or
+ Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate TableGuid
+ Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate UserGuid


Method Detail
Top

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

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

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

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

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

Parameters:
poQuery1 Consultingwerk.SmartFramework.Lock.SmartLockQuery
The first SmartLockQuery instance to join using AND
poQuery2 Consultingwerk.SmartFramework.Lock.SmartLockQuery
The second SmartLockQuery instance to join using AND
poQuery3 Consultingwerk.SmartFramework.Lock.SmartLockQuery
The third SmartLockQuery instance to join using AND
Returns Consultingwerk.SmartFramework.Lock.SmartLockQuery
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.Lock.SmartLockQuery Or (SmartLockQuery)
Purpose: Joins a Query Entry using OR
Notes:

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

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

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

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

Parameters:
poQuery1 Consultingwerk.SmartFramework.Lock.SmartLockQuery
The first SmartLockQuery instance to join using OR
poQuery2 Consultingwerk.SmartFramework.Lock.SmartLockQuery
The second SmartLockQuery instance to join using OR
poQuery3 Consultingwerk.SmartFramework.Lock.SmartLockQuery
The third SmartLockQuery instance to join using OR
Returns Consultingwerk.SmartFramework.Lock.SmartLockQuery
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 SmartLockQuery ()
Purpose: Constructor for the SmartLockQuery class
Notes:

Top

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

Parameters:
pLockGuid CHARACTER
The filter value for the eSmartLock.LockGuid field


Property Detail
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQuery And

Returns Consultingwerk.SmartFramework.Lock.SmartLockQuery
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate KeyValues

Returns Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQueryDateTimeTzPredicate LockCreated

Returns Consultingwerk.SmartFramework.Lock.SmartLockQueryDateTimeTzPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQueryDateTimeTzPredicate LockExpires

Returns Consultingwerk.SmartFramework.Lock.SmartLockQueryDateTimeTzPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate LockGuid

Returns Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQueryDateTimeTzPredicate LockRefreshed

Returns Consultingwerk.SmartFramework.Lock.SmartLockQueryDateTimeTzPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate LockResourceIdentifier

Returns Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate LockSessionId

Returns Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQuery Or

Returns Consultingwerk.SmartFramework.Lock.SmartLockQuery
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate TableGuid

Returns Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate UserGuid

Returns Consultingwerk.SmartFramework.Lock.SmartLockQueryCharacterPredicate


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