[[!pdoUsers? &groups=`EXAMPLE_GROUP` &tpl=`ExampleTpl` &sortdir=`asc` &limit=`100000` &sortby=`id` &where=`{"modUserProfile.extended:LIKE":"%\"examplelocation_01\":\"Bristol\"%"}` &showLog=`1` ]]
This question has been answered by dubbs. See the first response.
[[!pdoUsers? &groups=`MEMBERS` &tpl=`MembersListItemTpl` &sortdir=`asc` &limit=`100000` &sortby=`id` &where=`[[!SearchSnippet`]]` &showLog=`1` ]]
&where=`{ "modUserProfile.extended:LIKE":"%\"london\"%" }`
<form> <input type="text" name="value01" id="value01" /> <select id="location" name="location"> <option value="">Please select a working region…</option> <option value="Region 01">Region 01</option> <option value="Region 02">Region 02</option> <option value="Region 03">Region 03</option> </select> <select id="TeachingAge" name="TeachingAge"> <option value="">Please select a schooling phase…</option> <option value="Schooling phase 01">Schooling phase 01</option> <option value="Schooling phase 02">Schooling phase 02</option> <option value="Schooling phase 03">Schooling phase 03</option> </select> <select id="SubjectsTaught" name="SubjectsTaught"> <option value="">Please select a subject offered…</option> <option value="Subject 01">Subject 01</option> <option value="Subject 02">Subject 02</option> <option value="Subject 03">Subject 03</option> </select> <input type="submit" /> </form>
//search all standard and extended fields based on freeform text input: //note - need code to include search of standard fields too! &where=`{ "modUserProfile.extended:LIKE":"%\"value01\"%" }` //search work region fields (all) based on <select> option &where=`[ {"modUserProfile.extended:LIKE":"%\"location_01\":\"location\"%"}, {"OR:modUserProfile.extended:LIKE":"%\"location_02\":\"location\"%"}, {"OR:modUserProfile.extended:LIKE":"%\"location_03\":\"location\"%"}, {"OR:modUserProfile.extended:LIKE":"%\"location_04\":\"location\"%"}, {"OR:modUserProfile.extended:LIKE":"%\"location_05\":\"location\"%"} ]` //search schooling phase fields (all) based on <select> option &where=`[ {"modUserProfile.extended:LIKE":"%\"TeachingAge_01\":\"TeachingAge\"%"}, {"OR:modUserProfile.extended:LIKE":"%\"TeachingAge_02\":\"TeachingAge\"%"} ]` //search subjects offered fields (all) based on <select> option &where=`[ {"modUserProfile.extended:LIKE":"%\"SubjectsTaught_01\":\"SubjectsTaught\"%"}, {"OR:modUserProfile.extended:LIKE":"%\"SubjectsTaught_02\":\"SubjectsTaught\"%"}, {"OR:modUserProfile.extended:LIKE":"%\"SubjectsTaught_03\":\"SubjectsTaught\"%"}, {"OR:modUserProfile.extended:LIKE":"%\"SubjectsTaught_04\":\"SubjectsTaught\"%"}, {"OR:modUserProfile.extended:LIKE":"%\"SubjectsTaught_05\":\"SubjectsTaught\"%"} ]`