Filters not showing up

Bu Bullfn33 26 Aug, 2013
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?


<?php 
    $param = JRequest::getInt('id_mat');
    echo "id_mat="; echo $param;
    ?>
Gr GreyHead 05 Sep, 2013
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
<?php
$param = JRequest::getInt('id_mat');
echo " G.`id_mat` = {$param} ";
?>


Bob
This topic is locked and no more replies can be posted.