Select pages by author

[rusjoan]

It's so strange that I can't select pages like this:

template=foo, createdUser=1018

It gives such error:

Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pages.createdUser' in 'where clause'' in ...

My suggestion is in: error causes because of selector engine allows to select by createdUser, but this is a service field and it doesn't exist in DB.

[rusjoan]

Now googled same topic: https://processwire.com/talk/topic/4655-find-pages-by-createduser/

So I decided to try created_users_id=.. and it works!

OK, then now another question: where is official information about this behavior?

I'm sure that PW-novices should know about these nuances from API doc but not from self-searches

[kongondo]

It's there in the Cheatsheet...enable advanced and voila!