Can anyone tell me how to make a proper xPDO query with ‘where’ targeting JSON field?
Example: I placed ‘firstName’ as an extra user field stored in ‘modUserProfile.extended’
Now I want to get user by his first name = ‘Adam’
$users = $modx->getObject(‘modUserProfile’, array(‘extended.firstName’=>‘Adam’));
but this doesn’t work.
What is the correct syntax for pointing JSON field object in that case?