List Manager Forum

Select Filter Box not displaying values if Populated by SQL Statement

User moon_1100 2013-06-08 11:46:50

Hi,

Component is fantastic and currently doing testing. I am loading two select boxes using SQL statements (Thanks for the info previous thread)When I set to a Select Filter for the column where it sources data either from an external table or from within List manager the rows are there but nothing shows? Any assistance would be great!

Moonsoft support 2013-06-09 19:23:00

Hi,
please ensure you have selected two fields as the result of your query. The first one will be used as the id, and the second one as the text to select. For ex:

select id, username from #__users

Regards

...
Support/development

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

Buy now!
...
Support/development 40 hours

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

Buy now!