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 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!
...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!