| ... |
... |
@@ -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. |
| ... |
... |
@@ -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"/}} |