Forum Discussion

arthur_'s avatar
arthur_
Guide
7 years ago

Get post_time through API v2

Hi,   We are trying to get date when post was created using query similar to one below:   SELECT conversation.last_post_time, current_revision.last_edit_time, post_time FROM messages WHERE board....
  • VikasB's avatar
    VikasB
    7 years ago

    arthur_

    It seems there is some misunderstanding or it may be your instance-specific issue. Every message will return there own post time.  See here https://prnt.sc/iq7b9r

    If you want to get the only main topic then you have to pass the depth but it does not mean by passing the depth it returns the right time.

    select id, depth,post_time from messages where depth = 0 order by post_time desc
arthur_'s avatar
arthur_
Guide

VikasB

 

 

Thank you for the suggestion.

 

It turns out, the query was missing the depth parameter (without it, instead of getting post date of the message itself, query returned post date of its latest replies too)

VikasB's avatar
VikasB
Boss
7 years ago

arthur_

It seems there is some misunderstanding or it may be your instance-specific issue. Every message will return there own post time.  See here https://prnt.sc/iq7b9r

If you want to get the only main topic then you have to pass the depth but it does not mean by passing the depth it returns the right time.

select id, depth,post_time from messages where depth = 0 order by post_time desc
  • arthur_'s avatar
    arthur_
    Guide
    7 years ago

    VikasB

     

    Thank you very much for your support.

     

    I wasn't really aware on how depth works in relation to messages, but it's much clear right now.