Hi there,
I'm using the Peoples add-on to list users, and do some filtering with
&where. The call is as follows:
[[!Peoples? &usergroups=`Manager` &tpl=`listTpl` &where=`{"Profile.fullname:LIKE":"A%","AND:User.active:=":1,"AND:Profile.blocked:=":0}`]]
This code is working fine; all
where filters are working. The only thing is, the error log gets clogged with these error messages:
[2014-01-29 14:29:24] (ERROR in xPDO::getCount @ /home/domainX/domains/domainX.com/public_html/core/xpdo/xpdo.class.php : 1024) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'Profile.fullname' in 'where clause'
)
Why do I get these errors?
Changing Profile.fullname:LIKE to fullname:LIKE does not work.
MODX 2.2.10
Peoples 1.0.1
[ed. note: michelle84 last edited this post 12 years, 8 months ago.]
