ContributionsMost RecentMost LikesSolutionsRe: Filter LiQl call by user last_vsit_time 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. Subqueries Hi, I’m busy writing REST calls using API v1 to import data directly to Excel using the REST Call. I noticed when accessing the “tracker” page for a user on the community the REST call in the around (using Fiddler) looks something like this (raw text view) select:[{field:categories,expand:{select:[id,title,view_href,parent_category.id],from:categories,where:[{field:hidden,operand:=,value:false}],orderBy:{field😛osition,direction:ASC},limit:1000}},{field😛oards,expand:{select:[id,title,view_href,conversation_style,parent_category.id],from😛oards… In seeing this I would like to know id it possible to use subqueries in a LiQL query? Looking at above it seems that Lithium is doing it. If so, is there any documentation available Thanks 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? API v2 call to return topic/Article views It seems it is not possible to return the total views for the specific article/topic. We have staff on our community site that has MBO's tied to the number of views they generate on the articles/post they make. I'm trying to use REST (v2) calls to get the data but there is no call to return views on messages posted by certain authors. Am I missing something? if so, please share the LiQL statement with me. Thanks SolvedRe: Data not displaying on custom content using LIQL Thank You Jake!! Knew it was something simple: :) Data not displaying on custom content using LIQL Hi, Very new to Lithium Development. I create a call to return the subject and id of messages where the board id = [my board] In the API browser the JSON result is correct <#assign apiVersion = "2.0"/> <#assign x= rest(apiVersion,"/search?q=" + "SELECT id, subject FROM messages WHERE board.id = '[my board]' "?url) /> <ul> <#list x.data.items as message > <li>message.subject</a></li> </#list> </ul> when i add the custom content to test the results only shows the following: message.subject message.subject message.subject ..... (for all the items ) it does not show the subject I'm obviously doing something wrong, but i followed the examples on the documentation. Thanks SolvedUploading/saving blog attachment to local server Hi, I'm looking to extend the new responsive design blog board to save blog attachments to our local file server and whenever a blog attachment is downloaded, download it form our file server. I'm not so familiar with the API but want to know if this will require writing our own custom blog pages or something we can just add to OOTB blog board. Thanks Using API V1 to get the most popular topics in the last 6 months Hi, I use the following code to retrieve the most viewed Threads in our community: <#assign popularPostResult = rest("/categories/id/${categoryId}/search/messages?q=is_root:true&sort_by=-views&restapi.response_style=view&page_size=1000&page=1").messages.message /> The results are sorted by most viewed. How do I get the most viewed threads for only the last 6 Months? If you have any links to documentation it would be great as well. Regards Kallie