en EN de DE
topbar test
en EN de DE
Search site...
Wie können wir Ihnen helfen?
< Zurück
Drucken

Parameters – Usage

Veröffentlicht18. April 2023
Geändert14. May 2024
VonAlexandra Klettenhofer

Usage:

TypeUsable inOverwriteable in the suxxesso Test Cockpit
Predefined parametersworkspace parameters, test case parameters, query editor, query nodesNo
Work space parameterstest case parameters, query editor, query nodes, variable mappingYes
Test case parametersquery editor, query nodes, variable mappingYes
Implicit parametersquery nodes, variable mapping (from result nodes)No

 

Substitution of implicit parameters in query nodes:

SapQuerySapFunction
SelectParameters
From
Where

 

Query nodes / workspace parameters / test case parameters:

In the query nodes (or in the workspace and test case parameters), the following syntax must be considered for the use of parameters :

${Parametername}

--- !SapQuery
Id: Sample
Select: '*'
From: T001
Where: BUKRS = '${CompanyCode}'

 

Escaping:

Da das Dollarzeichen “$” für die Parameterplatzhalter verwendet wird, muss dieses in den Abfragen durch Voranstellen eines weiteren Dollarzeichens escaped werden.

--- !ClientQuery
Id: Escaping
Statement: Select '$${Parametername}' as Column

Result:

Column
${Parametername}

 

Double parameter escaping:

Since substitution occurs throughout the document as well as at the node level, double escaping must be used for a node parameter with parameter substitution.

--- !ClientQuery
Id: Escaping
Statement: Select '$$$$' as Dollarsign, '$$$${' as DollarAndBracket

Ergebnis:

DollarsignDollarAndBracket
$${
Tags:
Inhaltsverzeichnis