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

Liql with Union

Recent Discussions

Connecting Khoros data to CRM (Salesforce)

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

400/404 error on POST request

Online User Count is Completely Wrong

TinyMceEditor is undefined