Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-24564

Incorperate IU's Performance Enhancement for MessageImpl

    XMLWordPrintable

    Details

    • Type: Task
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.7.0
    • Fix Version/s: 2.7.1, 2.8.0
    • Component/s: Messages Tool
    • Labels:
      None

      Description

      change query findAggregatePvtMsgCntForUserInContext to:

      <sql-query name="findAggregatePvtMsgCntForUserInContext">
      <return-scalar column="READ_STATUS" type="java.lang.Boolean"/>
      <return-scalar column="TYPE_UUID" type="java.lang.String"/>
      <return-scalar column="readCount" type="java.lang.Integer"/>
      select READ_STATUS, TYPE_UUID, count(READ_STATUS) as readCount
      from MFR_PVT_MSG_USR_T
      where USER_ID = :userId and
      CONTEXT_ID = :contextId
      group by READ_STATUS, TYPE_UUID
      </sql-query>

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                maintenanceteam Core Team
                Reporter:
                bahollad@indiana.edu Bryan Holladay (old account) (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code