en EN de DE
topbar test
en EN de DE
Search site...

Blog

Our everyday thoughts are presented here Music, video presentations, photo-shootings and more
    Loading posts...

  • ClientQuery

    A ClientQuery offers the possibility to generate data on the client side or to process data records from incoming nodes or to connect data from queries with constant iterations. The ClientQuery is…

    5. June 2024

  • Query node – General

    In the query editor, a query tree is created by capturing one or more query nodes. This must end in a unique target node. Each node returns a result table that can…

    5. June 2024

  • SapNativeQuery

    A SapNativeQuery offers the option of executing a native query against the database without using a template.   Attributes:   Examples Example 1 – Query: — !SapNativeQuery Id: T001 Statement: Select WAERS,…

    5. June 2024

  • Call Data Manager

    As of release 8.0, it is possible to call up the Data Manager query of another test case during the runtime of a test case. If necessary, position the recording bar at…

    13. May 2024

  • SapQuery

    With a SapQuery, an OpenSQL query is executed against the database via the server module.   Attributes:   As of Release 8, suxxesso Tool Suite supports queries in strict mode. This means…

    7. May 2024

  • Processing of IDocs

    With the suxxesso Tool Suite, XML files can be read in and optionally processed (transformed) via an XSL file. This functionality allows the XML file to be read and dynamically manipulated for…

    26. January 2024

  • Query node – General

    In the query editor, a query tree is created by capturing one or more query nodes. This must end in a unique target node. Each node returns a result table that can…

    25. August 2023

  • TransformXML

    With a TransformXML node, an XML file is read in and optionally processed (transformed) via an XSL file. This functionality allows the XML file to be read and dynamically manipulated for a…

    25. August 2023

  • User Interface – Attachments

    This area is needed for editing XML files. The attachments (files) used in the TransformXML node type are specified here.  

    25. August 2023

  • Constant iterations – General

    Constant iterations can be defined independently of queries in the result area. If a name is assigned to a result column in the variable mapping, it will immediately appear in the constant…

    23. May 2023

  • Constant iterations – Import / Export

    The “Import” or “Export” button imports all constant iterations from an Excel file or exports them to a file. For a correct import, the column name in the Excel file must match…

    23. May 2023

  • UnusedGLAccountNumber

    To search for free numbers via tables T077S or SKA1. Attention: Only numeric number ranges are supported.     Beispiel This example searches for free G/L account numbers for the first 3…

    18. April 2023

  • Unique

    Reduces the result to a unique subset using one or more column lists. It thus offers a similar functionality as GROUP BY or DISTINCT.   Example In the following, a result table…

    18. April 2023

  • FieldTrimFilter

    Removes characters in result columns on the specified side.     Example In this example, a ClientQuery generates 2 result rows on which the filter removes leading zeros. — !ClientQuery Id: TwoAgents…

    18. April 2023

  • FieldPadFilter

    Fills values of result columns with characters up to the specified length.     Example In this example, a ClientQuery generates 3 result rows, on which the filter inserts leading zeros until…

    18. April 2023

  • EmbedQuery

    The EmbedQuery filter executes a separate query tree for each incoming row and appends the result in a new column as a record. This makes it possible, for example, to obtain the…

    18. April 2023

  • DefaultResultRowFilter

    Appends a line to the result if the node itself does not return a result. Attention: There is no check if the column names from the node match the column names from…

    18. April 2023

  • Parameters – Macros

    Macros can be used to define frequently occurring, more complex expressions, for example in the workspace parameters. Macro placeholders can be specified within a parameter value.   Definition: A macro is defined…

    18. April 2023

  • Parameters – Variable mapping

    User-defined parameters can be specified directly in the variable mapping:   Predefined parameters cannot be specified. If you still want to use such a parameter in the variable mapping, it can be…

    18. April 2023

  • Parameters – Usage

    Usage:   Substitution of implicit parameters in query nodes:   Query nodes / workspace parameters / test case parameters: In the query nodes (or in the workspace and test case parameters), the…

    18. April 2023

  • Parameters – General

    Workspace or test case parameters provide the possibility to control the queries in suxxesso Data Manager. Before the query tree is executed, the parameter placeholders are replaced throughout the document. In addition,…

    18. April 2023

  • Node result processing (ResultFilters) – General

    Optionally, ResultFilters can be attached to the SapQuery, ClientQuery or FirstWithResult nodes for processing the node result. The filters are processed in the specified order.   Overview: The following filters are available…

    18. April 2023

  • SapFunction

    The SapFunction is used to call a remote capable module function in SAP (e.g.: BAPIs). Since a function call can return not only one data record, but several tables, there is the…

    17. April 2023

  • SQLite additional features

    RandomNumber Generates an integer random number of the specified length Arguments:   Example: — !ClientQuery Id: RND Statement: Select RandomNumber(7) as RND Result:   RandomIBAN Generates an IBAN with valid check code…

    17. April 2023

  • FirstWithResult

    The FirstWithResult node forwards the result of the first incoming node that returns a result.   Attributes:   Example In this example, 3 input nodes with 3 ClientQueries are simulated. Node A…

    17. April 2023

  • Cache

    The cache node stores the result of the incoming node in an encrypted cache file in %localappdata%\Suxxesso\DataManager\Cache. Thus, other users cannot access the cache of the current user. In case that nothing…

    17. April 2023

  • Call

    The Call node references the target node from another test case.   Attributes:   Example There is a test case “Called.tent” in the “Docu” workspace. This test case has a test case…

    17. April 2023

  • ClientQuery

    A ClientQuery offers the possibility to generate data on the client side or to process data records from incoming nodes. The ClientQuery is based on an in-memory SQLite database (Version 3.38.5). The…

    17. April 2023

  • SapQuery

    With a SapQuery, an OpenSQL query is executed against the database via the server module.   Attributes:   Syntax: The syntax for the OpenSQL parts is limited to version 7.31. If elements…

    17. April 2023

  • Used Shortcuts

    The following shortcuts can be used in the suxxesso Data Manager: CTRL + N = New test case CTRL + O = Open test case CTRL + E = Recently opened test…

    17. April 2023

  • Quick settings – Show intermediate results

    If a node is executed several times due to its dependency on another node, the individual results are not displayed. If this button is activated, the intermediate results are displayed in the…

    17. April 2023

  • User interface – Parameters / variable mapping

    Workspace and test case parameters: In this area, the workspace and test case parameters can be entered.   Variable mapping: In this area, the mapping of a result column in the suxxesso…

    17. April 2023

  • User interface – Results area

    The results area displays the results (and intermediate results) after the execution of the queries as well as the constant iterations. The “Export” button can be used to export the current data…

    17. April 2023

  • User interface – Query editor

    In the query editor, the queries for dynamic data selection can be stored for a test case.   Usage notes: The queries are written in plain text. Using the plus sign at…

    17. April 2023

  • User interface – Table search / opened test cases

    Table search: The table search can be displayed on the left side. If a table name is entered here and the search is started with Enter, the structure of the table is…

    17. April 2023

  • User interface – Menu bar

    Main menu / Burger menu: In the main menu / burger menu following actions are supported: load and save test cases open the settings dialog quick settings   Connection selection: In the…

    17. April 2023

  • User interface – General

    The suxxesso Data Manager user interface is divided into the following areas: User interface – Menu bar User interface – Table search / opened test cases User interface – Query editor User…

    17. April 2023