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...
VikasB's avatar
VikasB
Boss

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.