diff options
| author | Kyeonghun Lee <kh9090.lee@samsung.com> | 2017-01-04 18:16:35 +0900 |
|---|---|---|
| committer | Kyeonghun Lee <kh9090.lee@samsung.com> | 2017-01-04 16:43:46 -0800 |
| commit | 9d1243c5d91c8ae985dd133204f7d2d952ff7320 (patch) | |
| tree | 2080fa30954179342724d1b100f18efeb5300d1b /utils/MsgUtilStorage.cpp | |
| parent | 7e7a7139e9332866ba1d3728cb5db17fa78e8131 (diff) | |
| download | msg-service-9d1243c5d91c8ae985dd133204f7d2d952ff7320.tar.gz msg-service-9d1243c5d91c8ae985dd133204f7d2d952ff7320.tar.bz2 msg-service-9d1243c5d91c8ae985dd133204f7d2d952ff7320.zip | |
fix query in MsgStoSearchMessage() for 3.0 UX
Change-Id: Ie5d4e6b8bdf4cc70737050f00ef74d2e44f18bb4
Signed-off-by: Kyeonghun Lee <kh9090.lee@samsung.com>
(cherry picked from commit fd2c258a6b981011d9e71a01eea05558e84f4006)
Diffstat (limited to 'utils/MsgUtilStorage.cpp')
| -rwxr-xr-x | utils/MsgUtilStorage.cpp | 6 |
1 files 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 " |