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

2 Replies

Related Content

Bypass content filters

LiQL Styling

Liql query with OR/AND

Documentaion liql constraint not working

About Aurora content filters

Recent Discussions

Join node/group 301 API error

liqlAdmin in khoros aurora graphql API

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

How to retrieve "Internal reason for ban" field

Tips on keeping stage and prod in alignment?