{"type":"doc","content":[{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"Overview","type":"text"}]},{"type":"paragraph","content":[{"text":"This is a single line text entry field. The initialization value is set by the 'value' property. The 'value' property is also used to receive input in a Rich UI application through field binding.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Validation (Rich UI Only)","type":"text"}]},{"type":"paragraph","content":[{"text":"Please visit the Validation and Error Messages page.","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Validation and Error Messages","versionAtSave":"25"},"href":"https://profoundlogicsupport.atlassian.net/wiki/spaces/PUI/pages/164495573"}}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Field Binding Dialog (Rich UI Only)","type":"text"}]},{"type":"paragraph","content":[{"text":"Please visit the Field Binding page.","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Field Binding","versionAtSave":"30"},"href":"https://profoundlogicsupport.atlassian.net/wiki/spaces/PUI/pages/164496031"}}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Input Type (Rich UI Only)","type":"text"}]},{"type":"paragraph","content":[{"text":"The 'input type' property can be used to set the 'type' attribute of the HTML element that is rendered for the textbox. Input types are primarily useful for mobile applications, as the mobile device will display a different version of the keypad based on the value (i.e. numeric entry, telephone number, etc.) However, some of these options are supported by HTML5 capable browsers. If this field is not set a standard textbox element will be used by default.","type":"text"}]},{"type":"paragraph","content":[{"text":"Date","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - The Date input type is used to create a date field for the textbox. When supported it allows your user to select a date which is automatically formatted for the field and returns the date as a value.","type":"text"}]},{"type":"paragraph","content":[{"text":"Datetime","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - Similar to the Date input type this allows the user to select a date and time (with time zone).","type":"text"}]},{"type":"paragraph","content":[{"text":"Email","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - This input type would be used for a field you are expecting an email address to be entered. For mobile browsers this field allows your device to recognize the email type and change the on-screen keyboard to match (giving @ and .com options depending on the device).","type":"text"}]},{"type":"paragraph","content":[{"text":"Time","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - The time input type gives the user a field to accept a time entry format. This input type does not give a time zone like the datetime type.","type":"text"}]},{"type":"paragraph","content":[{"text":"Month","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - The month input type functions like the Date type, with the exception there is no day indicated in the format. It allows the user to only select a month and year.","type":"text"}]},{"type":"paragraph","content":[{"text":"Number","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - The number type should be used when a field is set to contain a numeric value you want to impose a restriction on.","type":"text"}]},{"type":"paragraph","content":[{"text":"Tel","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - This input type would be used for a field needing a telephone number format.","type":"text"}]},{"type":"paragraph","content":[{"text":"URL","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - The url type is for input fields containing a URL address. For mobile browsers this field allows your device to recognize the email type and change the on-screen keyboard to match (giving .com options depending on the device).","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Auto-Complete Choices","type":"text"}]},{"type":"paragraph","content":[{"text":"Auto-complete allows your textbox field to automatically suggest choices based on text entered into the textbox.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":12815,"__fileMimeType":"image/png","width":532,"id":"9911f39b-39c1-45fe-8c31-76bb8daf7f9a","collection":"contentId-164495999","type":"file","__fileName":"textbox7.png","height":315}}]},{"type":"paragraph","content":[{"text":"The auto-complete choices/values can be populated multiple ways:","type":"text"}]},{"type":"paragraph","content":[{"text":"1. 'choices/values' properties","type":"text","marks":[{"type":"em"},{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choice option field","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - Is where your fields are selected in order how you would like the auto-complete to display them.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Choice values field","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - Is where the value you want returned to your application is set.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Here are two ways to populate the choice option/values properties:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Comma separated list","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - A simple list of values separated by just a comma (i.e. Apple, Orange, Banana).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"JSON array format","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - Using JSON array format, meaning the choices/values are enclosed in a bracket with quotations and then comma separated (i.e. [\"ElementOne\", \"ElementTwo\"] ) within the choices and choice values fields also allows you to populate the auto-complete, these fields can also be bound to an RPG field (","type":"text"},{"text":"Rich UI only","type":"text","marks":[{"type":"strong"}]},{"text":").","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"2. Database-Driven Auto-Complete","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - See Database-Driven Auto-Complete section below.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Database-Driven Auto-Complete","type":"text"}]},{"type":"paragraph","content":[{"text":"This section allows choices/values to be retrieved from a database file.","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"337","id":"86e59ecf-c2e1-44a6-a231-a6d2ed9cd900","collection":"contentId-164495999","height":"277"}}},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"b63030da-42ea-47fe-a63e-e0f0e2be4eb0","collection":"contentId-164495999","height":""}}}]},{"type":"paragraph","content":[{"text":"Choices database file","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - Enter the database file to use to 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.","type":"text"}]},{"type":"paragraph","content":[{"text":"Choice options field","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" - Select the field(s) you wish to use to search. If there are multiple fields specified in the choice options field this will allow you to return multiple values in the auto-complete search. However, only the first value in the field will be used to search, any other selected fields are for display only as additional columns.","type":"text"}]},{"type":"paragraph","content":[{"text":"Choice values field","type":"text","marks":[{"type":"strong"}]},{"text":" - Select the field to return a value to your application.","type":"text"}]},{"type":"paragraph","content":[{"text":"In the example, records will be loaded from file CATEGP. The records will be searched on field CNAME and CATID, with field CATID displaying in a second column (see below). The value in field CATID in the selected record will be returned to the program.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":9611,"__fileMimeType":"image/png","width":458,"id":"c559f155-57fd-4fc4-a935-a85ff07ded39","collection":"contentId-164495999","type":"file","__fileName":"textbox8.png","height":231}}]},{"type":"paragraph","content":[{"text":"SQL Expressions","type":"text","marks":[{"type":"em"},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"You can also use SQL expressions to return information in addition to just selecting database fields from the file. So in the example, using the expression ","type":"text"},{"text":"TRIM(DBLNAM) || ', ' || DBFNAM","type":"text","marks":[{"type":"strong"}]},{"text":" allows us to return a concatenated search value with formatting for our search, but the returned value to the application is unchanged.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":4511,"__fileMimeType":"image/png","width":685,"id":"10698ea7-5dec-412f-95b9-a52112aaaa23","collection":"contentId-164495999","type":"file","__fileName":"textbox9.png","height":61}}]},{"type":"paragraph","content":[{"text":"This is what the SQL expression returns:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":4032,"__fileMimeType":"image/png","width":456,"id":"120e9279-6785-4b0b-862a-9403875432fa","collection":"contentId-164495999","type":"file","__fileName":"textbox11.png","height":128}}]},{"type":"paragraph","content":[{"text":"Max Choices","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"type":"hardBreak"},{"text":"The max choices property allows you to set the number of choices you will see from your database-driven selection. There is no limit to the number of choices you can show, however if there is no limit set the default is 10.","type":"text"}]},{"type":"paragraph","content":[{"text":"Contains Match","type":"text","marks":[{"type":"em"},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"This property when set to true looks for records that contain your search text. When set to false the query looks for your at the start of the records to match your search text. The default for this is set to false.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Dynamic Auto-Complete","type":"text"}]},{"type":"paragraph","content":[{"text":"Choices URL","type":"text","marks":[{"type":"em"},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"The choices URL property allows you to use an external program to return your choice options and values by passing them using JSON formatting. A PHP script would be one example of a custom program used to pass the values to your application. When using the choices URL property, all database-driven auto-complete properties are ignored.","type":"text"}]},{"type":"paragraph","content":[{"text":"JSON Successful Response Example","type":"text","marks":[{"type":"em"},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"These are values returned from an auto-complete textbox in a successful response from the external program:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"success\": true,\n \"response\": {\n \"results\": [\n {\n \"PNAME\": \"QUEST BOREAL\",\n \"PRID\": \"523\"\n },\n {\n \"PNAME\": \"QUEST ECLIPSE\",\n \"PRID\": \"524\"\n },\n {\n \"PNAME\": \"QUEST EQUINOX\",\n \"PRID\": \"525\"\n }\n ],\n \"colWidths\": [\n 30,\n 10\n ]\n }\n}\n","type":"text"}]},{"type":"paragraph","content":[{"text":"In the successful response you can see the fields ","type":"text"},{"text":"PNAME","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"PRID","type":"text","marks":[{"type":"strong"}]},{"text":" are being set by the script and the values returned in the successful JSON. The additional ","type":"text"},{"text":"colWidths","type":"text","marks":[{"type":"strong"}]},{"text":" is setting the column size of the widget when multiple fields are being returned (this is optional).","type":"text"}]},{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"query","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"},{"type":"hardBreak"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"cebc2127-2933-4ade-8e29-082f144d0426","collection":"contentId-164495999","height":""}}}]},{"type":"paragraph","content":[{"text":"JSON","type":"text","marks":[{"type":"em"},{"type":"strong"}]},{"text":" ","type":"text"},{"text":"Error Response Example","type":"text","marks":[{"type":"em"},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"This example is JSON information returned when the script encounters an error with an external program driven auto-complete.","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"success\": false,\n \"errorId\": \"08001\",\n \"errorText\": \"Authorization failure on distributed database connection attempt. SQLCODE=-30082\"\n}\n","type":"text"}]},{"type":"paragraph","content":[{"text":"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.","type":"text"},{"type":"hardBreak"},{"text":"showErrors() API Documentation","type":"text","marks":[{"type":"link","attrs":{"href":"https://profoundlogicsupport.atlassian.net/wiki/x/rATOCQ"}}]}]},{"type":"paragraph","content":[{"text":"Example of the showErrors() API displaying the JSON error response example:","type":"text","marks":[{"type":"em"},{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":6536,"__fileMimeType":"image/png","width":559,"id":"357a2f43-b941-4e98-b0c7-3ca4d9579704","collection":"contentId-164495999","type":"file","__fileName":"textbox10.png","height":175}}]},{"type":"paragraph","content":[{"text":"Full PHP Script Example:","type":"text","marks":[{"type":"em"},{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":" MAX) $limit = MAX;\n\n // Example of error reporting.\n $con = db2_connect(DB, USER, PASS, array(\"i5_naming\" => DB2_I5_NAMING_ON));\n if (!$con) {\n \n $response = array(\n \n \"success\" => false,\n \"errorId\" => db2_conn_error(),\n \"errorText\" => db2_conn_errormsg()\n \n );\n \n print json_encode($response);\n return;\n \n }\n \n // The following will not be error checked, for brevity.\n $stm = \"select distinct pname, prid from rpgspcart/prodp where pname like ? order by pname\";\n $stm = db2_prepare($con, $stm); \n db2_bind_param($stm, 1, \"query\", DB2_PARAM_IN, DB2_CHAR);\n db2_execute($stm);\n \n $count = 0;\n while (db2_fetch_row($stm) && $count < $limit) {\n \n $record = array();\n $record[\"PNAME\"] = trim(db2_result($stm, \"PNAME\"));\n $record[\"PRID\"] = trim(db2_result($stm, \"PRID\"));\n \n $records[$count++] = $record;\n \n }\n \n }\n \n // \"colWidths\" is optional, this helps the widget to\n // size the columns when multiple fields are displayed.\n \n $return = array(\n \n \"success\" => true,\n \"response\" => array (\n \"results\" => $records,\n \"colWidths\" => array(\n db2_field_precision($stm, \"PNAME\"),\n db2_field_precision($stm, \"PRID\")\n )\n )\n \n );\n \n print json_encode($return);\n \n?> \n","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Auto-Complete Results Template","type":"text"}]},{"type":"paragraph","content":[{"text":"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 HTML template, a field name within parenthesis will be replaced with the actual field data when the results HTML is generated.","type":"text"}]},{"type":"paragraph","content":[{"text":"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: ","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"

Label one: (MYFIELD)

Label two: (MYFIELD2)

\n","type":"text"}]},{"type":"paragraph","content":[{"text":"The CSS classes assigned can then be used to control styling such as borders, etc. ","type":"text"}]}],"version":1}

Browser not supported