From fd2c258a6b981011d9e71a01eea05558e84f4006 Mon Sep 17 00:00:00 2001 From: Kyeonghun Lee Date: Wed, 4 Jan 2017 18:16:35 +0900 Subject: [PATCH] fix query in MsgStoSearchMessage() for 3.0 UX Change-Id: Ie5d4e6b8bdf4cc70737050f00ef74d2e44f18bb4 Signed-off-by: Kyeonghun Lee --- utils/MsgUtilStorage.cpp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/utils/MsgUtilStorage.cpp b/utils/MsgUtilStorage.cpp index 946ef51..5f8b539 100755 --- a/utils/MsgUtilStorage.cpp +++ b/utils/MsgUtilStorage.cpp @@ -2106,9 +2106,9 @@ msg_error_t MsgStoSearchMessage(const char *pSearchString, msg_struct_list_s *pT snprintf(sqlQuery, MAX_QUERY_LEN, "SELECT A.CONV_ID, A.UNREAD_CNT, A.SMS_CNT, A.MMS_CNT, A.DISPLAY_NAME, " "A.MAIN_TYPE, A.SUB_TYPE, A.MSG_DIRECTION, A.DISPLAY_TIME, A.MSG_TEXT, " "(SELECT COUNT(*) FROM %s B WHERE B.CONV_ID = A.CONV_ID AND B.PROTECTED = 1) AS PROTECTED, " - "(SELECT COUNT(*) FROM %s B WHERE B.CONV_ID = A.CONV_ID AND B.FOLDER_ID = %d) AS DRAFT, " - "(SELECT COUNT(*) FROM %s B WHERE B.CONV_ID = A.CONV_ID AND B.NETWORK_STATUS = %d) AS FAILED, " - "(SELECT COUNT(*) FROM %s B WHERE B.CONV_ID = A.CONV_ID AND B.NETWORK_STATUS = %d) AS SENDING " + "(SELECT COUNT(*) FROM %s B WHERE B.MSG_ID = A.LAST_MSG_ID AND B.FOLDER_ID = %d) AS DRAFT, " + "(SELECT COUNT(*) FROM %s B WHERE B.MSG_ID = A.LAST_MSG_ID AND B.NETWORK_STATUS = %d) AS FAILED, " + "(SELECT COUNT(*) FROM %s B WHERE B.MSG_ID = A.LAST_MSG_ID AND B.NETWORK_STATUS = %d) AS SENDING " "FROM %s A WHERE (A.SMS_CNT > 0 OR A.MMS_CNT > 0) " "AND A.CONV_ID IN " "(SELECT DISTINCT(CONV_ID) FROM %s WHERE " -- 2.7.4