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...
Shivshankar's avatar
Shivshankar
Ace
8 years ago

VarunGrazitticustom component is not the requirement , we just need this view count. Is there any work aroung for this

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

  • 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. 

    • 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.