Package org.ofbiz.entity.condition

Examples of org.ofbiz.entity.condition.EntityConditionList


    dve.addViewLink("EntityAccess", "TeamMember", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("partyId", "teamId")));
    dve.addAlias("EntityAccess", "partyEntityType", null, null, null, null, null);
    dve.addAlias("EntityAccess", "entity", null, null, null, null, null);
    dve.addAlias("TeamMember", "tmPartyId", "partyId", null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("entity", EntityOperator.EQUALS, "Deal"),
             new EntityExpr("partyEntityType", EntityOperator.EQUALS, "Team"),
        new EntityExpr("tmPartyId", EntityOperator.EQUALS, partyId),
        new EntityExpr("projectedCloseDate", EntityOperator.LESS_THAN_EQUAL_TO, endDate),
        new EntityExpr("projectedCloseDate", EntityOperator.GREATER_THAN_EQUAL_TO, beginDate),
View Full Code Here


     
      if ( isOuterJoin )
      {
        queryInfo.addAlias("Address", "isPrimary", "isPrimary");
        queryInfo.addAlias("Address", "addressId", "addressId");
        queryInfo.addCondition( new EntityConditionList( UtilMisc.toList( new EntityExpr("isPrimary", EntityOperator.EQUALS, "Y"),
                      new EntityExpr("addressId", EntityOperator.EQUALS, null)), EntityOperator.OR));
      }
      else
        queryInfo.addCondition("Address", "isPrimary", EntityOperator.EQUALS, "Y");
View Full Code Here

    DynamicViewEntity dve = EntityHelper.createDynamicViewEntity( delegator, "RoleType");
    dve.addMemberEntity("Code", "Code");
    dve.addViewLink("RoleType", "Code", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("roleTypeId", "codeId")));
    dve.addAlias("Code", "codeTypeId", null, null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("codeTypeId", EntityOperator.EQUALS, "ROLE_TYPE_SFA")),
        EntityOperator.AND);
       
        try {
            return EntityHelper.getPrimaryGVLFromDynamicGVL(delegator, EntityHelper.findByCondition( delegator, dve, condition, orderBy ), "RoleType");
View Full Code Here

        DynamicViewEntity dve = EntityHelper.createDynamicViewEntity( delegator, "UiAttribute");
    dve.addMemberEntity("UiEntity", "UiEntity");
    dve.addViewLink("UiAttribute", "UiEntity", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("entityId", "entityId")));
    dve.addAlias("UiEntity", "entityName", null, null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("attributeName", EntityOperator.EQUALS, searchAttribName),
        new EntityExpr("entityName", EntityOperator.EQUALS, searchEntityName)),
        EntityOperator.AND);
       
        List queryGVL = EntityHelper.findByCondition( delegator, dve, condition, null );
View Full Code Here

      DynamicViewEntity dve = EntityHelper.createDynamicViewEntity( delegator, "UiAttribute");
      dve.addMemberEntity("UiScreenSectionEntity", "UiScreenSectionEntity");
      dve.addViewLink("UiAttribute", "UiScreenSectionEntity", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("entityId", "entityId")));
      dve.addAlias("UiScreenSectionEntity", "sectionId", null, null, null, null, null);
    
      EntityCondition condition = new EntityConditionList(UtilMisc.toList(
          new EntityExpr("sectionId", EntityOperator.EQUALS, sectionId)),
          EntityOperator.AND);

            try {
                return EntityHelper.findByCondition( delegator, dve, condition, orderBy);
View Full Code Here

      queryInfo.addCondition( "EntityAccess", "partyEntityType", EntityOperator.EQUALS, "Role");
      queryInfo.addJoin( "EntityAccess", "Role", Boolean.FALSE, "partyId", "roleId");

      queryInfo.checkAttribute("EntityAccess", "entityCreatedBy");
      queryInfo.checkAttribute("Role", "rolePath");
      EntityCondition condition  = new EntityConditionList( UtilMisc.toList(
        new EntityExpr( "entityCreatedBy", EntityOperator.EQUALS, userInfo.getPartyId() ),
        new EntityExpr( "rolePath", EntityOperator.LIKE, roleId)), EntityOperator.OR);
       
      queryInfo.addCondition( condition );
View Full Code Here

    dve.addMemberEntity("ProductAttribute", "ProductAttribute");
    dve.addViewLink("Product", "ProductAttribute", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("productId", "productId")));
    dve.addAlias("ProductAttribute", "attrName", null, null, null, null, null);
    dve.addAlias("ProductAttribute", "attrValue", null, null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("attrName", EntityOperator.EQUALS, "OWNER"),
        new EntityExpr("attrValue", EntityOperator.EQUALS, userInfo.getAccountId())),
        EntityOperator.AND);
       
    return EntityHelper.findByCondition( delegator, dve, condition, null );
View Full Code Here

    dve.addMemberEntity("ProductCategoryAttribute", "ProductCategoryAttribute");
    dve.addViewLink("ProductCategory", "ProductCategoryAttribute", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("productCategoryId", "productCategoryId")));
    dve.addAlias("ProductCategoryAttribute", "attrName", null, null, null, null, null);
    dve.addAlias("ProductCategoryAttribute", "attrValue", null, null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("attrName", EntityOperator.EQUALS, "OWNER"),
        new EntityExpr("attrValue", EntityOperator.EQUALS, userInfo.getAccountId())),
        EntityOperator.AND);
       
        return EntityHelper.findByCondition( delegator, dve, condition, null );
View Full Code Here

    dve.addMemberEntity("UiScreen", "UiScreen");
    dve.addViewLink("UiScreenSection", "UiScreen", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("screenId", "screenId")));
    dve.addAlias("UiScreen", "screenName", null, null, null, null, null);
    dve.addAlias("UiScreenSection", "sectionName", null, null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("partyId", EntityOperator.EQUALS, "-1"),
        new EntityExpr("screenName", EntityOperator.EQUALS, screenName),
        new EntityExpr("sectionName", EntityOperator.EQUALS, sectionName)),
        EntityOperator.AND);
       
      uiQueryGVL.addAll(EntityHelper.findByCondition( delegator, dve, condition, uiQueryFindOrder ));

        // Add all queries tied to the current party ID and screen section.
    // select X from ui_query q, ui_screen_section ss, ui_screen s where q.section_id = ss.section_id and q.party_id = <partyId> and ss.section_name = <section_name>
    //      and s.screen_name = <screenName> and s.screen_id = ss.screen_id order by query_name      
    condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("partyId", EntityOperator.EQUALS, partyId),
        new EntityExpr("screenName", EntityOperator.EQUALS, screenName),
        new EntityExpr("sectionName", EntityOperator.EQUALS, sectionName)),
        EntityOperator.AND);
       
View Full Code Here

    dve.addMemberEntity("UiScreen", "UiScreen");
    dve.addViewLink("UiScreenSection", "UiScreen",Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("screenId", "screenId")));
    dve.addAlias("UiScreen", "screenName", null, null, null, null, null);
    dve.addAlias("UiScreenSection", "sectionName", null, null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("partyId", EntityOperator.EQUALS, partyId),
           new EntityExpr("queryName", EntityOperator.EQUALS, savedQueryName),
        new EntityExpr("screenName", EntityOperator.EQUALS, screenName),
        new EntityExpr("sectionName", EntityOperator.EQUALS, sectionName)),
        EntityOperator.AND);
View Full Code Here

TOP

Related Classes of org.ofbiz.entity.condition.EntityConditionList

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.