CalcBuilder Forum

Syntax for SQL Query on option list?

User TheFencepedia 2026-07-31 05:52:36

Hi there,

I want to use a SQL query to pull information from a database table.

Is there a how to or tutorial that explains the syntax etc?

Thanks!

Moonsoft support 2026-07-31 10:28:29

Hi,
this configuration field allows any valid query and the only rule is that you need to recover a couple of fields from it in order to fill the each option text and value.

You will find information and an example on how to fill the sql query configuration here:

https://www.moonsoft.es/tutorial/entry/14-calc-builder-for-joomla-4/calculator-configuration-form-fields

(section option List)

Please let us know if you need further help.

Kind regards
Silvia Martín
Moonsoft Team

...
CalcBuilder

Create dynamic calculators

Buy now!
...
Support/development

Perfect for small code changes or to correct any bug at your site

Buy now!