public void xqderiveMemberServiceList( String function, SubQuery<MemberServiceCB> subQuery, String operand, Object value, DerivedReferrerOption option) { assertObjectNotNull("subQuery<MemberServiceCB>", subQuery); MemberServiceCB cb = new MemberServiceCB(); cb.xsetupForDerivedReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepServiceRankCode_QueryDerivedReferrer_MemberServiceList( cb.query()); // for saving query-value. String parameterPropertyName = keepServiceRankCode_QueryDerivedReferrer_MemberServiceListParameter(value); registerQueryDerivedReferrer( function, cb.query(), "SERVICE_RANK_CODE", "SERVICE_RANK_CODE", subQueryPropertyName, operand, value, parameterPropertyName, option); }
public void xqderiveMemberAddressList( String function, SubQuery<MemberAddressCB> subQuery, String operand, Object value, DerivedReferrerOption option) { assertObjectNotNull("subQuery<MemberAddressCB>", subQuery); MemberAddressCB cb = new MemberAddressCB(); cb.xsetupForDerivedReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepRegionId_QueryDerivedReferrer_MemberAddressList(cb.query()); // for saving query-value. String parameterPropertyName = keepRegionId_QueryDerivedReferrer_MemberAddressListParameter(value); registerQueryDerivedReferrer( function, cb.query(), "REGION_ID", "REGION_ID", subQueryPropertyName, operand, value, parameterPropertyName, option); }
/** * Myself InScope (SubQuery). {mainly to avoid CLOB and Union problem or no master table} * * @param subQuery The implementation of sub query. (NotNull) */ public void myselfInScope(SubQuery<ServiceRankCB> subQuery) { assertObjectNotNull("subQuery<ServiceRankCB>", subQuery); ServiceRankCB cb = new ServiceRankCB(); cb.xsetupForMyselfInScope(this); subQuery.query(cb); String subQueryPropertyName = keepMyselfInScope(cb.query()); // for saving query-value. registerMyselfInScope(cb.query(), subQueryPropertyName); }
protected void xscalarCondition(String function, SubQuery<RegionCB> subQuery, String operand) { assertObjectNotNull("subQuery<RegionCB>", subQuery); RegionCB cb = new RegionCB(); cb.xsetupForScalarCondition(this); subQuery.query(cb); String subQueryPropertyName = keepScalarCondition(cb.query()); // for saving query-value. registerScalarCondition(function, cb.query(), subQueryPropertyName, operand); }
/** * Set up NotInScopeRelation (sub-query). <br> * {not in (select REGION_ID from MEMBER_ADDRESS where ...)} <br> * MEMBER_ADDRESS as 'memberAddressAsOne'. * * @param subQuery The sub-query of MemberAddressList for 'not in-scope'. (NotNull) */ public void notInScopeMemberAddressList(SubQuery<MemberAddressCB> subQuery) { assertObjectNotNull("subQuery<MemberAddressCB>", subQuery); MemberAddressCB cb = new MemberAddressCB(); cb.xsetupForInScopeRelation(this); subQuery.query(cb); String subQueryPropertyName = keepRegionId_NotInScopeRelation_MemberAddressList(cb.query()); // for saving query-value. registerNotInScopeRelation(cb.query(), "REGION_ID", "REGION_ID", subQueryPropertyName); }
/** * Set up ExistsReferrer (co-related sub-query). <br> * {exists (select REGION_ID from MEMBER_ADDRESS where ...)} <br> * MEMBER_ADDRESS as 'memberAddressAsOne'. * * <pre> * cb.query().<span style="color: #FD4747">existsMemberAddressList</span>(new SubQuery<MemberAddressCB>() { * public void query(RegionCB subCB) { * subCB.query().setXxx... * } * }); * </pre> * * @param subQuery The sub-query of MemberAddressList for 'exists'. (NotNull) */ public void existsMemberAddressList(SubQuery<MemberAddressCB> subQuery) { assertObjectNotNull("subQuery<MemberAddressCB>", subQuery); MemberAddressCB cb = new MemberAddressCB(); cb.xsetupForExistsReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepRegionId_ExistsReferrer_MemberAddressList(cb.query()); // for saving query-value. registerExistsReferrer(cb.query(), "REGION_ID", "REGION_ID", subQueryPropertyName); }
/** * Set up ExistsReferrer (co-related sub-query). <br> * {exists (select SERVICE_RANK_CODE from MEMBER_SERVICE where ...)} <br> * MEMBER_SERVICE as 'memberServiceAsOne'. * * <pre> * cb.query().<span style="color: #FD4747">existsMemberServiceList</span>(new SubQuery<MemberServiceCB>() { * public void query(ServiceRankCB subCB) { * subCB.query().setXxx... * } * }); * </pre> * * @param subQuery The sub-query of MemberServiceList for 'exists'. (NotNull) */ public void existsMemberServiceList(SubQuery<MemberServiceCB> subQuery) { assertObjectNotNull("subQuery<MemberServiceCB>", subQuery); MemberServiceCB cb = new MemberServiceCB(); cb.xsetupForExistsReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepServiceRankCode_ExistsReferrer_MemberServiceList(cb.query()); // for saving query-value. registerExistsReferrer( cb.query(), "SERVICE_RANK_CODE", "SERVICE_RANK_CODE", subQueryPropertyName); }
/** * Set up NotInScopeRelation (sub-query). <br> * {not in (select SERVICE_RANK_CODE from MEMBER_SERVICE where ...)} <br> * MEMBER_SERVICE as 'memberServiceAsOne'. * * @param subQuery The sub-query of MemberServiceList for 'not in-scope'. (NotNull) */ public void notInScopeMemberServiceList(SubQuery<MemberServiceCB> subQuery) { assertObjectNotNull("subQuery<MemberServiceCB>", subQuery); MemberServiceCB cb = new MemberServiceCB(); cb.xsetupForInScopeRelation(this); subQuery.query(cb); String subQueryPropertyName = keepServiceRankCode_NotInScopeRelation_MemberServiceList( cb.query()); // for saving query-value. registerNotInScopeRelation( cb.query(), "SERVICE_RANK_CODE", "SERVICE_RANK_CODE", subQueryPropertyName); }
public void xsderiveMemberAddressList( String function, SubQuery<MemberAddressCB> subQuery, String aliasName, DerivedReferrerOption option) { assertObjectNotNull("subQuery<MemberAddressCB>", subQuery); MemberAddressCB cb = new MemberAddressCB(); cb.xsetupForDerivedReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepRegionId_SpecifyDerivedReferrer_MemberAddressList( cb.query()); // for saving query-value. registerSpecifyDerivedReferrer( function, cb.query(), "REGION_ID", "REGION_ID", subQueryPropertyName, aliasName, option); }
public void xsderiveMemberServiceList( String function, SubQuery<MemberServiceCB> subQuery, String aliasName, DerivedReferrerOption option) { assertObjectNotNull("subQuery<MemberServiceCB>", subQuery); MemberServiceCB cb = new MemberServiceCB(); cb.xsetupForDerivedReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepServiceRankCode_SpecifyDerivedReferrer_MemberServiceList( cb.query()); // for saving query-value. registerSpecifyDerivedReferrer( function, cb.query(), "SERVICE_RANK_CODE", "SERVICE_RANK_CODE", subQueryPropertyName, aliasName, option); }