Hi there,

I am working on smart search filter. I have two cascading filters for Kentico categories , one for parent category and other one is for child category.
Requirement- Parent dropdown populates with query and an items needs to be selected with an extra query parameter using where clause and then child dropdown should be populated on the basis of element selected in parent dropdown.

I am pretty much familiar with macros how it works with query string . But the problem is i am not able to use the where clause in a proper way because I am using query parameter somewhere in nested query because querystring parameter added with a column (;) that breaks the sql query structure.

Any help much appreciated


Thanks,
Balinder