X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=src%2Fpkgmgrinfo_private.c;h=21b4840dd175e493d236d9152ff1624ca2060b68;hb=296b836f2187cedf267ad21b78aea105d6ba6e7e;hp=b7809f870c519ea7d0a1b04b84ecd1f9b2a0a081;hpb=0b13b9bc2b0576b26c8fa70f26c27e109d5b4656;p=platform%2Fcore%2Fappfw%2Fpkgmgr-info.git

diff --git a/src/pkgmgrinfo_private.c b/src/pkgmgrinfo_private.c
index b7809f8..21b4840 100644
--- a/src/pkgmgrinfo_private.c
+++ b/src/pkgmgrinfo_private.c
@@ -394,14 +394,12 @@ int __get_filter_condition(gpointer data, uid_t uid, char **condition, GList **p
 		break;
 	case E_PMINFO_APPINFO_PROP_APP_DISABLE:
 		if (strcasecmp(node->value, "true") == 0)
-			snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE OR "
-					"ai.app_id IN (SELECT app_id FROM package_app_info_for_uid "
-					"WHERE uid=%d AND is_disabled='true'))", uid);
+			snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE " \
+					"OR ui.is_disabled='true' COLLATE NOCASE)");
 		else
-			snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE AND "
-					"ai.app_id NOT IN (SELECT app_id FROM package_app_info_for_uid "
-					"WHERE uid=%d AND is_disabled='true'))", uid);
-		flag = E_PMINFO_APPINFO_JOIN_APPINFO_FOR_UID;
+			snprintf(buf, MAX_QUERY_LEN, "(ai.app_disable=? COLLATE NOCASE " \
+					"AND (ui.is_disabled='false' COLLATE NOCASE " \
+					"OR ui.is_disabled IS NULL))");
 		break;
 	case E_PMINFO_APPINFO_PROP_APP_SUPPORT_DISABLE:
 		snprintf(buf, MAX_QUERY_LEN, "ai.app_support_disable=? COLLATE NOCASE");