I'm trying to get some filters on my connection like the FAQ page on this site but I'm obviously misunderstanding something because I can't get any to show up.
I put the field I would like to show a filter for, G.week, in the filter fields names box. I've tried a bunch of field names w/ and w/o the Model ID's but nothing shows up front. Is this feature suppose to be used with Chronoforms only???
<< Side question >>
In the WHERE box I'm trying to pass a param to the url but the field needs a model id in front. After trying about 40 different syntax combinations I either get a MySQL error or the data does not react. If I leave it as below I get MySQL error telling me it's ambiguous because two tables have id_mat field. How would I go about placing a G in front of id_mat to id the table?
I put the field I would like to show a filter for, G.week, in the filter fields names box. I've tried a bunch of field names w/ and w/o the Model ID's but nothing shows up front. Is this feature suppose to be used with Chronoforms only???
<< Side question >>
In the WHERE box I'm trying to pass a param to the url but the field needs a model id in front. After trying about 40 different syntax combinations I either get a MySQL error or the data does not react. If I leave it as below I get MySQL error telling me it's ambiguous because two tables have id_mat field. How would I go about placing a G in front of id_mat to id the table?
<?php
$param = JRequest::getInt('id_mat');
echo "id_mat="; echo $param;
?>
Hi Bullfn33,
Sorry I missed this post earlier :-(
I really don't understand properly how the FAQs filters work - they do use a ChronoForm (and I have posted the settings in another thread in the last few days). Unfortunately I can't access the back-end of the FAQs at the moment because of some security changes on the site.
I think that the WHERE code would look like this
Bob
Sorry I missed this post earlier :-(
I really don't understand properly how the FAQs filters work - they do use a ChronoForm (and I have posted the settings in another thread in the last few days). Unfortunately I can't access the back-end of the FAQs at the moment because of some security changes on the site.
I think that the WHERE code would look like this
<?php
$param = JRequest::getInt('id_mat');
echo " G.`id_mat` = {$param} ";
?>
Bob
This topic is locked and no more replies can be posted.