Changes for page DB-Abfragen

From version 2.1
edited by gru
on 29.06.2021, 14:19
Change comment: Renamed back-links.
To version 4.1
edited by jdr
on 19.07.2021, 14:03
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.gru
1 +XWiki.jdr
Content
... ... @@ -12,17 +12,6 @@
12 12  {{figure image="data_db_query_de.png"}}Configuration screen for creating a database query in: (1) list of existing DB queries, (2) editor for defining the SQL query, (3) settings of the DB query, (4) console for testing the DB query.{{/figure}}
13 13  
14 14  
15 -{{html wiki="true"}}
16 -<div class='xm-figure xm-float-right xm-clear-h2' data-alt='Configuration screen for creating a database query in: (1) list of existing DB queries, (2) editor for defining the SQL query, (3) settings of the DB query, (4) console for testing the DB query.'><div class='xm-figure-inner' style='width:310px'>{{lightbox image='data_db_query_de.png' width='300' group='$height' group='$group' title='Configuration screen for creating a database query in: (1) list of existing DB queries, (2) editor for defining the SQL query, (3) settings of the DB query, (4) console for testing the DB query.'/}}<div class='xm-figure-caption'>Configuration screen for creating a database query in: (1) list of existing DB queries, (2) editor for defining the SQL query, (3) settings of the DB query, (4) console for testing the DB query.</div></div></div>
17 -{{/html}}
18 -
19 -
20 -
21 -{{html wiki="true"}}
22 -<div class='xm-figure xm-float-right xm-clear-h2' data-alt='Configuration screen for creating a database query in: (1) list of existing DB queries, (2) editor for defining the SQL query, (3) settings of the DB query, (4) console for testing the DB query.'><div class='xm-figure-inner' style='width:310px'>{{lightbox image='data_db_query_de.png' width='300' group='$height' group='$group' title='Configuration screen for creating a database query in: (1) list of existing DB queries, (2) editor for defining the SQL query, (3) settings of the DB query, (4) console for testing the DB query.'/}}<div class='xm-figure-caption'>Configuration screen for creating a database query in: (1) list of existing DB queries, (2) editor for defining the SQL query, (3) settings of the DB query, (4) console for testing the DB query.</div></div></div>
23 -{{/html}}
24 -
25 -
26 26  * Open the module "Database queries" and click "New" {{ficon name="plus-circle-outline"/}} in the header of the list (see [[figure>>||anchor="fig_data_db_query"]]).
27 27  * The following data is needed for a Database query:
28 28  ** **Name**: A unique name for the database query
... ... @@ -33,7 +33,7 @@
33 33  
34 34  The entered SQL statement is executed as a prepared statement, which prevents SQL injection attacks. You should not and need not use inverted commas (` or '). Also, you can use question marks ( ? ) as placeholders to build queries dynamically.
35 35  
36 -{{version major="6" minor="4" patch="0"/}} [[Variables>>doc:Formcycle.UserInterface.Variables.WebHome]] can be used in the SQL statements.
25 +[[Variables>>doc:Formcycle.UserInterface.Variables.WebHome]] can be used in the SQL statements.
37 37  
38 38  == Using the database query ==
39 39  
... ... @@ -90,7 +90,7 @@
90 90  
91 91  == Selection form elements ==
92 92  
93 -If you want to display the returned data as options of a [[selection element>>doc:Formcycle.FormDesigner.FormElements.Selection]], you can do so easily by opening the {{designer/}} and selecting the database query as the data source of the selection element.
82 +If you want to display the returned data as options of a [[selection element>>doc:Formcycle.Designer.Form.FormElements.Selection]], you can do so easily by opening the {{designer/}} and selecting the database query as the data source of the selection element.
94 94  
95 95  {{info}}
96 96  Queries that are used in selection elements must not have a question mark "?". Queries with a "?" are not offered as a data source for selection elements.
... ... @@ -100,7 +100,7 @@
100 100  Using the result of a database query as the data source a select element in the {{designer case="dat"/}}.
101 101  {{/figure}}
102 102  
103 -The result of the database query is used to create the options of the [[selection element>>doc:Formcycle.FormDesigner.FormElements.Selection]] in the following order:
92 +The result of the database query is used to create the options of the [[selection element>>doc:Formcycle.Designer.Form.FormElements.Selection]] in the following order:
104 104  
105 105  {{box}}
106 106  Displayed value, submitted value, optional value 1, optional value 2, ...