List of findListIteratorByCondition() Examples

Examples of findListIteratorByCondition()

org.ofbiz.entity.Delegator.findListIteratorByCondition()
Finds GenericValues by the conditions specified in the EntityCondition object, the the EntityCondition javadoc for more details. NOTE 20080502: 9 references @param dynamicViewEntity The DynamicViewEntity to use for the entity model for this query; generally created on the fly for limited use @param whereEntityCondition The EntityCondition object that specifies how to constrain this query before any groupings are done (if this is a view entity with group-by aliases) @param havingEntityCondition The EntityCondition object that specifies how to constrain this query after any groupings are done (if this is a view entity with group-by aliases) @param fieldsToSelect The fields of the named entity to get from the database; if empty or null all fields will be retreived @param orderBy The fields of the named entity to order the query by; optionally add a " ASC" for ascending or " DESC" for descending @param findOptions An instance of EntityFindOptions that specifies advanced query options. See the EntityFindOptions JavaDoc for more details. @return EntityListIterator representing the result of the query: NOTETHAT THIS MUST BE CLOSED WHEN YOU ARE DONE WITH IT, AND DON'T LEAVE IT OPEN TOO LONG BEACUSE IT WILL MAINTAIN A DATABASE CONNECTION.
org.ofbiz.entity.GenericDelegator.findListIteratorByCondition()
org.ofbiz.entity.datasource.GenericHelper.findListIteratorByCondition()
Finds GenericValues by the conditions specified in the EntityCondition object, the the EntityCondition javadoc for more details. @param modelEntity The ModelEntity of the Entity as defined in the entity XML file @param whereEntityCondition The EntityCondition object that specifies how to constrain this query before any groupings are done (if this is a view entity with group-by aliases) @param havingEntityCondition The EntityCondition object that specifies how to constrain this query after any groupings are done (if this is a view entity with group-by aliases) @param fieldsToSelect The fields of the named entity to get from the database; if empty or null all fields will be retreived @param orderBy The fields of the named entity to order the query by; optionally add a " ASC" for ascending or " DESC" for descending @param findOptions An instance of EntityFindOptions that specifies advanced query options. See the EntityFindOptions JavaDoc for more details. @return EntityListIterator representing the result of the query: NOTE THAT THIS MUST BE CLOSED WHEN YOU AREDONE WITH IT, AND DON'T LEAVE IT OPEN TOO LONG BEACUSE IT WILL MAINTAIN A DATABASE CONNECTION.

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()

            }


            // Make a query against the production usage view entity
            EntityListIterator productionUsageIt = null;
            try {
                productionUsageIt = delegator.findListIteratorByCondition(productionUsageViewEntity,
                        EntityCondition.makeCondition(
                            UtilMisc.toList(
                                EntityCondition.makeCondition("facilityId", EntityOperator.EQUALS, facilityId),
                                EntityCondition.makeCondition("productId", EntityOperator.EQUALS, productId),
                                EntityCondition.makeCondition("workEffortTypeId", EntityOperator.EQUALS, "PROD_ORDER_TASK"),

View Full Code Here

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()


        if (cond != null) {
            EntityListIterator eli = null;
            try {
                // do the lookup
                eli = delegator.findListIteratorByCondition(dve, cond, null, fieldsToSelect, orderBy, findOpts);


                orderCount = eli.getResultsSizeAfterPartialList();


                // get the partial list for this page
                eli.beforeFirst();

View Full Code Here

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()

        if (! UtilValidate.isEmpty(checkTime)) {


            // Make a query against the sales usage view entity
            EntityListIterator salesUsageIt = null;
            try {
                salesUsageIt = delegator.findListIteratorByCondition(salesUsageViewEntity,
                        EntityCondition.makeCondition(
                            UtilMisc.toList(
                                EntityCondition.makeCondition("facilityId", EntityOperator.EQUALS, facilityId),
                                EntityCondition.makeCondition("productId", EntityOperator.EQUALS, productId),
                                EntityCondition.makeCondition("statusId", EntityOperator.IN, UtilMisc.toList("ORDER_COMPLETED", "ORDER_APPROVED", "ORDER_HELD")),

View Full Code Here

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()

            }


            // Make a query against the production usage view entity
            EntityListIterator productionUsageIt = null;
            try {
                productionUsageIt = delegator.findListIteratorByCondition(productionUsageViewEntity,
                        EntityCondition.makeCondition(
                            UtilMisc.toList(
                                EntityCondition.makeCondition("facilityId", EntityOperator.EQUALS, facilityId),
                                EntityCondition.makeCondition("productId", EntityOperator.EQUALS, productId),
                                EntityCondition.makeCondition("workEffortTypeId", EntityOperator.EQUALS, "PROD_ORDER_TASK"),

View Full Code Here

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()


        if (cond != null) {
            EntityListIterator eli = null;
            try {
                // do the lookup
                eli = delegator.findListIteratorByCondition(dve, cond, null, fieldsToSelect, orderBy, findOpts);


                orderCount = eli.getResultsSizeAfterPartialList();


                // get the partial list for this page
                eli.beforeFirst();

View Full Code Here

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()

        Delegator delegator = this.getDelegator();
        DynamicViewEntity view = this.makeView();
        EntityListIterator eli = null;
        List result = null;
        try {
            eli = delegator.findListIteratorByCondition(view, this.getCondition(), null, null, null, null);
            result = eli.getCompleteList();
        } catch (GenericEntityException e) {
            throw e;
        } finally {
            eli.close();

View Full Code Here

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()


                try {
                    // set distinct on so we only get one row per person
                    EntityFindOptions findOpts = new EntityFindOptions(true, EntityFindOptions.TYPE_SCROLL_INSENSITIVE, EntityFindOptions.CONCUR_READ_ONLY, -1, maxRows, true);
                    // using list iterator
                    EntityListIterator pli = delegator.findListIteratorByCondition(dynamicView, mainCond, null, fieldsToSelect, orderBy, findOpts);


                    // get the partial list for this page
                    partyList = pli.getPartialList(1, maxRows);


                    // close the list iterator

View Full Code Here

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()

            }
        }
        mainCond = EntityCondition.makeCondition(andExprs, EntityOperator.AND);
        List<GenericValue> parties = null;
        try {
            EntityListIterator pli = delegator.findListIteratorByCondition(dynamicView, mainCond, null, null, orderBy, null);
            parties = EntityUtil.filterByDate(pli.getCompleteList(), true);
            pli.close();
        } catch (GenericEntityException e) {
            Debug.logError(e, module);
        }

View Full Code Here

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()

                    highIndex = (viewIndex + 1) * viewSize;


                    // set distinct on so we only get one row per order
                    EntityFindOptions findOpts = new EntityFindOptions(true, EntityFindOptions.TYPE_SCROLL_INSENSITIVE, EntityFindOptions.CONCUR_READ_ONLY, -1, highIndex, true);
                    // using list iterator
                    EntityListIterator pli = delegator.findListIteratorByCondition(dynamicView, mainCond, null, fieldsToSelect, orderBy, findOpts);


                    // get the partial list for this page
                    partyList = pli.getPartialList(lowIndex, viewSize);


                    // attempt to get the full size

View Full Code Here

Examples of org.ofbiz.entity.Delegator.findListIteratorByCondition()


        if (cond != null) {
            EntityListIterator eli = null;
            try {
                // do the lookup
                eli = delegator.findListIteratorByCondition(dve, cond, null, fieldsToSelect, orderBy, findOpts);


                orderCount = eli.getResultsSizeAfterPartialList();


                // get the partial list for this page
                eli.beforeFirst();

View Full Code Here

0 1 2 3 4 5

TOP

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.