...
Validation (Rich UI Only)
Please visit the Validation and Error Messages page.
Field Binding Dialog (Rich UI Only)
Please visit the Field Binding page.
Input Type (Rich UI Only)
...
This section allows choices/values to be retrieved from a database file.
Choices database file - Enter the database file to use to populate populate your options/values. When setting your database file it's not required to qualify with library name, although you can. if the library is omitted, the application job's library list will be used.
...
These are values returned from an auto-complete textbox in a successful response from the external program:
| Code Block |
|---|
{
"success": true,
"response": {
"results": [
{
"PNAME": "QUEST BOREAL",
"PRID": "523"
},
{
"PNAME": "QUEST ECLIPSE",
"PRID": "524"
},
{
"PNAME": "QUEST EQUINOX",
"PRID": "525"
}
],
"colWidths": [
30,
10
]
}
}
|
...
This is how the successful response is displayed in the application:. The search criteria (Q in the example below) is posted to the program as field query.
JSON Error Response Example
This example is JSON information returned when the script encounters an error with an external program driven auto-complete.
| Code Block |
|---|
{
"success": false,
"errorId": "08001",
"errorText": "Authorization failure on distributed database connection attempt. SQLCODE=-30082"
}
|
If you are unable to get any information to display on your choice URL script you can use the showErrors() API to try and debug the reason the auto-complete is unable to display results.
showErrors() API Documentation
Example of the showErrors() API displaying the JSON error response example:
...
Full PHP Script Example:
| Code Block |
|---|
<?php
define("MAX", 10);
define("DB", "S100450A");
define("USER", "user");
define("PASS", "password");
$records = array();
$query = "";
$limit = 0;
if (isset($_REQUEST["query"])) $query = $_REQUEST["query"];
if (isset($_REQUEST["limit"])) $limit = intval($_REQUEST["limit"]);
if ($query != "") {
$query = strtoupper($query) . "%";
if ($limit == 0 || $limit > MAX) $limit = MAX;
// Example of error reporting.
$con = db2_connect(DB, USER, PASS, array("i5_naming" => DB2_I5_NAMING_ON));
if (!$con) {
$response = array(
"success" => false,
"errorId" => db2_conn_error(),
"errorText" => db2_conn_errormsg()
);
print json_encode($response);
return;
}
// The following will not be error checked, for brevity.
$stm = "select distinct pname, prid from rpgspcart/prodp where pname like ? order by pname";
$stm = db2_prepare($con, $stm);
db2_bind_param($stm, 1, "query", DB2_PARAM_IN, DB2_CHAR);
db2_execute($stm);
$count = 0;
while (db2_fetch_row($stm) && $count < $limit) {
$record = array();
$record["PNAME"] = trim(db2_result($stm, "PNAME"));
$record["PRID"] = trim(db2_result($stm, "PRID"));
$records[$count++] = $record;
}
}
// "colWidths" is optional, this helps the widget to
// size the columns when multiple fields are displayed.
$return = array(
"success" => true,
"response" => array (
"results" => $records,
"colWidths" => array(
db2_field_precision($stm, "PNAME"),
db2_field_precision($stm, "PRID")
)
)
);
print json_encode($return);
?>
|
...
The auto-complete results panel is built using a preset HTML template that is built into the product. CSS classes are attached to allow for custom styling. For complete control over the output, a custom HTML template can be assigned using the "results template" property. This property accepts an HTML fragment that will be inserted into the results panel for each returned record. In the tempalte HTML template, a field name within parenthesis will be replaced with the actual field data when the results HTML is generated.
For example, to make each record display as a block with 2 lines that display one field each, the "results template" property could be set to the following:
| Code Block | ||
|---|---|---|
| ||
<div class="autocomplete-item">
<div class="autocomplete-col"><strong>Label one:</strong> (MYFIELD)</div>
<div class="autocomplete-col"><strong>Label two:</strong> (MYFIELD2)</div>
</div>
|
...