Wie können wir Ihnen helfen?
-
Latest Updates
-
Tool Suite 8.0
-
-
- Set field
- Verify field
- Verify field against reference value
- Read out field
- Call method
- Verify message
- Drag & Drop
- Browser instruction
- Call SAP function
- Call Data Manager
- Call ranorex test
- Verify PDF
- Set variable
- Verify variable
- Calculation
- Assemble text
- Extract text
- Save value to file
- Load value from file
- Insert Wait Step
- Insert screenshot manually
- Resize
- Close browser tab
- ... >15 <
-
-
- User interface - General
- User interface - Menu bar
- User interface - Table search / opened test cases
- User interface - Query editor
- User interface - Results area
- User interface - Parameters / variable mapping
- User Interface - Attachments
- Quick settings - Show intermediate results
- Used Shortcuts
- ... >1 <
-
-
-
Tool Suite 7.0
-
-
- Set field
- Verify field
- Read out field
- Call method
- Verify message
- Drag & Drop
- Browser instruction
- Call SAP function
- Call ranorex test
- Set variable
- Verify variable
- Calculation
- Assemble text
- Extract text
- Save value to file
- Load value from file
- Insert Wait Step
- Insert screenshot manually
- Resize
- Close browser tab
- ... >12 <
-
-
- User interface - General
- User interface - Menu bar
- User interface - Table search / opened test cases
- User interface - Query editor
- User interface - Results area
- User interface - Parameters / variable mapping
- User Interface - Attachments
- Quick settings - Show intermediate results
- Used Shortcuts
- ... >1 <
-
-
-
Tool Suite 6.4
-
-
-
- User interface - General
- User interface - Menu bar
- User interface - Table search / opened test cases
- User interface - Query editor
- User interface - Results area
- User interface - Parameters / variable mapping
- User Interface - Attachments
- Quick settings - Show intermediate results
- Used Shortcuts
- ... >1 <
-
-
-
Premium Support
-
- Artikel kommen bald
-
- Artikel kommen bald
< Zurück
Drucken
SapQuery
Veröffentlicht17. April 2023
Geändert8. November 2023
VonAlexandra Klettenhofer
With a SapQuery, an OpenSQL query is executed against the database via the server module.
Attributes:
Attribute | Required | Description |
---|---|---|
Id | Yes | Unique Id in the query tree |
DependsOn | No | Optional dependency on one another query node |
Select | Yes | Select part of the query |
From | Yes | From part of the query |
Where, GroupBy, Having, OrderBy | No | Optional parts of the query |
QueryLimit | No | Limit for the rows that applies to the execution of the SQL Statements. Is mapped to "UP TO" in OpenSQL. Note: It is recommended to always set a low limit first, otherwise long query times could occur when more SapQueries follow in the execution tree. |
ResultLimit | No | Limit for the rows that applies to the execution of the node. No more queries will be run on the database once the node limit is reached. Therefore, the maximum of rows returned is the number specified in ResultLimit. |
ResultMapping | No | List of target fields for the result columns from the Select. Is required, when
Optionally, the result column can be renamed with an alias. Format: Table~Column[~Alias] |
ResultFilters | No | List of result processing |
Syntax:
The syntax for the OpenSQL parts is limited to version 7.31. If elements of a newer syntax are used, the error message TS-40001 appears.
SELECT { * | { {col1|aggregate( [DISTINCT] col1 )} [AS a1] {col2|aggregate( [DISTINCT] col2 )} [AS a2] ... } FROM { { {dbtab [AS tabalias]} | { [(] {dbtab_left [AS tabalias_left]} | join {[INNER] JOIN}|{LEFT [OUTER] JOIN} {dbtab_right [AS tabalias_right] ON join_cond} [)]} [UP TO n ROWS] WHERE sql_cond] [GROUP BY {col1 col2 ...}|(column_syntax)] [HAVING sql_cond] [ORDER BY { {PRIMARY KEY} |{{{col1|a1} [ASCENDING|DESCENDING]} {{col2|a2} [ASCENDING|DESCENDING]} ... }
Inhaltsverzeichnis