I'm using PDOuser to call a list of the users. I need to filter them by a user field.
This works to filter by user name
[[!pdoUsers? &tpl=`userListTpl` &where=`{"username:=":"test"}` &limit=`0`]]
but when I try to filter by "comment" is does not work.
[[!pdoUsers? &tpl=`userListTpl` &where=`{"comment:=":"comment test"}` &limit=`0`]]
Other fields such as email, full name, and phone do not work either.
Everything I know I learned on the internet. Saved me thousands in College tuition,