Versions Compared

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.

...

If you have a custom field with autocomplete and you want to set Min. chars on a value greater than 0, you need to type the SQL Autocomplete Script.
Option2Image Removed

...



SQL Autocomplete Script
Code Block
select brand from car_parts
where name like {query} || '%';

...