I am having trouble getting tvFilters to work properly for one set of pages. The same call works perfectly elsewhere on the site and I can’t figure out what the problem is. An extra set of eyes would be appreciated.
Here is the call on the page:
[[!getPage?
&elementClass=`modSnippet`
&element=`getResources`
&parents=`4,5,6,7,8`
&tvFilters=`AIPersona==DataEngineer`
&sortby=`publishedon`
&sortdir=`DESC`
&hideContainers=`0`
&includeTVs=`1`
&processTVs=`1`
&includeContent=`1`
&limit=`24`
&tvPrefix=``
&tpl=`blog33`
]]
The tv is AIPersona. Here is the Input for the TV Checkbox:
Data Engineer==DataEngineer||Data Scientist==DataScientist||Architect==Architect||Developer==Developer||Software Engineer==SoftwareEngineer||Business Owner==BusinessOwner||Dev Ops==DevOps||Auditor==Auditor
Output for the tv is text.
ERROR MESSAGE WITH DEBUG
/cache/includes/elements/modsnippet/2.include.cache.php : 201) context for 4 is web
[2022-05-11 16:34:12] (ERROR @ cache/includes/elements/modsnippet/2.include.cache.php : 201) context for 5 is web
[2022-05-11 16:34:12] (ERROR @ cache/includes/elements/modsnippet/2.include.cache.php : 201) context for 6 is web
[2022-05-11 16:34:12] (ERROR @ cache/includes/elements/modsnippet/2.include.cache.php : 201) context for 7 is web
[2022-05-11 16:34:12] (ERROR @ cache/includes/elements/modsnippet/2.include.cache.php : 201) context for 8 is web
[2022-05-11 16:34:12] (ERROR @ cache/includes/elements/modsnippet/2.include.cache.php : 430) SELECT modResource
.id
, modResource
.type
, modResource
.contentType
, modResource
.pagetitle
, modResource
.longtitle
, modResource
.description
, modResource
.alias
, modResource
.alias_visible
, modResource
.link_attributes
, modResource
.published
, modResource
.pub_date
, modResource
.unpub_date
, modResource
.parent
, modResource
.isfolder
, modResource
.introtext
, modResource
.content
, modResource
.richtext
, modResource
.template
, modResource
.menuindex
, modResource
.searchable
, modResource
.cacheable
, modResource
.createdby
, modResource
.createdon
, modResource
.editedby
, modResource
.editedon
, modResource
.deleted
, modResource
.deletedon
, modResource
.deletedby
, modResource
.publishedon
, modResource
.publishedby
, modResource
.menutitle
, modResource
.donthit
, modResource
.privateweb
, modResource
.privatemgr
, modResource
.content_dispo
, modResource
.hidemenu
, modResource
.class_key
, modResource
.context_key
, modResource
.content_type
, modResource
.uri
, modResource
.uri_override
, modResource
.hide_children_in_tree
, modResource
.show_in_tree
, modResource
.properties
FROM modx_site_content
AS modResource
WHERE ( ( modResource.parent IN (4,5,6,7,8,159,170,33,34,35,36,37,39,40,41,42,43,44,45,46,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,160,161,162,163,164,165,166,167,168,169,171,172,184,85,86,87,88,89,90,91,92,93,94,95,82,83,84,30,31,32,38,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,78,79,80,81,181) AND modResource
.deleted
= 0 AND modResource
.published
= 1 AND modResource
.hidemenu
= 0 ) AND (EXISTS (SELECT 1 FROM modx_site_tmplvar_contentvalues
tvr JOIN modx_site_tmplvars
tv ON tvr.value LIKE ‘DataScientist’ AND tv.name = ‘AIPersona’ AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id) OR EXISTS (SELECT 1 FROM modx_site_tmplvars
tv WHERE tv.name = ‘AIPersona’ AND tv.default_text LIKE ‘DataScientist’ AND tv.id NOT IN (SELECT tmplvarid FROM modx_site_tmplvar_contentvalues
WHERE contentid = modResource.id)) ) ) ORDER BY publishedon DESC LIMIT 24
PAGES:
This call works perfectly on one of pages associated with this call:
However, on the other pages it doesn’t. I DO have content with that tv selected.
Thanks, in advance, for helping.