Namespace: Consultingwerk.OERA
Class 
BusinessEntityResultsetMapper Copy to Clipboard
Parent classes:
Inherits: Progress.Lang.Object

File:BusinessEntityResultsetMapper
Purpose:Allows mapping a Business Entity Resultset (ProDataset)
into a Temp-Table
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Fri Dec 12 14:22:42 CET 2014
Notes:SCL-587



Top Method Summary
Options Name Purpose
+ MapResultsetIntoTempTable (handle, character, character, character, table-handle) Appends records from the passed ProDataset to the provided temp-table. Supports joining multiple ProDataset records (parent/child) and field mapping.
+ MapResultsetIntoTempTable (handle, character, character, character, character, table-handle) Appends records from the passed ProDataset to the provided temp-table. Supports joining multiple ProDataset records (parent/child) and field mapping.
+ MapResultsetIntoTempTable (handle, character, character, character, character[], table-handle) Appends records from the passed ProDataset to the provided temp-table. Supports joining multiple ProDataset records (parent/child) and field mapping.
+ MapResultsetIntoTempTable (handle, handle, character, character) Merges ProDataset records from the passed ProDataset to the provided target temp-table record Supports joining multiple ProDataset records (parent/child) and field mapping.
+ MapResultsetIntoTempTable (handle, handle, character, character[]) Merges ProDataset records from the passed ProDataset to the provided target temp-table record Supports joining multiple ProDataset records (parent/child) and field mapping.
+ RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, table-handle) Fetches Records from a Business Entity and appends them based on the provided field mapping to the provided temp-table
+ RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, character, table-handle) Fetches Records from a Business Entity and appends them based on the provided field mapping to the provided temp-table
+ RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, character[], table-handle) Fetches Records from a Business Entity and appends them based on the provided field mapping to the provided temp-table

Top Property Summary
Options Name Purpose
+ CHARACTER AppServerPartition Gets/Sets the name of the AppServer Partition to be used by this class when retrieving data via the ServiceAdaptre


Method Detail
Top

PUBLIC MapResultsetIntoTempTable (handle, character, character, character, table-handle)

Purpose: Appends records from the passed ProDataset to the provided temp-table.
Supports joining multiple ProDataset records (parent/child) and field
mapping.
Notes: The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
calls to this method with the same temp-table. This may be useful
when multiple backend calls (queries to the same or different Business
Entity) should be added to the same view temp-table in a sequence. Like
when populating the AKIOMA SWAT tree of struct records.

Parameters:
phDataset HANDLE
The handle of the ProDataset with the data to map to the temp-table
pcEntityTable CHARACTER
The Entity Table
pcEntityView CHARACTER
The comma delimited list of additional business entity tables
pcEntityTableMappings CHARACTER
The fields to map for the entity table
phTable TABLE-HANDLE
INPUT-OUTPUT BY-REFERENCE The result temp-table
Top

PUBLIC MapResultsetIntoTempTable (handle, character, character, character, character, table-handle)

Purpose: Appends records from the passed ProDataset to the provided temp-table.
Supports joining multiple ProDataset records (parent/child) and field
mapping.
Notes: The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
calls to this method with the same temp-table. This may be useful
when multiple backend calls (queries to the same or different Business
Entity) should be added to the same view temp-table in a sequence. Like
when populating the AKIOMA SWAT tree of struct records.

Parameters:
phDataset HANDLE
The handle of the ProDataset with the data to map to the temp-table
pcEntityTable CHARACTER
The Entity Table
pcEntityView CHARACTER
The comma delimited list of additional business entity tables
pcEntityTableMappings CHARACTER
The fields to map for the entity table
pcEntityViewMappings CHARACTER
The comma delimited list of fields to map for the entity view table (only one)
phTable TABLE-HANDLE
INPUT-OUTPUT BY-REFERENCE The result temp-table
Top

PUBLIC MapResultsetIntoTempTable (handle, character, character, character, character[], table-handle)

Purpose: Appends records from the passed ProDataset to the provided temp-table.
Supports joining multiple ProDataset records (parent/child) and field
mapping.
Notes: The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
calls to this method with the same temp-table. This may be useful
when multiple backend calls (queries to the same or different Business
Entity) should be added to the same view temp-table in a sequence. Like
when populating the AKIOMA SWAT tree of struct records.

Parameters:
phDataset HANDLE
The handle of the ProDataset with the data to map to the temp-table
pcEntityTable CHARACTER
The Entity Table
pcEntityView CHARACTER
The comma delimited list of additional business entity tables
pcEntityTableMappings CHARACTER
The fields to map for the entity table
pcEntityViewMappings CHARACTER
The Character array of fields to map for the entity view tables, extent of the array needs to match the number of view tables
phTable TABLE-HANDLE
INPUT-OUTPUT BY-REFERENCE The result temp-table
Top

PUBLIC MapResultsetIntoTempTable (handle, handle, character, character)

