... |
... |
@@ -45,7
+45,7 @@ |
45 |
45 |
|
46 |
46 |
Further we recommend you use the script function [[getDataQuery>>doc:Formcycle.FormDesigner.CodingPanel.ScriptTab.AdditionalScriptFunctions.GetDataQuery]], so you do not have to setup the servlet request manually. The result of the database query is returned as //JSON//. |
47 |
47 |
|
48 |
|
-== Testing the query == |
|
48 |
+== Testen der Abfrage == |
49 |
49 |
|
50 |
50 |
{{info}} |
51 |
51 |
For quick testing of the query the shortcut {{code}}Ctrl + Enter{{/code}} is provided. |
... |
... |
@@ -52,7
+52,7 @@ |
52 |
52 |
{{/info}} |
53 |
53 |
|
54 |
54 |
Database queries can be tested directly from the configuration UI. For this purpose a test console is provided below the SQL editor (see [[figure>>||anchor="fig_data_db_query"]]). |
55 |
|
-In the header of the console there is a row of buttons for controling the query: |
|
55 |
+In the header of the console ther is a row of buttons for controling the query: |
56 |
56 |
|
57 |
57 |
* {{ficon name="database-search"/}}**Perform query** |
58 |
58 |
Runs the database query. If //query parameters// ({{code}}?{{/code}}) are provided the user will be prompted to input values vor those parameters. Otherwise the result of the query will be displayed directly in the //table view//. |
... |
... |
@@ -61,7
+61,7 @@ |
61 |
61 |
Mask for inputting values for query parameters. This option is only available if query parameters ({{code}}?{{/code}}) are used in the SQL query. The individual parameters will be enumerated in the SQL query. Clicking "User parameters for query" {{ficon name="arrow-right-bold-circle-outline2"/}} executes the query with the given parameters. The result will be displayed in the //table view//. |
62 |
62 |
{{lightbox image="data_db_query_test_param_en.png" title="Query parameters are enumerated"/}} |
63 |
63 |
Actual Query in the SQL editor: |
64 |
|
-{{lightbox image="data_db_query_example_de.png" title="Example query"/}} |
|
64 |
+{{lightbox image="data_db_query_example_en.png" title="Example query"/}} |
65 |
65 |
* {{ficon name="table-large"/}}**Table view** |
66 |
66 |
Query result in table view |
67 |
67 |
{{lightbox image="data_db_query_test_table_en.png" title="Query result in table view"/}} |