About VikasB

VikasB · ‎11-21-2019

@kgroneman Yes, you can edit default status list. Go to: Admin > System > Statuses > Statuses You will not be able to see status tab in case if you are on root level. Make sure you have selected Ideas instead of the root level. See here https://prnt.sc/q07q11

VikasB · ‎11-20-2019

@PAULEM By default, API returns 25 results. You can pass a specific limit up to 1000 to get more results. community.YourCommunity.com /api/2.0/search?q= select * from messages where conversation.solved=false and depth=0 and post_time > 2019-07-01T00:00:00.000-00:00 and post_time < 2019-07-31T23:59:59.999-00:00 limit 1000

VikasB · ‎11-17-2019

@NicolaC You can use the below URL to run it for production. You need to replace the base URL with your community base URL community.YourCommunity.com/api/2.0/search?q= select * from messages where conversation.solved=false and depth=0 and post_time > 2019-07-01T00:00:00.000-00:00 and post_time < 2019-07-31T23:59:59.999-00:00

VikasB · ‎11-15-2019

@NicolaC The below queries can help you to get the topics count which were posted in a specific month but not resolved yet. For July 2019 select * from messages where conversation.solved=false and depth=0 and post_time > 2019-07-01T00:00:00.000-00:00 and post_time < 2019-07-31T23:59:59.999-00:00 For July 2018 select * from messages where conversation.solved=false and depth=0 and post_time > 2018-07-01T00:00:00.000-00:00 and post_time < 2018-07-31T23:59:59.999-00:00 You can run it you have studio/admin access. Studio > API Browser Here is the screenshot for your reference https://prnt.sc/px8v6p

VikasB · ‎11-07-2019

@IanAtJMP You can do it in 2 different way a) Get all groups of that specific user using below query <#assign myGroups= rest("/groups/for/members/id/[user_id]").groups.group /> And search for that specific group if it exists. b) Get all members of a group using the below query and check if that user exist in list <#list restadmin("/groups/id/[group_id]/members?page_size=999").users.user as member> <#if member.id?? && (member.id?number == user.id)> <#assign show_module = true/> <#break/> </#if> </#list> I think option "a" will be better here.

Online Status	Offline
Date Last Visited	Wednesday

Re: Can you edit default idea exchange statuses?

Re: How can I track the number of unanswered posts over time?

Re: How can I track the number of unanswered posts over time?

Re: How can I track the number of unanswered posts over time?

Re: Determine user's access to a particular group using LiQL or V1