Site structure
Version 5.x > Site structure > Smart search filter Dropdownlist View modes: 
User avatar
Member
Member
gaurav.agrawal-octalsoftware - 4/18/2011 8:36:51 AM
   
Smart search filter Dropdownlist
Hi,

I am using "Smart search filter" dropdownlist filter and in this dropdownlist i filled data from a query.
i am using this in news section and filled distinct years by using sql query. its working fine but my problem is that i want to add a "select Year" option at the 0th index of this dropdownlist and other option will be filled by sql query.

How i can do this???

Thanks
Gaurav Agrawal

User avatar
Member
Member
kentico_michal - 4/18/2011 12:43:46 PM
   
RE:Smart search filter Dropdownlist
Hi Gaurav,

I would recommend using the SQL UNION operator to combine the Select year option with options returned by your SQL query.

Best regards,
Michal Legen