Forum Discussion

Suchith's avatar
Suchith
Ace
7 years ago

Filter User Collection based on last_visited_date or last_mosified date and time.

Hello, Is it possible to filter User collection based of last_visited_date or last_modified date and time? Thanks, Suchith
peterlu's avatar
peterlu
Champion
7 years ago
Suchith you can use API V2 to pull a user list based on last_visited_date, eg.
SELECT login, avatar, view_href FROM users WHERE last_visit_time > 2017-12-25T10:04:30+10:00 LIMIT 30

Happy Xmas


  • Suchith's avatar
    Suchith
    Ace
    7 years ago

    Hi Peterlu,

    User collections doesn't support last_visit_attribute to use as a constraint. 

    Thanks,

    Suchith

    • peterlu's avatar
      peterlu
      Champion
      7 years ago

      SuchithI guess your use case is to list recent active users. There may be some work around. Eg. You can create a hidden board and create an admin post. And create a meta field for the post to store user id. I think there is a Lithium trigger, when user login every time, it can poke to a endpoint. In the endpoint you can create replies to this post with the user id. Then you can use the API V2 message object to query the recent posts for recent users.

      Or post a Lithium idea to ask Lithium to add the last_visited_time as a WHERE constrain :)