Syntax Help for Collection with Multiple Filters

dosa · Sep 9th 2019

Trying to filter a Collection with two filters like this:

PHP

<?php
perch_collection('Sessions', [
'filter' => [
[
'template' => 'df19-4pd-mon.html',
'filter' => 'time',
'match' => 'eq',
'value' => 'Mon',
// options are Mon,Tue,Wed,Thur,Fri
],
[
'filter' => 'industry',
'match' => 'eq',
'value' => 'communications',
],
]
]);
?>

Display More

....the info works, but the template is not found. Should the 'template' line be somewhere else?

Byron Fitzgerald · Sep 9th 2019

Yes, the template is not part of the filter options and needs to be set in the first array, as follows.

PHP

<?php
perch_collection('Sessions', [
'template' => 'df19-4pd-mon.html',
'filter' => [
[
'filter' => 'time',
'match' => 'eq',
'value' => 'Mon',
// options are Mon,Tue,Wed,Thur,Fri
],
[
'filter' => 'industry',
'match' => 'eq',
'value' => 'communications',
],
]
]);
?>

Display More

dosa · Sep 9th 2019

Thanks! But now it's not showing any content at all....

Byron Fitzgerald · Sep 9th 2019

Its most likely that the filter you're using is returning no results, or there are errors in your template file. You can use the <perch:noresults> and <perch:showall> to debug the template. You should also be able to see the SQL query if you have PERCH_DEBUG set to true, which you can then check to see if the query is correct.