Issues with tvFilters

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.

I don’t see anything that is wrong with this call.

Only if you have multiple options selected, then you have to add the percentage sign % to the filter to see the resource in the result.

&tvFilters=`AIPersona==%DataEngineer%`

Did you copy the SQL query from the log into phpMyAdmin (or similar) to see if you get a result there.

Figured this out Harry just before I saw your reply. I had to use the wildcard setup for this. Weird, I should have had to use for all on the site, but the others worked without it (I did implement it everywhere).

&tvFilters=AIPersona==%DataEngineer%