Forum Discussion

Liam_M's avatar
Liam_M
Guide
8 years ago

Status update comment on idea posts

Hi,   When changing the status status of an idea on an idea board, moderators have the option to make a comment with the status change. I can see from the product ideas board on the Lithium communi...
  • TariqHussain's avatar
    8 years ago

    Liam_M -

    The only difference between normal comment and status change comment is its Subject. 

    Status change comment add status as a suffix to the subject of the reply. e.g if moderator change the status of idea to Under Consideration, it will add under consideration suffix to the subject. The subject of that reply will look like this RE: idea subject - under consideration. 

     

    You can fetch this record using the matches query. 

     

    select *  from messages where topic.id = 'idea-id' and subject matches "Under Consideration" order by post_time DESC limit 1

    Give kudos if you find my posts helpful or mark solution if it answers your query

    Tariq