Examples of org.ofbiz.entity.condition.EntityWhereString

org.ofbiz.entity.condition.EntityWhereString

Encapsulates SQL expressions used for where clause snippets. NOTE: This is UNSAFE and BREAKS the idea behind the Entity Engine where you avoid directly specifying SQL. So, KEEP IT MINIMAL and preferably replace it when the feature you are getting at is implemented in a more automatic way for you.

By minimal I mean use this in conjunction with other EntityConditions like the EntityExpr, EntityConditionList and EntityFieldMap objects which more cleanly encapsulate where conditions and don't require you to directly write SQL.

    // TODO replace SQL with EntityCondition
    String whereStr = " ( ( EntityAccess.ENTITY_ID = Activity.ACCOUNT_ID AND EntityAccess.ENTITY = 'Account' ) " +
                       " OR ( EntityAccess.ENTITY_ID = Activity.LEAD_ID AND EntityAccess.ENTITY = 'Lead' )" +
                       " OR ( EntityAccess.ENTITY_ID = Activity.OPPORTUNITY_ID AND EntityAccess.ENTITY = 'Deal' ) ) ";
    
    EntityCondition whereCondition = new EntityWhereString(whereStr);
    queryInfo.addCondition( whereCondition );
        queryInfo.addCondition( "Role", "rolePath", EntityOperator.LIKE, "%" + userInfo.getRoleId() + "%");


        return STATUS_CONTINUE;
    }

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.

Examples of org.ofbiz.entity.condition.EntityWhereString

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