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

          Zeplin

            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 Integration