Top Method Summary
Options Name Purpose
Consultingwerk.OERA.IFetchDataRequest BuildFetchDataRequest () Builds the IFetchDataRequest for the current ttEntitySearchQuery record
DiscardRows () Removes the rows already produced for the current ttEntitySearchQuery record
ExecuteQuery () Executes the query of the current ttEntitySearchQuery record and creates its ttEntitySearchRow records
CHARACTER QualifiedFieldList () Returns the Fields of the current ttEntitySearchQuery record as the table.field list an IFetchDataRequest expects
Search (dataset) Executes every query of the dataset and returns the matching records as ttEntitySearchRow records


Method Detail
Top

Consultingwerk.OERA.IFetchDataRequest BuildFetchDataRequest ()

Purpose: Builds the IFetchDataRequest for the current
ttEntitySearchQuery record
Notes: The Fields option limits what the DataAccess layer reads to
the columns that are actually returned to the caller

Returns Consultingwerk.OERA.IFetchDataRequest
The IFetchDataRequest for the current query
Top

DiscardRows ()

Purpose: Removes the rows already produced for the current
ttEntitySearchQuery record
Notes: A failed query must not return a partial result alongside its
error message. Whether the rows created before the failure
are rolled back by the enclosing block depends on whether a
transaction is active, so they are removed explicitly here

Top

ExecuteQuery ()

Purpose: Executes the query of the current ttEntitySearchQuery record
and creates its ttEntitySearchRow records
Notes: Operates on the ttEntitySearchQuery record the caller is
positioned on

Top

CHARACTER QualifiedFieldList ()

Purpose: Returns the Fields of the current ttEntitySearchQuery record
as the table.field list an IFetchDataRequest expects
Notes:

Returns CHARACTER
The comma-delimited list of table.field entries
Top

Search (dataset)

Purpose: Executes every query of the dataset and returns the matching
records as ttEntitySearchRow records
Notes: The RowCount and ErrorMessage fields of a query record are
filled by this method and travel back to the caller in the
same dataset.
SCL-5983: Published as the REST method
POST /SmartFramework/Search/EntitySearch for the web command
palette. The request body carries the dsEntitySearch dataset
with the ttEntitySearchQuery records, the response returns the
same dataset with the ttEntitySearchRow records nested below
their query (data-relation drQueryRow on RequestId):
- RowCount of a query is the number of rows returned for it,
limited by MaxRows (0 = no limit)
- A query that fails does not fail the request - its
ErrorMessage is set, it returns no rows and the other
queries still return their rows. This includes a query
rejected by IRequestAuthorizationProvider:IsFetchDataRestricted,
as every query is executed through ServiceInterface:FetchData
- FieldValues holds the values of the FieldNames of the query,
in that order, delimited by CHR(1) - in JSON that is the
character \u0001 the client splits on

Parameters:
dsEntitySearch DATASET dsEntitySearch
INPUT-OUTPUT The dataset with the queries to execute


ProDataset Detail

ProDataset dsEntitySearch

Member tables: ttEntitySearchQuery, ttEntitySearchRow


Temp-Table Detail

Temp-Table ttEntitySearchQuery

Defined in:

Temp-Table ttEntitySearchRow

Defined in:


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       10.10.2026 15:31:26