Add a query

In the DATALINK tab you can add database queries.

To add a database query, follow these steps:
  1. Go to DATALINK > Queries.
  2. Select ADD A QUERY.
  3. Fill in the following fields:
    • Name: here you can define a name for your query.
    • DB Connection: here you can select the database connection for which you want to create a query.
    • Query: here you can enter your query.
    • Default clause: here you can define the default clause.
    • Default Order By: here you can define the default order by.
    • ID column name: here you can define the ID column name.
    • ID parameter name: here you can define the ID parameter name.
    • Cast Expression: here you can define the cast expression.
    • Trim Result: if you select this checkbox, the spaces at the end of the result strings will be trimmed.
    • Resulting Column Name Patch
      • Regular Expression: here you can define a regular expression on the resulting column names.
        Note: You can use https://regex101.com as an online regex tester.
      • Replace value: here you can define a replace value for the regular expression.
    • Save Query: here you can define a save query.
  4. Select SAVE.