Forums

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;
    ?>

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