Forum Discussion

jaikumar1's avatar
jaikumar1
Mentor
6 years ago

How to get number of reply in specific duration of time?

Hi,

I just looking into get the users and number of replies they have posted since from the last 1 month period of time.

I have tried the below query ,

select * from messages

But seems it's not returning correct results. So could you please suggest me on any other API available? or any other method to achieve it? 

 

  • VikasB's avatar
    VikasB
    Boss
    6 years ago

    jaikumar1

    Did you pass the timeframe also?

    select * from messages where post_time > 2018-09-25T00:00:00.000



    • jaikumar1's avatar
      jaikumar1
      Mentor
      6 years ago

      Hi VikasB, 

      Thank you for your reply. While selecting record without any additional conditional parameter it return certain records. But while applying the condition, it return some additional records which are not returned previously without any condition in the query. Is there any limit getting applied automatically even if we are not applied?

      I need to apply the time limit in the query, and i'm just looking now to get the current date and time using the freemarker, and which will apply in the query.