We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 36573
    • 173 Posts
    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 but

    [[!pdoUsers? &tpl=`userListTpl` &where=`{"username:=":"test"}` &limit=`0`]]


    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.

    This question has been answered by crecorn. See the first response.

    [ed. note: crecorn last edited this post 12 years, 6 months ago.]
      Everything I know I learned on the internet. Saved me thousands in College tuition,
    • discuss.answer
      • 36573
      • 173 Posts
      Quote from: Bruno17 at Apr 03, 2014, 11:23 PM
      try

      &where=`{"modUserProfile.fullname:=":"testname"}`

      Got the answer in another thread. This could come in handy for someone else some day.
        Everything I know I learned on the internet. Saved me thousands in College tuition,