[решено] FIND_IN_SET по двум тв полям
Как сделать поиск по двум тв полям?
'where' => [
"1 = 1 AND FIND_IN_SET("~$person_id ~", replace(first_group, '||', ',')) OR FIND_IN_SET("~$person_id ~", replace(second_group, '||', ','))"
{set $resources = 'pdoResources' | snippet : [
'parents' => $parent,
'returnIds' => '1',
'limit' => '0',
'includeTVs' => 'first_group,second_group',
'where' => [
"1 = 1 AND FIND_IN_SET("~$person_id~", replace(first_group, '||', ','))",
"1 = 1 AND FIND_IN_SET("~$person_id~", replace(second_group, '||', ','))"
]
]}