From d6aca64cb10530461781d6c24a4a6267c33c925f Mon Sep 17 00:00:00 2001 From: Kyeonghun Lee Date: Fri, 14 Oct 2016 15:51:18 +0900 Subject: [PATCH] [TSAM-8760] query for getting unread count fixed Change-Id: Ie039aa383c0832d59c8f6ae1b2c42665dfbb3483 Signed-off-by: Kyeonghun Lee --- manager/src/msg-manager-notification.cpp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/manager/src/msg-manager-notification.cpp b/manager/src/msg-manager-notification.cpp index 760a114..d977352 100644 --- a/manager/src/msg-manager-notification.cpp +++ b/manager/src/msg-manager-notification.cpp @@ -1753,10 +1753,10 @@ int getLatestMsgInfo(MSG_MGR_NOTI_INFO_S *noti_info, bool isForInstantMessage) snprintf(sqlQuery, MAX_QUERY_LEN, "(COUNT(DISTINCT(CASE WHEN MAIN_TYPE = %d THEN MSG_ID END))) AS SMS_UNREAD_CNT, " "(COUNT(DISTINCT(CASE WHEN MAIN_TYPE = %d THEN MSG_ID END))) AS MMS_UNREAD_CNT " - "FROM %s WHERE READ_STATUS = 0;", + "FROM %s WHERE READ_STATUS = 0 AND (FOLDER_ID=%d OR FOLDER_ID=%d) AND STORAGE_ID = %d;", MSG_SMS_TYPE, MSG_MMS_TYPE, - MSGFW_MESSAGE_TABLE_NAME); + MSGFW_MESSAGE_TABLE_NAME, MSG_INBOX_ID, MSG_CBMSGBOX_ID, MSG_STORAGE_PHONE); MSG_MGR_DEBUG("sqlQuery [%s]", sqlQuery); -- 2.7.4