Filter LiQl call by user last_vsit_time

Question

Hi,&nbsp;I have a statement&nbsp;that returns user, login, solution authored(sum), last_visit_time&nbsp; etc.&nbsp;SELECT login, last_visit_time, kudos_received.sum(weight), messages.count(*), solutions_authored.count(*) FROM users WHERE roles.id='t:Moderator' LIMIT 1000I would like to filter the results from a certain activity&nbsp;date (i could not find any other DateTime&nbsp;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 &gt;&nbsp;2019-01-01T00:00:00.000-07:00Is it possible filter on the last_visit_time or am i doing it wrong?&nbsp;Is there an alternative to filtering the calls to users according to a&nbsp; Date/Time?&nbsp;

vikasb · Answer

Kallie&nbsp;You can use V1 API with date_start and date_end constraintshttps😕/communtiy.khoros.com/restapi/vc/users/visited?date_start=2019-03-13&nbsp;&nbsp;

kallie · Answer

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.

Forum Discussion

Filter LiQl call by user last_vsit_time

Related Content

LiQL Styling

Liql query with OR/AND

Documentaion liql constraint not working

Liql Request

Select messages containing video by LiQL query

Recent Discussions

Can someone walk me through authenticating and using Postman with Aurora?

Seeking Advice on Restricting Access to a posts to those who have the permalink.

TinyMceEditor is undefined

400/404 error on POST request

How do I get the article ID in Freemarker in a TkbArticle?