Forum Discussion

Shivshankar's avatar
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 

then taking individual id's and checking if it is solution and if it is a solution adding the views.

These views are message views (i.e from post time) and not between a duration range.

 

please provide inputs for this.

 

thanks.

5 Replies

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