Dynamic tables can only be loaded by SQL commands.Only use them when the table content needs to vary according to some dynamic criteria (eg: current company, current product, etc).Dynamic tables are expensive to use compared to static tables.A dynamic table is (re)loaded every time a screen is displayed.This value indicates that the data should come from a dynamically created table.When you use this option you must specify the name of the query in sqlQueryName as defined in your dynamic tables file. Use this option carefully as it is the only one where the data is loaded at every screen arrival with an expected performance impact in the rendering of the screen.Type “fu” on the input box and AutoComplete is displayed as follows: Dynamic Table: From the Auto Complete extension change the xmlFileLocation to /ts.From the Auto Complete extension change the xmlFileName to JobTitles_en.xml.From the Auto Complete extension change the tableName property to jobtitles.From the Auto Complete extension change the onFillDropDown property to ROW.title.From the Auto Complete extension change the dataSourceType property to XML file.Create an XML file example called jobtitles_en.xml.To specify another location change the xmlFileLocation property. The data to fill the table is obtained from an XML file located by default in /ts/screens/. The options are XML File, Dynamic Table and Static Table. Using different dataSourceType will determine the method used to populate the drop down. This extension is not a visual extension and needs to be used in conjunction with a visual extension such as Default Visualization or Multitype Input Box extension. Name of XML file when the source type is XML.Įvent raised when selected dropdown entry changes. Path to locate the xmlFileName when the source type is XML. no script to execute – interpreted as ROW.text)įor Dynamic Table data source type provide the name property from the Dynamic table you are using.įor Dynamic Table data source the variables used in your query.ĮNV.SQL.SQLVariableLibrary =USERENV.dftSQLDataLibraryįor Static Table data source type provide the name property from the Static table you are using.
#Type fu extension code#
JavaScript code to execute to fill the drop down.īlank (i.e.
Minimum number of characters to use before sending an autocomplete request. Includes ‘starts-with’, ‘ends-with’ and ‘contains’ as its options. Must return an array of item object.ĭetermines the search pattern to use in retrieving values from the pre-populated list. The delay in seconds to defer the autocomplete request, after the user has finished typing.įor Fixed values data source type you must enter the values used to fill the drop down Indicates where the source data is obtained from. AxAutoComplete allows an auto complete to be inserted into the 5250 screen.
0 kommentar(er)
