I have a multi-row list which has 5 columns (year, dates, cave_pot, party, source) which I built using the tutorial as my start point and an existing list I imported into mysql from a csv file.
I would like to allow the user to filter/search on the list. i.e. all caves where year=1906 and party contains "Smith"; or all records of cave_pot where contains "Gaping Ghyll"
My first guess is that I should create a form that allows the 'criteria' to be selected and pass it in some way as a where statement to my main list. Possibly using a 'request parameter' containing the where clause but don't know how to reference this in the where box in advaced. :?
Next thought was load 'query form' as the on load event and load the multirow form as the on submit event but again no idea how to pass the criteria characters. :? :?
I am using Joomla 1.7 and Chronoforms V4 RC1.8
Any advice gratefully received. Thanks.
I would like to allow the user to filter/search on the list. i.e. all caves where year=1906 and party contains "Smith"; or all records of cave_pot where contains "Gaping Ghyll"
My first guess is that I should create a form that allows the 'criteria' to be selected and pass it in some way as a where statement to my main list. Possibly using a 'request parameter' containing the where clause but don't know how to reference this in the where box in advaced. :?
Next thought was load 'query form' as the on load event and load the multirow form as the on submit event but again no idea how to pass the criteria characters. :? :?
I am using Joomla 1.7 and Chronoforms V4 RC1.8
Any advice gratefully received. Thanks.