List Manager Forum

Field with other table

User moon_295 2012-08-22 11:09:37

Dear Moonsoft,


I would like know if possible to create a list with other table. I use composant "community builder", I would like create users list with ListManager. It's possible to create field with SQL requet?


Regards.

Frédéric Mégrier

Moonsoft support 2012-08-22 18:18:50

Hello,
you can create a field which loads the set of options from any table. You have to type the field as 'option list' or 'multioption' and then click on the sql icon. There you can insert a valid query to your database, the first value of each record recovered would be used as id, and the second one as the text of the option.

Hope this helps, regards

...
Support/development

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

Buy now!
...
CalcBuilder

Create dynamic calculators

Buy now!