PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-5378

Message Board My posts should be ordered by the thread's last post date

    Details

    • Type: Feature Request Feature Request
    • Status: Selected for Development
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 5.2.3, 6.2.0 CE M3
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      All
    • Branch Version/s:
      5.2.x, 5.1.x
    • Business Value:
      3
    • Similar Issues:
      Show 5 results 

      Description

      Message Board My posts should be ordered by the threads last post date. Currently it orders by the current user's last post date to that thread.

        Activity

        Hide
        Amos Fong added a comment -

        Committed fix

        Show
        Amos Fong added a comment - Committed fix
        Hide
        Brian Chan added a comment - - Restricted to

        Hi Amos,

        The way we fetched latest threads used to work the way you did it, but it killed performance. Imagine 1,000,000 mb messages spread across 300,000 threads.

        The db will crash when you do the join. We specifically removed it for performance.

        I thought the existing method already sorts by lats post date. If it doesn't, the method is to duplicate data by adding it directly to MBMessage. There's always a trade off between speed and disk space.

        Use more disk space, faster speed, etc.

        So we have to fix this without having the join.

        Show
        Brian Chan added a comment - - Restricted to Hi Amos, The way we fetched latest threads used to work the way you did it, but it killed performance. Imagine 1,000,000 mb messages spread across 300,000 threads. The db will crash when you do the join. We specifically removed it for performance. I thought the existing method already sorts by lats post date. If it doesn't, the method is to duplicate data by adding it directly to MBMessage. There's always a trade off between speed and disk space. Use more disk space, faster speed, etc. So we have to fix this without having the join.
        Hide
        Brian Chan added a comment -

        I looked at the existing code some where, it should already be sorting by modifiedDate on the Message, which is the last post date on the thread.

        Show
        Brian Chan added a comment - I looked at the existing code some where, it should already be sorting by modifiedDate on the Message, which is the last post date on the thread.
        Hide
        Amos Fong added a comment -

        It actually doesn't because if someone else posts to the thread, that message will not be found because it's searching by userId. Therefore it can only order by the user's last post date to the thread. Maybe we could order it once we get the list of threads.

        Show
        Amos Fong added a comment - It actually doesn't because if someone else posts to the thread, that message will not be found because it's searching by userId. Therefore it can only order by the user's last post date to the thread. Maybe we could order it once we get the list of threads.
        Hide
        Cynthia Wilburn (Inactive) added a comment -

        Can you please update this ticket with a proper component selection?

        If you do not have edit permissions, please add it as a comment.

        Thanks!

        Show
        Cynthia Wilburn (Inactive) added a comment - Can you please update this ticket with a proper component selection? If you do not have edit permissions, please add it as a comment. Thanks!
        Hide
        Randy Zhu added a comment -

        In preparation for Ideation; we are merging New Feature and Improvement tickets into a singular ticket type called “Feature Request”. Additional information to follow soon.

        Show
        Randy Zhu added a comment - In preparation for Ideation; we are merging New Feature and Improvement tickets into a singular ticket type called “Feature Request”. Additional information to follow soon.
        Hide
        Amos Fong added a comment -

        No longer reproducible, please close.

        Show
        Amos Fong added a comment - No longer reproducible, please close.

          People

          • Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Days since last comment:
              2 years, 19 weeks, 1 day ago

              Development

                Structure Helper Panel