API V2 Query for Users on Post Date
Hi everyone,
Is it possible to use the V2 API to query users on their last visit or last post date? Looked through docs, but want to make sure I am not missing something obvious!
Thanks,
Kate
Forum Discussion
khill- You can not fetch user by their last visit or last post time. Only below constraint are available for sorting.
SELECT id FROM users ORDER BY kudos_given.sum(weight) ASC SELECT id FROM users ORDER BY kudos_received.sum(weight) ASC SELECT login FROM users ORDER BY login DESC SELECT id, login, public_images.count(*) FROM users ORDER BY public_images.count(*) DESC SELECT id FROM users ORDER BY registration_data.registration_time ASC SELECT id, registration_data.registration_time FROM users ORDER BY registration_data.registration_time DESC SELECT id, reviews FROM users ORDER BY reviews.count(*) DESC
Thanks Tariq as always!
Hm dang - that was the same info I found, just hoping there was something I was missing.
Does any one have a way they work around this to return a similar query without being able to use a last post date constraint?
