Alexey

{set $published_brands = '!pdoResources' | snippet : [
            'parents'       => 2,
            'depth'         => 0,
            'limit'         => 0,
            'returnIds'     => 1
] | split : ','}

{'!mFilter2' | snippet : [
            'parents'   => $_modx->resource.id,
            'includeTVs' => 'brand',
            'where'     => ["TVbrand.value:IN" => $published_brands],
            'class'     => 'msProduct',
            'element'   => 'msProducts',            
            'sortby'    => 'editedon',
            'sortdir'   => 'DESC',
            'limit'     => 18
            ...
            ]
        }

$template_id = 2; //id шаблона ресурса
$tv_id = 5; //id tv-поля

$q = $modx->newQuery('modTemplateVarTemplate');
$q->where([
    'tmplvarid' => $tv_id,
    'templateid' => $template_id
]);
$q->limit(1);

return $modx->getCount('modTemplateVarTemplate', $q);

<?php
$eventName = $modx->event->name;
switch($eventName) {
    case 'OnBeforeDocFormSave':
        //$resource = $modx->getObject('modResource', $id);
        $resourceAlias = $resource->get('alias');
        $resourceParent = $modx->getObject('modResource', $resource->get('parent'));
        if ($resourceParent) {
            $resourceParentAlias = $resourceParent->get('alias');
            
            $resourceParentIsTabsContainer = $resourceParent->getTVValue('resourceTabsContainer');
            
            if ($resourceParentIsTabsContainer) {
                $resource->set('uri_override', true);
                $resource->set('uri', $resourceParentAlias.'#'.$resourceAlias);
                
                //$resource->save();
            }
        }
        break;
}