Forum
I can't get 'filter by related items' working?
Hi
Setup
I've got a collection
called Staff
and I'm using perch:related
to link it to another collection
called Solutions
I'm using this in my Solutions
collection template
<!--solution-detail.html-->
<perch:related id="staff_related" collection="Staff" label="Staff">
<perch:content id="staff_name" type="text">,
<perch:content id="staff_position" type="text">
</perch:related>
This is the detail template I'm using in my Staff
collection
<!--staff-detail.html-->
THIS IS A TEST
<perch:content id="staff_name" title type="text" label="Name">
<perch:content id="staff_position" type="text" label="Position">
When adding new items to the Solutions
collection the perch:related
option shows up in Perch Admin - this bit works fine.
Question
I'd like to filter by related items as described in the docs. Here's what I'm using on my solutions.php
page.
perch_collection('Solutions',[
'filter' => 'staff_related.staff_name',
'match' => 'eq',
'value' => 'Janet Thompson',
'template' => 'staff-detail.html'
]);
The filter uses the dot syntax method, perch:related
ID followed by the perch:content
ID I want to filter on.
I've hardcoded the value
, the fictional Janet Thompson is present in the Staff
collection
When I refresh the page, all I see is are the words THIS IS A TEST
from the staff-detail.html
template.
It's not picking up id="staff_name"
or id="staff_position"
I've checked perch_debug
and php_error.log
no errors in either.
Any ideas why?
Perch Runway: 3.1.1, PHP: 7.1.12, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $, with PDO
Server OS: Darwin, cgi-fcgi
Installed apps: content (3.1.1), assets (3.1.1), categories (3.1.1)
App runtimes: <?php $apps_list = [ ];
PERCH_LOGINPATH: /perch
PERCH_PATH: /Users/stephen/Repositories/project/cms/perch
PERCH_CORE: /Users/stephen/Repositories/project/cms/perch/core
PERCH_RESFILEPATH: /Users/stephen/Repositories/project/cms/perch/resources
Image manipulation: GD
PHP limits: Max upload 32M, Max POST 32M, Memory: 128M, Total max file upload: 32M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
REQUEST_URI: /perch/core/settings/diagnostics/
DOCUMENT_ROOT: /Users/stephen/Repositories/project/cms
HTTP_HOST: project.local
No, I've no idea why. Have you turned on debug?