Forum Discussion

khill's avatar
khill
Mentor
7 years ago

REST API v2 Multiple Posts with the Same Depth Value

Hi Community,   I am working with the REST API V2 messages tables and keep getting instances where a two posts (different post ids) on the same topic have the same depth.   Example: TopicID = 00...
  • VikasB's avatar
    VikasB
    7 years ago

    khill  As mentioned by DougS  depth is an indicator of message position.  In a thread, there will be only one message having depth 0 which is called topic. All other messages will have depth > 0.  See screenshot here

    But DougS reply of reply will have depth 2 not 1.  See screenshot here

VikasB's avatar
VikasB
Boss

khill  As mentioned by DougS  depth is an indicator of message position.  In a thread, there will be only one message having depth 0 which is called topic. All other messages will have depth > 0.  See screenshot here

But DougS reply of reply will have depth 2 not 1.  See screenshot here

khill's avatar
khill
Mentor
7 years ago

Ah perfect explanations - thank you VikasB and DougS! 

 

In which case, it sounds I'll have to add an extra parameter to calculation of first reply where reply depth = 1 and post date is min.

  • VikasB's avatar
    VikasB
    Boss
    7 years ago

    khill  Unfortunately, lithium does not support depth=1. Either you can use  depth=0 or depth!=0.

    But your problem can be solved like this even without using depth parameter. As it would get only first replies of the topic. 

    select id,subject,post_time from messages where parent.id='121' order by post_time ASC limit 1