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

Inherits: Consultingwerk.OERA.QueryBuilder.TableQuery

File:SmartProductQuery
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:13/10/2017 14:38:11,337+02:00

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



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

Top Property Summary
Options Name Purpose
+ Consultingwerk.SmartFramework.Menu.SmartProductQuery And
+ Consultingwerk.SmartFramework.Menu.SmartProductQuery Or
+ Consultingwerk.SmartFramework.Menu.SmartProductQueryCharacterPredicate ProductCode
+ Consultingwerk.SmartFramework.Menu.SmartProductQueryCharacterPredicate ProductGuid
+ Consultingwerk.SmartFramework.Menu.SmartProductQueryLogicalPredicate ProductInstalled
+ Consultingwerk.SmartFramework.Menu.SmartProductQueryCharacterPredicate ProductName


Method Detail
Top

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

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

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

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

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

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

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

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

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

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

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

Top

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

Parameters:
pProductGuid CHARACTER
The filter value for the eSmartProduct.ProductGuid field


Property Detail
Top

PUBLIC Consultingwerk.SmartFramework.Menu.SmartProductQuery And

Returns Consultingwerk.SmartFramework.Menu.SmartProductQuery
Top

PUBLIC Consultingwerk.SmartFramework.Menu.SmartProductQuery Or

Returns Consultingwerk.SmartFramework.Menu.SmartProductQuery
Top

PUBLIC Consultingwerk.SmartFramework.Menu.SmartProductQueryCharacterPredicate ProductCode

Returns Consultingwerk.SmartFramework.Menu.SmartProductQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Menu.SmartProductQueryCharacterPredicate ProductGuid

Returns Consultingwerk.SmartFramework.Menu.SmartProductQueryCharacterPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Menu.SmartProductQueryLogicalPredicate ProductInstalled

Returns Consultingwerk.SmartFramework.Menu.SmartProductQueryLogicalPredicate
Top

PUBLIC Consultingwerk.SmartFramework.Menu.SmartProductQueryCharacterPredicate ProductName

Returns Consultingwerk.SmartFramework.Menu.SmartProductQueryCharacterPredicate


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