Forum Discussion

Kallie's avatar
Kallie
Guide
7 years ago

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?

 

Views
Sign in to react to this post

2 Replies

  • Kallie's avatar
    Kallie
    Guide
    7 years ago

    I'm using V2 in my REST calls which i "import" in PowerBi and I want to return data for users for a specific date range. Which doesn't seem possible with API v2.. which is strange because in LSI it is possible and you would have thought that Lithium would expose that in API v2 as well..

    Anyway, thank you for your reply.

    Sign in to react to this post