Versions Compared

Old Version 5

changes.mady.by.user Bogdan Neacsu

Saved on

compared with

New Version 6

changes.mady.by.user Bogdan Neacsu

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This type of data source helps you obtain the values which will populate the custom field using SQL scripts.

...

Info

Important

If you want to use two columns at the select statement, note that the first column will be considered as the label, and the second will be the value.
If you have only one column in the select statement, this will be interpreted as label and value at the same time.

...

  • JNDI or Name of the datasource — represents the resource name of database used. Here you type the name of the database used.  If you want to configure a new data source, click on “Not Enough? Try adding your own, new datasource!”

  • SQL Initial Script — represents the initial script which filters the results from database for custom fields with or without autocomplete and value 0 set for Min. chars.

  • SQL Autocomplete Script — represents the script with autocomplete made by user for custom fields. 

...