[[!pdoUsers? &groups=`Partners` &xtpl=`partnerTpl` &sortby=`id` &sortdir=`asc` &limit=`3` &where=`{"modUserProfile.extended.customvalue:=":"TypeA"}` &showLog=`1` ]]
This question has been answered by Bruno17. See the first response.
[[!pdoUsers? &groups=`Partners` &xtpl=`partnerTpl` &sortby=`id` &sortdir=`asc` &limit=`3` &where=`{"modUserProfile.extended:LIKE":"%\"customvalue\":\"TypeA\"%"}` &showLog=`1` ]]
<input type="text" name="fullname" id="fullname" value="[[+fullname]]" placeholder="Full name" > <input type="text" name="iban" id="iban" value="[[+iban]]" placeholder="Iban-number">
I don`t know pdoUsers but other plugins using the where conditions on extended fields.
Extended Fields are saved as JSON and can`t accessed on the fields via MySQL. But you can access it as a string, with LIKE %%
But Remind, its slow somehow and should always be cached.
[[!pdoUsers? &groups=`Partners` &xtpl=`partnerTpl` &sortby=`id` &sortdir=`asc` &limit=`3` &where=`{"modUserProfile.extended:LIKE":"%\"customvalue\":\"TypeA\"%"}` &showLog=`1` ]]
&where=`{"modUserProfile.extended:LIKE":"%\"customField1,customField2\":\"TypeA\"%"}`
&where=`{ "modUserProfile.extended:LIKE":"%\"workregion_01\":\"london\"%", "OR:modUserProfile.extended:LIKE":"%\"workregion_02\":\"london\"%" }`
&where=`{ "modUserProfile.extended:LIKE":"%\"london\"%" }`