Forum Discussion

vishwajeet_hol's avatar
vishwajeet_hol
Expert
10 years ago

Return six solutions for a given category or board, for the last 30 days, ordered by number of views

Hi,   I want six solutions for a given category or board, for the last 30 days, ordered by number of views.   I found one rest API V1 call  :   http://<community>/restapi/vc/categories/id/<categ...
vishwajeet_hol's avatar
vishwajeet_hol
Expert
10 years ago

Hi VarunGrazitti,

 

Thanks !!!

Now, I am able to fetch the results and sort by views using given query.

SELECT * FROM messages WHERE category.id IN ('CATEGORY_ID') AND is_solution = true ORDER BY metrics.views DESC LIMIT 6

 

To use date range, i tried this:

SELECT * FROM messages WHERE category.id IN ('CATEGORY_ID') AND conversation.last_post_time > 2015-03-16T10:04:30-08:00
AND conversation.last_post_time < 2015-07-16T10:04:30-08:00 AND depth=0 AND is_solution = true ORDER BY metrics.views DESC LIMIT 6

 

 

But unable to get the required respose, because when we say is_solution = true then we can't satisfy the codition depth=0.

 

So how to use date range in above query.

 

Regards,

Vishwajeet.

 

    • irach15's avatar
      irach15
      Maven
      8 years ago

      Hi VarunGrazitti,

      2 years ago ;-), was you able to implement it?

      I need something similar, latest 5-7 solutions fro a specific board, sorted by acceptance date. 

      And show subject, some body content and acceptance date.

      Any code samples appreciated.