From version < 18.2 >
edited by gru
on 05.05.2020, 12:31
To version < 18.3 >
edited by gru
on 14.10.2020, 14:13
< >
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -38,8 +38,10 @@
38 38  |name|Must match the name of the database query.|Yes
39 39  |clientName|Must match the name of the client used for creating this data source.|Yes, if //projektId// is not given
40 40  |projektId|Must match the ID of the form. This information can be seen by accessing the {{code language="javascript"}}XFC_METADATA.currentProject.id{{/code}} object from JavaScript.|Yes, if //mandantName// is not given
41 -|sqlParameter|Alias for //queryParameter//. This is deprecated from version 6 and should not be used anymore. It may be removed in future releases.|
42 -|queryParameter|Yes, if placeholders ( ? ) are used in the query. Must be a comma separated list of parameters and match the number of parameters used in the SQL query (from version 6).|No
41 +|--sqlParameter--|Alias for //queryParameter//. Should no longer be used in {{formcycle/}} version 6 and will most likely be removed in the next major release of {{formcycle/}}.|
42 +|queryParameter|When the query contains placeholders (question marks, {{code language="none"}}?{{/code}}), a list of parameters must be supplied for each placeholder. The number of items must match the number of parameters used in the SQL query. The items are separated with the delimiter as defined by the URL parameter //delimiter//.
43 +
44 +If possible the parameter //queryParameterValues// should be used for new projects instead of //queryParameter// because //queryParameter// will not be supported in a future version of {{formcycle/}}.|No
43 43  |varName|Allows you to change name of the JSON response object. If not given, a plain JSON object with the result data is returned.|No
44 44  |delimiter|The delimiter for the placeholder values, see //queryParameter//. Defaults to a comma {{code language="none"}},{{/code}}|No
45 45  
Copyright 2000-2024