Kallie
6 years agoGuide
Filter LiQl call by user last_vsit_time
Hi,
I have a statement that returns user, login, solution authored(sum), last_visit_time etc.
SELECT login, last_visit_time, kudos_received.sum(weight), messages.count(*), solutions_authored.count(*) FROM users WHERE roles.id='t:Moderator' LIMIT 1000
I would like to filter the results from a certain activity date (i could not find any other DateTime setting for users) but when a put the last_visit_time in the where clause I get an error.
FROM users WHERE roles.id='t:Moderator' AND last_visit_time > 2019-01-01T00:00:00.000-07:00
Is it possible filter on the last_visit_time or am i doing it wrong?
Is there an alternative to filtering the calls to users according to a Date/Time?