Forum Discussion

Shivshankar's avatar
Shivshankar
Ace
8 years ago

how to obtain accepted solution views for a particular duraion(month)

Hi, I have tried using custom logic to get all views of message which are solution  , but the problem is api dosn't accpet date range parameter.   api's tried : vc/users/id/12/messages/posts  the...
Views
Sign in to react to this post
AbhishekIlindra's avatar
AbhishekIlindra
Boss
8 years ago

Shivshankar : It is available in the Community Metrics. Kindly check this Document for more information.

 

If my post is helpful and answers your question, please give "Kudos" and "Accept it as a Solution."

Thanks & Regards,
Abhishek Illindra

Sign in to react to this post
VikasB's avatar
VikasB
Boss
8 years ago

Shivshankar 

 

Did you try this? 

select metrics.views from messages where is_solution=true and post_time > 2017-06-11T01:16:39.446-07:00 and post_time < 2017-07-11T01:16:39.446-07:00

 It will give you the views of solutions which are posted in last one month. 

But it would not be possible to set the time range about when they are accepted as a solution. 

Sign in to react to this post
  • ADS_PSI's avatar
    ADS_PSI
    Mentor
    8 years ago

    VikasBok it's not possible altogether then , can we have some workaround using LSI api's ? i can see in LSI that it gives bulk data , can we just process it for a user, though in documentation i did not see data parameter for user , and its obvious as is bulk data api.

    Sign in to react to this post