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

Inherits: Consultingwerk.OERA.QueryBuilder.TableQuery

File:SmartDeletionQuery
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:14/10/2017 08:23:51,174+02:00

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



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

Top Property Summary
Options Name Purpose
+ Consultingwerk.SmartFramework.System.SmartDeletionQuery And
+ Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate DeletionGuid
+ Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate DeletionKeyFieldValues
+ Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate DeletionTable
+ Consultingwerk.SmartFramework.System.SmartDeletionQueryDateTimeTzPredicate DeletionTimeStamp
+ Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate DeletionUser
+ Consultingwerk.SmartFramework.System.SmartDeletionQuery Or


Method Detail
Top

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

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

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

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

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

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

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

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

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

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

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

Top

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

Parameters:
pDeletionguid CHARACTER
The filter value for the eSmartDeletion.Deletionguid field


Property Detail
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartDeletionQuery And

Returns Consultingwerk.SmartFramework.System.SmartDeletionQuery
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate DeletionGuid

Returns Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate DeletionKeyFieldValues

Returns Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate DeletionTable

Returns Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartDeletionQueryDateTimeTzPredicate DeletionTimeStamp

Returns Consultingwerk.SmartFramework.System.SmartDeletionQueryDateTimeTzPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate DeletionUser

Returns Consultingwerk.SmartFramework.System.SmartDeletionQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.System.SmartDeletionQuery Or

Returns Consultingwerk.SmartFramework.System.SmartDeletionQuery


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