Peoples: filter users by an extended field

webstyle Reply #1, 13 years, 6 months ago

I use Peoples snippet to output a list of users. I need to filter them by an extended profile field. How can I achieve it?

This question has been answered by m.engel. See the first response.

webstyle Reply #2, 13 years, 6 months ago

Looked into the source code of the snippet and found there "&where" property. Tried to use it as in getResources snippet:

[[!Peoples? &where=`{"Profile.id:=":30}`]]

and it works.

But I don't undersnand how to get access to extended fields. [ed. note: webstyle last edited this post 13 years, 6 months ago.]

webstyle Reply #3, 13 years, 6 months ago

In a separate snippet I tried:

$query = '"showprofile":"on"';
$c->where(array('Profile.extended:LIKE' => '%'.$query.'%'));

and it works fine.

But I can't get it to work in Peoples &where property. Any help would be appreciated.

discuss.answer

Michael Engel Reply #4, 13 years, 6 months ago

It should work as you did

[[!Peoples? &where=`{"Profile.extended:LIKE":"%\"showprofile\":\"on\"%"}`]]

is probably right, cant test it now

webstyle Reply #5, 13 years, 6 months ago

Quote from: m.engel at Mar 05, 2013, 03:54 PM

It should work as you did
[[!Peoples? &where=`{"Profile.extended:LIKE":"%\"showprofile\":\"on\"%"}`]]
is probably right, cant test it now

Thanks you a lot, it works fine. I tried so, but didn't think to comment out the quotes.

Answered Peoples: filter users by an extended field