Adding spaces between terms in Tenant Profile queries
Project: http://git-wip-us.apache.org/repos/asf/airavata/repo Commit: http://git-wip-us.apache.org/repos/asf/airavata/commit/9a273857 Tree: http://git-wip-us.apache.org/repos/asf/airavata/tree/9a273857 Diff: http://git-wip-us.apache.org/repos/asf/airavata/diff/9a273857 Branch: refs/heads/develop Commit: 9a27385743bac0a16cd63011095e6c6384c05863 Parents: 225b09c Author: Marcus Christie <[email protected]> Authored: Fri Jun 16 09:38:07 2017 -0400 Committer: Marcus Christie <[email protected]> Committed: Fri Jun 16 09:38:07 2017 -0400 ---------------------------------------------------------------------- .../airavata/service/profile/commons/utils/QueryConstants.java | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/airavata/blob/9a273857/airavata-services/profile-service/profile-service-commons/src/main/java/org/apache/airavata/service/profile/commons/utils/QueryConstants.java ---------------------------------------------------------------------- diff --git a/airavata-services/profile-service/profile-service-commons/src/main/java/org/apache/airavata/service/profile/commons/utils/QueryConstants.java b/airavata-services/profile-service/profile-service-commons/src/main/java/org/apache/airavata/service/profile/commons/utils/QueryConstants.java index b440ecc..caa72d9 100644 --- a/airavata-services/profile-service/profile-service-commons/src/main/java/org/apache/airavata/service/profile/commons/utils/QueryConstants.java +++ b/airavata-services/profile-service/profile-service-commons/src/main/java/org/apache/airavata/service/profile/commons/utils/QueryConstants.java @@ -17,11 +17,11 @@ public class QueryConstants { "where u.gatewayId LIKE :" + UserProfile._Fields.GATEWAY_ID.getFieldName() + ""; public static final String FIND_GATEWAY_BY_ID = "SELECT g FROM GatewayEntity g " + - "where g.gatewayId LIKE :" + Gateway._Fields.GATEWAY_ID.getFieldName() + + "where g.gatewayId LIKE :" + Gateway._Fields.GATEWAY_ID.getFieldName() + " " + "AND g.gatewayApprovalStatus LIKE :" + Gateway._Fields.GATEWAY_APPROVAL_STATUS.getFieldName(); public static final String GET_ALL_GATEWAYS = "SELECT g FROM GatewayEntity g"; - public static final String GET_USER_GATEWAYS = "SELECT g from GatewayEntity g" + + public static final String GET_USER_GATEWAYS = "SELECT g from GatewayEntity g " + "where g.requesterUsername LIKE :" + Gateway._Fields.REQUESTER_USERNAME.getFieldName() + ""; }