Purpose: Merges ProDataset records from the passed ProDataset to the provided
target temp-table record
Supports joining multiple ProDataset records (parent/child) and field
mapping.
Notes: The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
calls to this method with the same temp-table. This may be useful
when multiple backend calls (queries to the same or different Business
Entity) should be added to the same view temp-table in a sequence. Like
when populating the AKIOMA SWAT tree of struct records.

Parameters:
phTempTableBuffer HANDLE
The buffer of a temp-table to copy the record to
phQueryHandle HANDLE
The handle of the query that joins the EntityTable with the EntityView Tables. This query needs to be repositioned (by your code) to the proper result row
pcEntityTableMappings CHARACTER
The fields to map for the entity table
pcEntityViewMappings CHARACTER
The comma delimited list of fields to map for the entity view tables, extent of the array needs to match the number of view tables
Top

PUBLIC MapResultsetIntoTempTable (handle, handle, character, character[])

Purpose: Merges ProDataset records from the passed ProDataset to the provided
target temp-table record
Supports joining multiple ProDataset records (parent/child) and field
mapping.
Notes: The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
calls to this method with the same temp-table. This may be useful
when multiple backend calls (queries to the same or different Business
Entity) should be added to the same view temp-table in a sequence. Like
when populating the AKIOMA SWAT tree of struct records.

Parameters:
phTempTableBuffer HANDLE
The buffer of a temp-table to copy the record to
phQueryHandle HANDLE
The handle of the query that joins the EntityTable with the EntityView Tables. This query needs to be repositioned (by the callers code) to the proper result row
pcEntityTableMappings CHARACTER
The fields to map for the entity table
pcEntityViewMappings CHARACTER
The Character array of fields to map for the entity view tables, extent of the array needs to match the number of view tables
Top

PUBLIC RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, table-handle)

Purpose: Fetches Records from a Business Entity and appends them based on
the provided field mapping to the provided temp-table
Notes: The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
calls to this method with the same temp-table. This may be useful
when multiple backend calls (queries to the same or different Business
Entity) should be added to the same view temp-table in a sequence. Like
when populating the AKIOMA SWAT tree of struct records.

Parameters:
pcBusinessEntity CHARACTER
The Business Entity Name to retrieve records from
pcEntityTable CHARACTER
The Entity Table
pcEntityView CHARACTER
The comma delimited list of additional business entity tables
poQueryExpression Consultingwerk.IQueryExpression
The QueryExpression to use for the filter
pcEntityTableMappings CHARACTER
The fields to map for the entity table
phTable TABLE-HANDLE
INPUT-OUTPUT BY-REFERENCE The result temp-table
Top

PUBLIC RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, character, table-handle)

Purpose: Fetches Records from a Business Entity and appends them based on
the provided field mapping to the provided temp-table
Notes: The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
calls to this method with the same temp-table. This may be useful
when multiple backend calls (queries to the same or different Business
Entity) should be added to the same view temp-table in a sequence. Like
when populating the AKIOMA SWAT tree of struct records.

Parameters:
pcBusinessEntity CHARACTER
The Business Entity Name to retrieve records from
pcEntityTable CHARACTER
The Entity Table
pcEntityView CHARACTER
The comma delimited list of additional business entity tables
poQueryExpression Consultingwerk.IQueryExpression
The QueryExpression to use for the filter
pcEntityTableMappings CHARACTER
The fields to map for the entity table
pcEntityViewMappings CHARACTER
The comma delimited list fields to map for the entity view table (only the first one)
phTable TABLE-HANDLE
INPUT-OUTPUT BY-REFERENCE The result temp-table
Top

PUBLIC RetrieveDataAndMapResultset (character, character, character, IQueryExpression, character, character[], table-handle)

Purpose: Fetches Records from a Business Entity and appends them based on
the provided field mapping to the provided temp-table
Notes: The Temp-Table is received as INPUT-OUTPUT Parameter to allow multiple
calls to this method with the same temp-table. This may be useful
when multiple backend calls (queries to the same or different Business
Entity) should be added to the same view temp-table in a sequence. Like
when populating the AKIOMA SWAT tree of struct records.

Parameters:
pcBusinessEntity CHARACTER
The Business Entity Name to retrieve records from
pcEntityTable CHARACTER
The Entity Table
pcEntityView CHARACTER
The comma delimited list of additional business entity tables
poQueryExpression Consultingwerk.IQueryExpression
The QueryExpression to use for the filter
pcEntityTableMappings CHARACTER
The fields to map for the entity table
pcEntityViewMappings CHARACTER
The Character array of fields to map for the entity view tables, extent of the array needs to match the number of view tables
phTable TABLE-HANDLE
INPUT-OUTPUT BY-REFERENCE The result temp-table


Property Detail
Top

PUBLIC CHARACTER AppServerPartition

Purpose: Gets/Sets the name of the AppServer Partition to be used
by this class when retrieving data via the ServiceAdaptre
Notes: Only relevant when running on the client side (no databases connected)

Returns CHARACTER


©2006-2016 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       26.08.2016 08:29:43