Interface CommercePriceListPersistence

All Superinterfaces:
com.liferay.portal.kernel.service.persistence.BasePersistence<CommercePriceList>, com.liferay.portal.kernel.service.persistence.change.tracking.CTPersistence<CommercePriceList>

@ProviderType public interface CommercePriceListPersistence extends com.liferay.portal.kernel.service.persistence.BasePersistence<CommercePriceList>, com.liferay.portal.kernel.service.persistence.change.tracking.CTPersistence<CommercePriceList>
The persistence interface for the commerce price list service.

Caching information and settings can be found in portal.properties

See Also:
Generated:
  • Method Summary

    Modifier and Type
    Method
    Description
    int
    countByC_C(long companyId, String commerceCurrencyCode)
    Returns the number of commerce price lists where companyId = ? and commerceCurrencyCode = ?.
    int
    countByCompanyId(long companyId)
    Returns the number of commerce price lists where companyId = ?.
    int
    countByERC_C(String externalReferenceCode, long companyId)
    Returns the number of commerce price lists where externalReferenceCode = ? and companyId = ?.
    int
    countByG_C(long[] groupIds, long companyId)
    Returns the number of commerce price lists where groupId = any ? and companyId = ?.
    int
    countByG_C(long groupId, long companyId)
    Returns the number of commerce price lists where groupId = ? and companyId = ?.
    int
    countByG_C_NotS(long[] groupIds, long companyId, int status)
    Returns the number of commerce price lists where groupId = any ? and companyId = ? and status ≠ ?.
    int
    countByG_C_NotS(long groupId, long companyId, int status)
    Returns the number of commerce price lists where groupId = ? and companyId = ? and status ≠ ?.
    int
    countByG_C_S(long[] groupIds, long companyId, int status)
    Returns the number of commerce price lists where groupId = any ? and companyId = ? and status = ?.
    int
    countByG_C_S(long groupId, long companyId, int status)
    Returns the number of commerce price lists where groupId = ? and companyId = ? and status = ?.
    int
    countByG_C_T_NotS(long[] groupIds, long companyId, String type, int status)
    Returns the number of commerce price lists where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
    int
    countByG_C_T_NotS(long groupId, long companyId, String type, int status)
    Returns the number of commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    int
    countByG_C_T_S(long[] groupIds, long companyId, String type, int status)
    Returns the number of commerce price lists where groupId = any ? and companyId = ? and type = ? and status = ?.
    int
    countByG_C_T_S(long groupId, long companyId, String type, int status)
    Returns the number of commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.
    int
    countByG_CBPL(long groupId, boolean catalogBasePriceList)
    Returns the number of commerce price lists where groupId = ? and catalogBasePriceList = ?.
    int
    countByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
    Returns the number of commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.
    int
    countByLtD_S(Date displayDate, int status)
    Returns the number of commerce price lists where displayDate < ? and status = ?.
    int
    countByParentCommercePriceListId(long parentCommercePriceListId)
    Returns the number of commerce price lists where parentCommercePriceListId = ?.
    int
    Returns the number of commerce price lists where uuid = ?.
    int
    countByUuid_C(String uuid, long companyId)
    Returns the number of commerce price lists where uuid = ? and companyId = ?.
    int
    countByUUID_G(String uuid, long groupId)
    Returns the number of commerce price lists where uuid = ? and groupId = ?.
    create(long commercePriceListId)
    Creates a new commerce price list with the primary key.
    fetchByC_C_First(long companyId, String commerceCurrencyCode, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where companyId = ? and commerceCurrencyCode = ?.
    fetchByCompanyId_First(long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where companyId = ?.
    fetchByERC_C(String externalReferenceCode, long companyId)
    Returns the commerce price list where externalReferenceCode = ? and companyId = ? or returns null if it could not be found.
    fetchByERC_C(String externalReferenceCode, long companyId, boolean useFinderCache)
    Returns the commerce price list where externalReferenceCode = ? and companyId = ? or returns null if it could not be found, optionally using the finder cache.
    fetchByG_C_First(long groupId, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ?.
    fetchByG_C_NotS_First(long groupId, long companyId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and status ≠ ?.
    fetchByG_C_S_First(long groupId, long companyId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and status = ?.
    fetchByG_C_T_NotS_First(long groupId, long companyId, String type, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    fetchByG_C_T_S_First(long groupId, long companyId, String type, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and type = ? and status = ?.
    fetchByG_CBPL_First(long groupId, boolean catalogBasePriceList, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and catalogBasePriceList = ?.
    fetchByG_CBPL_T_First(long groupId, boolean catalogBasePriceList, String type, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and catalogBasePriceList = ? and type = ?.
    fetchByLtD_S_First(Date displayDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where displayDate < ? and status = ?.
    fetchByParentCommercePriceListId_First(long parentCommercePriceListId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where parentCommercePriceListId = ?.
    fetchByPrimaryKey(long commercePriceListId)
    Returns the commerce price list with the primary key or returns null if it could not be found.
    fetchByUuid_C_First(String uuid, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where uuid = ? and companyId = ?.
    fetchByUuid_First(String uuid, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where uuid = ?.
    fetchByUUID_G(String uuid, long groupId)
    Returns the commerce price list where uuid = ? and groupId = ? or returns null if it could not be found.
    fetchByUUID_G(String uuid, long groupId, boolean useFinderCache)
    Returns the commerce price list where uuid = ? and groupId = ? or returns null if it could not be found, optionally using the finder cache.
    int
    filterCountByG_C(long[] groupIds, long companyId)
    Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ?.
    int
    filterCountByG_C(long groupId, long companyId)
    Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ?.
    int
    filterCountByG_C_NotS(long[] groupIds, long companyId, int status)
    Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status ≠ ?.
    int
    filterCountByG_C_NotS(long groupId, long companyId, int status)
    Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status ≠ ?.
    int
    filterCountByG_C_S(long[] groupIds, long companyId, int status)
    Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status = ?.
    int
    filterCountByG_C_S(long groupId, long companyId, int status)
    Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status = ?.
    int
    filterCountByG_C_T_NotS(long[] groupIds, long companyId, String type, int status)
    Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
    int
    filterCountByG_C_T_NotS(long groupId, long companyId, String type, int status)
    Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    int
    filterCountByG_C_T_S(long[] groupIds, long companyId, String type, int status)
    Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status = ?.
    int
    filterCountByG_C_T_S(long groupId, long companyId, String type, int status)
    Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status = ?.
    int
    filterCountByG_CBPL(long groupId, boolean catalogBasePriceList)
    Returns the number of commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ?.
    int
    filterCountByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
    Returns the number of commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ? and type = ?.
    filterFindByG_C(long[] groupIds, long companyId)
    Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ?.
    filterFindByG_C(long[] groupIds, long companyId, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ?.
    filterFindByG_C(long[] groupIds, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ?.
    filterFindByG_C(long groupId, long companyId)
    Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ?.
    filterFindByG_C(long groupId, long companyId, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ?.
    filterFindByG_C(long groupId, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ?.
    filterFindByG_C_NotS(long[] groupIds, long companyId, int status)
    Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status ≠ ?.
    filterFindByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status ≠ ?.
    filterFindByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status ≠ ?.
    filterFindByG_C_NotS(long groupId, long companyId, int status)
    Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status ≠ ?.
    filterFindByG_C_NotS(long groupId, long companyId, int status, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status ≠ ?.
    filterFindByG_C_NotS(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ? and status ≠ ?.
    filterFindByG_C_S(long[] groupIds, long companyId, int status)
    Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status = ?.
    filterFindByG_C_S(long[] groupIds, long companyId, int status, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status = ?.
    filterFindByG_C_S(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status = ?.
    filterFindByG_C_S(long groupId, long companyId, int status)
    Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status = ?.
    filterFindByG_C_S(long groupId, long companyId, int status, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status = ?.
    filterFindByG_C_S(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ? and status = ?.
    filterFindByG_C_T_NotS(long[] groupIds, long companyId, String type, int status)
    Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
    filterFindByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
    filterFindByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
    filterFindByG_C_T_NotS(long groupId, long companyId, String type, int status)
    Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    filterFindByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    filterFindByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    filterFindByG_C_T_S(long[] groupIds, long companyId, String type, int status)
    Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status = ?.
    filterFindByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status = ?.
    filterFindByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status = ?.
    filterFindByG_C_T_S(long groupId, long companyId, String type, int status)
    Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status = ?.
    filterFindByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status = ?.
    filterFindByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ? and type = ? and status = ?.
    filterFindByG_CBPL(long groupId, boolean catalogBasePriceList)
    Returns all the commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ?.
    filterFindByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ?.
    filterFindByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and catalogBasePriceList = ?.
    filterFindByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
    Returns all the commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ? and type = ?.
    filterFindByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end)
    Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ? and type = ?.
    filterFindByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and catalogBasePriceList = ? and type = ?.
    findByC_C(long companyId, String commerceCurrencyCode)
    Returns all the commerce price lists where companyId = ? and commerceCurrencyCode = ?.
    findByC_C(long companyId, String commerceCurrencyCode, int start, int end)
    Returns a range of all the commerce price lists where companyId = ? and commerceCurrencyCode = ?.
    findByC_C(long companyId, String commerceCurrencyCode, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where companyId = ? and commerceCurrencyCode = ?.
    findByC_C(long companyId, String commerceCurrencyCode, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where companyId = ? and commerceCurrencyCode = ?.
    findByC_C_First(long companyId, String commerceCurrencyCode, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where companyId = ? and commerceCurrencyCode = ?.
    findByCompanyId(long companyId)
    Returns all the commerce price lists where companyId = ?.
    findByCompanyId(long companyId, int start, int end)
    Returns a range of all the commerce price lists where companyId = ?.
    findByCompanyId(long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where companyId = ?.
    findByCompanyId(long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where companyId = ?.
    findByCompanyId_First(long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where companyId = ?.
    findByERC_C(String externalReferenceCode, long companyId)
    Returns the commerce price list where externalReferenceCode = ? and companyId = ? or throws a NoSuchPriceListException if it could not be found.
    findByG_C(long[] groupIds, long companyId)
    Returns all the commerce price lists where groupId = any ? and companyId = ?.
    findByG_C(long[] groupIds, long companyId, int start, int end)
    Returns a range of all the commerce price lists where groupId = any ? and companyId = ?.
    findByG_C(long[] groupIds, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ?.
    findByG_C(long[] groupIds, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ?, optionally using the finder cache.
    findByG_C(long groupId, long companyId)
    Returns all the commerce price lists where groupId = ? and companyId = ?.
    findByG_C(long groupId, long companyId, int start, int end)
    Returns a range of all the commerce price lists where groupId = ? and companyId = ?.
    findByG_C(long groupId, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ?.
    findByG_C(long groupId, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ?.
    findByG_C_First(long groupId, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ?.
    findByG_C_NotS(long[] groupIds, long companyId, int status)
    Returns all the commerce price lists where groupId = any ? and companyId = ? and status ≠ ?.
    findByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end)
    Returns a range of all the commerce price lists where groupId = any ? and companyId = ? and status ≠ ?.
    findByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ? and status ≠ ?.
    findByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?, optionally using the finder cache.
    findByG_C_NotS(long groupId, long companyId, int status)
    Returns all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?.
    findByG_C_NotS(long groupId, long companyId, int status, int start, int end)
    Returns a range of all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?.
    findByG_C_NotS(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?.
    findByG_C_NotS(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?.
    findByG_C_NotS_First(long groupId, long companyId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and status ≠ ?.
    findByG_C_S(long[] groupIds, long companyId, int status)
    Returns all the commerce price lists where groupId = any ? and companyId = ? and status = ?.
    findByG_C_S(long[] groupIds, long companyId, int status, int start, int end)
    Returns a range of all the commerce price lists where groupId = any ? and companyId = ? and status = ?.
    findByG_C_S(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ? and status = ?.
    findByG_C_S(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status = ?, optionally using the finder cache.
    findByG_C_S(long groupId, long companyId, int status)
    Returns all the commerce price lists where groupId = ? and companyId = ? and status = ?.
    findByG_C_S(long groupId, long companyId, int status, int start, int end)
    Returns a range of all the commerce price lists where groupId = ? and companyId = ? and status = ?.
    findByG_C_S(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status = ?.
    findByG_C_S(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status = ?.
    findByG_C_S_First(long groupId, long companyId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and status = ?.
    findByG_C_T_NotS(long[] groupIds, long companyId, String type, int status)
    Returns all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
    findByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end)
    Returns a range of all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
    findByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
    findByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?, optionally using the finder cache.
    findByG_C_T_NotS(long groupId, long companyId, String type, int status)
    Returns all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    findByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end)
    Returns a range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    findByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    findByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    findByG_C_T_NotS_First(long groupId, long companyId, String type, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and type = ? and status ≠ ?.
    findByG_C_T_S(long[] groupIds, long companyId, String type, int status)
    Returns all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status = ?.
    findByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end)
    Returns a range of all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status = ?.
    findByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status = ?.
    findByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?, optionally using the finder cache.
    findByG_C_T_S(long groupId, long companyId, String type, int status)
    Returns all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.
    findByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end)
    Returns a range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.
    findByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.
    findByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.
    findByG_C_T_S_First(long groupId, long companyId, String type, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and type = ? and status = ?.
    findByG_CBPL(long groupId, boolean catalogBasePriceList)
    Returns all the commerce price lists where groupId = ? and catalogBasePriceList = ?.
    findByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end)
    Returns a range of all the commerce price lists where groupId = ? and catalogBasePriceList = ?.
    findByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = ? and catalogBasePriceList = ?.
    findByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and catalogBasePriceList = ?.
    findByG_CBPL_First(long groupId, boolean catalogBasePriceList, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and catalogBasePriceList = ?.
    findByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
    Returns all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.
    findByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end)
    Returns a range of all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.
    findByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.
    findByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.
    findByG_CBPL_T_First(long groupId, boolean catalogBasePriceList, String type, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where groupId = ? and catalogBasePriceList = ? and type = ?.
    findByLtD_S(Date displayDate, int status)
    Returns all the commerce price lists where displayDate < ? and status = ?.
    findByLtD_S(Date displayDate, int status, int start, int end)
    Returns a range of all the commerce price lists where displayDate < ? and status = ?.
    findByLtD_S(Date displayDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where displayDate < ? and status = ?.
    findByLtD_S(Date displayDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where displayDate < ? and status = ?.
    findByLtD_S_First(Date displayDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where displayDate < ? and status = ?.
    findByParentCommercePriceListId(long parentCommercePriceListId)
    Returns all the commerce price lists where parentCommercePriceListId = ?.
    findByParentCommercePriceListId(long parentCommercePriceListId, int start, int end)
    Returns a range of all the commerce price lists where parentCommercePriceListId = ?.
    findByParentCommercePriceListId(long parentCommercePriceListId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where parentCommercePriceListId = ?.
    findByParentCommercePriceListId(long parentCommercePriceListId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where parentCommercePriceListId = ?.
    findByParentCommercePriceListId_First(long parentCommercePriceListId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where parentCommercePriceListId = ?.
    findByPrimaryKey(long commercePriceListId)
    Returns the commerce price list with the primary key or throws a NoSuchPriceListException if it could not be found.
    Returns all the commerce price lists where uuid = ?.
    findByUuid(String uuid, int start, int end)
    Returns a range of all the commerce price lists where uuid = ?.
    findByUuid(String uuid, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where uuid = ?.
    findByUuid(String uuid, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where uuid = ?.
    findByUuid_C(String uuid, long companyId)
    Returns all the commerce price lists where uuid = ? and companyId = ?.
    findByUuid_C(String uuid, long companyId, int start, int end)
    Returns a range of all the commerce price lists where uuid = ? and companyId = ?.
    findByUuid_C(String uuid, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns an ordered range of all the commerce price lists where uuid = ? and companyId = ?.
    findByUuid_C(String uuid, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce price lists where uuid = ? and companyId = ?.
    findByUuid_C_First(String uuid, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where uuid = ? and companyId = ?.
    findByUuid_First(String uuid, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
    Returns the first commerce price list in the ordered set where uuid = ?.
    findByUUID_G(String uuid, long groupId)
    Returns the commerce price list where uuid = ? and groupId = ? or throws a NoSuchPriceListException if it could not be found.
    remove(long commercePriceListId)
    Removes the commerce price list with the primary key from the database.
    void
    removeByC_C(long companyId, String commerceCurrencyCode)
    Removes all the commerce price lists where companyId = ? and commerceCurrencyCode = ? from the database.
    void
    removeByCompanyId(long companyId)
    Removes all the commerce price lists where companyId = ? from the database.
    removeByERC_C(String externalReferenceCode, long companyId)
    Removes the commerce price list where externalReferenceCode = ? and companyId = ? from the database.
    void
    removeByG_C(long groupId, long companyId)
    Removes all the commerce price lists where groupId = ? and companyId = ? from the database.
    void
    removeByG_C_NotS(long groupId, long companyId, int status)
    Removes all the commerce price lists where groupId = ? and companyId = ? and status ≠ ? from the database.
    void
    removeByG_C_S(long groupId, long companyId, int status)
    Removes all the commerce price lists where groupId = ? and companyId = ? and status = ? from the database.
    void
    removeByG_C_T_NotS(long groupId, long companyId, String type, int status)
    Removes all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ? from the database.
    void
    removeByG_C_T_S(long groupId, long companyId, String type, int status)
    Removes all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ? from the database.
    void
    removeByG_CBPL(long groupId, boolean catalogBasePriceList)
    Removes all the commerce price lists where groupId = ? and catalogBasePriceList = ? from the database.
    void
    removeByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
    Removes all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ? from the database.
    void
    removeByLtD_S(Date displayDate, int status)
    Removes all the commerce price lists where displayDate < ? and status = ? from the database.
    void
    removeByParentCommercePriceListId(long parentCommercePriceListId)
    Removes all the commerce price lists where parentCommercePriceListId = ? from the database.
    void
    Removes all the commerce price lists where uuid = ? from the database.
    void
    removeByUuid_C(String uuid, long companyId)
    Removes all the commerce price lists where uuid = ? and companyId = ? from the database.
    removeByUUID_G(String uuid, long groupId)
    Removes the commerce price list where uuid = ? and groupId = ? from the database.
    updateImpl(CommercePriceList commercePriceList)
     

    Methods inherited from interface com.liferay.portal.kernel.service.persistence.BasePersistence

    cacheResult, cacheResult, clearCache, clearCache, clearCache, clearCache, closeSession, countAll, countWithDynamicQuery, countWithDynamicQuery, dslQuery, dslQuery, dslQueryCount, dslQueryCount, fetchByPrimaryKey, fetchByPrimaryKeys, findAll, findAll, findAll, findAll, findByPrimaryKey, findWithDynamicQuery, findWithDynamicQuery, findWithDynamicQuery, flush, getBadColumnNames, getCurrentSession, getDataSource, getDB, getDialect, getListeners, getModelClass, openSession, processException, reassociateIfAbsent, registerListener, remove, remove, removeAll, removeByFunction, setDataSource, unregisterListener, update, update

    Methods inherited from interface com.liferay.portal.kernel.service.persistence.change.tracking.CTPersistence

    getCTColumnNames, getMappingTableNames, getTableColumnsMap, getTableName, getUniqueIndexColumnNames
  • Method Details

    • findByUuid

      List<CommercePriceList> findByUuid(String uuid, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where uuid = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      uuid - the uuid
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByUuid_First

      CommercePriceList findByUuid_First(String uuid, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where uuid = ?.
      Parameters:
      uuid - the uuid
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByUuid_First

      CommercePriceList fetchByUuid_First(String uuid, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where uuid = ?.
      Parameters:
      uuid - the uuid
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • removeByUuid

      void removeByUuid(String uuid)
      Removes all the commerce price lists where uuid = ? from the database.
      Parameters:
      uuid - the uuid
    • countByUuid

      int countByUuid(String uuid)
      Returns the number of commerce price lists where uuid = ?.
      Parameters:
      uuid - the uuid
      Returns:
      the number of matching commerce price lists
    • findByUUID_G

      CommercePriceList findByUUID_G(String uuid, long groupId) throws NoSuchPriceListException
      Returns the commerce price list where uuid = ? and groupId = ? or throws a NoSuchPriceListException if it could not be found.
      Parameters:
      uuid - the uuid
      groupId - the group ID
      Returns:
      the matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByUUID_G

      CommercePriceList fetchByUUID_G(String uuid, long groupId, boolean useFinderCache)
      Returns the commerce price list where uuid = ? and groupId = ? or returns null if it could not be found, optionally using the finder cache.
      Parameters:
      uuid - the uuid
      groupId - the group ID
      useFinderCache - whether to use the finder cache
      Returns:
      the matching commerce price list, or null if a matching commerce price list could not be found
    • removeByUUID_G

      CommercePriceList removeByUUID_G(String uuid, long groupId) throws NoSuchPriceListException
      Removes the commerce price list where uuid = ? and groupId = ? from the database.
      Parameters:
      uuid - the uuid
      groupId - the group ID
      Returns:
      the commerce price list that was removed
      Throws:
      NoSuchPriceListException
    • countByUUID_G

      int countByUUID_G(String uuid, long groupId)
      Returns the number of commerce price lists where uuid = ? and groupId = ?.
      Parameters:
      uuid - the uuid
      groupId - the group ID
      Returns:
      the number of matching commerce price lists
    • findByUuid_C

      List<CommercePriceList> findByUuid_C(String uuid, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where uuid = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      uuid - the uuid
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByUuid_C_First

      CommercePriceList findByUuid_C_First(String uuid, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where uuid = ? and companyId = ?.
      Parameters:
      uuid - the uuid
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByUuid_C_First

      CommercePriceList fetchByUuid_C_First(String uuid, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where uuid = ? and companyId = ?.
      Parameters:
      uuid - the uuid
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • removeByUuid_C

      void removeByUuid_C(String uuid, long companyId)
      Removes all the commerce price lists where uuid = ? and companyId = ? from the database.
      Parameters:
      uuid - the uuid
      companyId - the company ID
    • countByUuid_C

      int countByUuid_C(String uuid, long companyId)
      Returns the number of commerce price lists where uuid = ? and companyId = ?.
      Parameters:
      uuid - the uuid
      companyId - the company ID
      Returns:
      the number of matching commerce price lists
    • findByCompanyId

      List<CommercePriceList> findByCompanyId(long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByCompanyId_First

      CommercePriceList findByCompanyId_First(long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where companyId = ?.
      Parameters:
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByCompanyId_First

      CommercePriceList fetchByCompanyId_First(long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where companyId = ?.
      Parameters:
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • removeByCompanyId

      void removeByCompanyId(long companyId)
      Removes all the commerce price lists where companyId = ? from the database.
      Parameters:
      companyId - the company ID
    • countByCompanyId

      int countByCompanyId(long companyId)
      Returns the number of commerce price lists where companyId = ?.
      Parameters:
      companyId - the company ID
      Returns:
      the number of matching commerce price lists
    • findByParentCommercePriceListId

      List<CommercePriceList> findByParentCommercePriceListId(long parentCommercePriceListId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where parentCommercePriceListId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      parentCommercePriceListId - the parent commerce price list ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByParentCommercePriceListId_First

      CommercePriceList findByParentCommercePriceListId_First(long parentCommercePriceListId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where parentCommercePriceListId = ?.
      Parameters:
      parentCommercePriceListId - the parent commerce price list ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByParentCommercePriceListId_First

      CommercePriceList fetchByParentCommercePriceListId_First(long parentCommercePriceListId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where parentCommercePriceListId = ?.
      Parameters:
      parentCommercePriceListId - the parent commerce price list ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • removeByParentCommercePriceListId

      void removeByParentCommercePriceListId(long parentCommercePriceListId)
      Removes all the commerce price lists where parentCommercePriceListId = ? from the database.
      Parameters:
      parentCommercePriceListId - the parent commerce price list ID
    • countByParentCommercePriceListId

      int countByParentCommercePriceListId(long parentCommercePriceListId)
      Returns the number of commerce price lists where parentCommercePriceListId = ?.
      Parameters:
      parentCommercePriceListId - the parent commerce price list ID
      Returns:
      the number of matching commerce price lists
    • findByG_C

      List<CommercePriceList> findByG_C(long groupId, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_First

      CommercePriceList findByG_C_First(long groupId, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByG_C_First

      CommercePriceList fetchByG_C_First(long groupId, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • filterFindByG_C

      List<CommercePriceList> filterFindByG_C(long groupId, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • filterFindByG_C

      List<CommercePriceList> filterFindByG_C(long[] groupIds, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • findByG_C

      List<CommercePriceList> findByG_C(long[] groupIds, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ?, optionally using the finder cache.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • removeByG_C

      void removeByG_C(long groupId, long companyId)
      Removes all the commerce price lists where groupId = ? and companyId = ? from the database.
      Parameters:
      groupId - the group ID
      companyId - the company ID
    • countByG_C

      int countByG_C(long groupId, long companyId)
      Returns the number of commerce price lists where groupId = ? and companyId = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      Returns:
      the number of matching commerce price lists
    • countByG_C

      int countByG_C(long[] groupIds, long companyId)
      Returns the number of commerce price lists where groupId = any ? and companyId = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      Returns:
      the number of matching commerce price lists
    • filterCountByG_C

      int filterCountByG_C(long groupId, long companyId)
      Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • filterCountByG_C

      int filterCountByG_C(long[] groupIds, long companyId)
      Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • findByG_CBPL

      List<CommercePriceList> findByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and catalogBasePriceList = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByG_CBPL_First

      CommercePriceList findByG_CBPL_First(long groupId, boolean catalogBasePriceList, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where groupId = ? and catalogBasePriceList = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByG_CBPL_First

      CommercePriceList fetchByG_CBPL_First(long groupId, boolean catalogBasePriceList, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where groupId = ? and catalogBasePriceList = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • filterFindByG_CBPL

      List<CommercePriceList> filterFindByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and catalogBasePriceList = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • removeByG_CBPL

      void removeByG_CBPL(long groupId, boolean catalogBasePriceList)
      Removes all the commerce price lists where groupId = ? and catalogBasePriceList = ? from the database.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
    • countByG_CBPL

      int countByG_CBPL(long groupId, boolean catalogBasePriceList)
      Returns the number of commerce price lists where groupId = ? and catalogBasePriceList = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      Returns:
      the number of matching commerce price lists
    • filterCountByG_CBPL

      int filterCountByG_CBPL(long groupId, boolean catalogBasePriceList)
      Returns the number of commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • findByC_C

      List<CommercePriceList> findByC_C(long companyId, String commerceCurrencyCode, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where companyId = ? and commerceCurrencyCode = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      companyId - the company ID
      commerceCurrencyCode - the commerce currency code
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByC_C_First

      CommercePriceList findByC_C_First(long companyId, String commerceCurrencyCode, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where companyId = ? and commerceCurrencyCode = ?.
      Parameters:
      companyId - the company ID
      commerceCurrencyCode - the commerce currency code
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByC_C_First

      CommercePriceList fetchByC_C_First(long companyId, String commerceCurrencyCode, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where companyId = ? and commerceCurrencyCode = ?.
      Parameters:
      companyId - the company ID
      commerceCurrencyCode - the commerce currency code
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • removeByC_C

      void removeByC_C(long companyId, String commerceCurrencyCode)
      Removes all the commerce price lists where companyId = ? and commerceCurrencyCode = ? from the database.
      Parameters:
      companyId - the company ID
      commerceCurrencyCode - the commerce currency code
    • countByC_C

      int countByC_C(long companyId, String commerceCurrencyCode)
      Returns the number of commerce price lists where companyId = ? and commerceCurrencyCode = ?.
      Parameters:
      companyId - the company ID
      commerceCurrencyCode - the commerce currency code
      Returns:
      the number of matching commerce price lists
    • findByLtD_S

      List<CommercePriceList> findByLtD_S(Date displayDate, int status)
      Returns all the commerce price lists where displayDate < ? and status = ?.
      Parameters:
      displayDate - the display date
      status - the status
      Returns:
      the matching commerce price lists
    • findByLtD_S

      List<CommercePriceList> findByLtD_S(Date displayDate, int status, int start, int end)
      Returns a range of all the commerce price lists where displayDate < ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      displayDate - the display date
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByLtD_S

      List<CommercePriceList> findByLtD_S(Date displayDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where displayDate < ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      displayDate - the display date
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByLtD_S

      List<CommercePriceList> findByLtD_S(Date displayDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where displayDate < ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      displayDate - the display date
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByLtD_S_First

      CommercePriceList findByLtD_S_First(Date displayDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where displayDate < ? and status = ?.
      Parameters:
      displayDate - the display date
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByLtD_S_First

      CommercePriceList fetchByLtD_S_First(Date displayDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where displayDate < ? and status = ?.
      Parameters:
      displayDate - the display date
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • removeByLtD_S

      void removeByLtD_S(Date displayDate, int status)
      Removes all the commerce price lists where displayDate < ? and status = ? from the database.
      Parameters:
      displayDate - the display date
      status - the status
    • countByLtD_S

      int countByLtD_S(Date displayDate, int status)
      Returns the number of commerce price lists where displayDate < ? and status = ?.
      Parameters:
      displayDate - the display date
      status - the status
      Returns:
      the number of matching commerce price lists
    • findByG_C_S

      List<CommercePriceList> findByG_C_S(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_S_First

      CommercePriceList findByG_C_S_First(long groupId, long companyId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByG_C_S_First

      CommercePriceList fetchByG_C_S_First(long groupId, long companyId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • filterFindByG_C_S

      List<CommercePriceList> filterFindByG_C_S(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_S

      List<CommercePriceList> filterFindByG_C_S(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • findByG_C_S

      List<CommercePriceList> findByG_C_S(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status = ?, optionally using the finder cache.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • removeByG_C_S

      void removeByG_C_S(long groupId, long companyId, int status)
      Removes all the commerce price lists where groupId = ? and companyId = ? and status = ? from the database.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
    • countByG_C_S

      int countByG_C_S(long groupId, long companyId, int status)
      Returns the number of commerce price lists where groupId = ? and companyId = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      Returns:
      the number of matching commerce price lists
    • countByG_C_S

      int countByG_C_S(long[] groupIds, long companyId, int status)
      Returns the number of commerce price lists where groupId = any ? and companyId = ? and status = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      Returns:
      the number of matching commerce price lists
    • filterCountByG_C_S

      int filterCountByG_C_S(long groupId, long companyId, int status)
      Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • filterCountByG_C_S

      int filterCountByG_C_S(long[] groupIds, long companyId, int status)
      Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • findByG_C_NotS

      List<CommercePriceList> findByG_C_NotS(long groupId, long companyId, int status)
      Returns all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      Returns:
      the matching commerce price lists
    • findByG_C_NotS

      List<CommercePriceList> findByG_C_NotS(long groupId, long companyId, int status, int start, int end)
      Returns a range of all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C_NotS

      List<CommercePriceList> findByG_C_NotS(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_NotS

      List<CommercePriceList> findByG_C_NotS(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_NotS_First

      CommercePriceList findByG_C_NotS_First(long groupId, long companyId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByG_C_NotS_First

      CommercePriceList fetchByG_C_NotS_First(long groupId, long companyId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • filterFindByG_C_NotS

      List<CommercePriceList> filterFindByG_C_NotS(long groupId, long companyId, int status)
      Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C_NotS

      List<CommercePriceList> filterFindByG_C_NotS(long groupId, long companyId, int status, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_NotS

      List<CommercePriceList> filterFindByG_C_NotS(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_NotS

      List<CommercePriceList> filterFindByG_C_NotS(long[] groupIds, long companyId, int status)
      Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status ≠ ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C_NotS

      List<CommercePriceList> filterFindByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_NotS

      List<CommercePriceList> filterFindByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • findByG_C_NotS

      List<CommercePriceList> findByG_C_NotS(long[] groupIds, long companyId, int status)
      Returns all the commerce price lists where groupId = any ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      Returns:
      the matching commerce price lists
    • findByG_C_NotS

      List<CommercePriceList> findByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end)
      Returns a range of all the commerce price lists where groupId = any ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C_NotS

      List<CommercePriceList> findByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_NotS

      List<CommercePriceList> findByG_C_NotS(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status ≠ ?, optionally using the finder cache.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • removeByG_C_NotS

      void removeByG_C_NotS(long groupId, long companyId, int status)
      Removes all the commerce price lists where groupId = ? and companyId = ? and status ≠ ? from the database.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
    • countByG_C_NotS

      int countByG_C_NotS(long groupId, long companyId, int status)
      Returns the number of commerce price lists where groupId = ? and companyId = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      Returns:
      the number of matching commerce price lists
    • countByG_C_NotS

      int countByG_C_NotS(long[] groupIds, long companyId, int status)
      Returns the number of commerce price lists where groupId = any ? and companyId = ? and status ≠ ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      Returns:
      the number of matching commerce price lists
    • filterCountByG_C_NotS

      int filterCountByG_C_NotS(long groupId, long companyId, int status)
      Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • filterCountByG_C_NotS

      int filterCountByG_C_NotS(long[] groupIds, long companyId, int status)
      Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status ≠ ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • findByG_CBPL_T

      List<CommercePriceList> findByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByG_CBPL_T_First

      CommercePriceList findByG_CBPL_T_First(long groupId, boolean catalogBasePriceList, String type, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where groupId = ? and catalogBasePriceList = ? and type = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByG_CBPL_T_First

      CommercePriceList fetchByG_CBPL_T_First(long groupId, boolean catalogBasePriceList, String type, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where groupId = ? and catalogBasePriceList = ? and type = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • filterFindByG_CBPL_T

      List<CommercePriceList> filterFindByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and catalogBasePriceList = ? and type = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • removeByG_CBPL_T

      void removeByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
      Removes all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ? from the database.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
    • countByG_CBPL_T

      int countByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
      Returns the number of commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      Returns:
      the number of matching commerce price lists
    • filterCountByG_CBPL_T

      int filterCountByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
      Returns the number of commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ? and type = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • findByG_C_T_S

      List<CommercePriceList> findByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_T_S_First

      CommercePriceList findByG_C_T_S_First(long groupId, long companyId, String type, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByG_C_T_S_First

      CommercePriceList fetchByG_C_T_S_First(long groupId, long companyId, String type, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • filterFindByG_C_T_S

      List<CommercePriceList> filterFindByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ? and type = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_T_S

      List<CommercePriceList> filterFindByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • findByG_C_T_S

      List<CommercePriceList> findByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?, optionally using the finder cache.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • removeByG_C_T_S

      void removeByG_C_T_S(long groupId, long companyId, String type, int status)
      Removes all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ? from the database.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
    • countByG_C_T_S

      int countByG_C_T_S(long groupId, long companyId, String type, int status)
      Returns the number of commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the number of matching commerce price lists
    • countByG_C_T_S

      int countByG_C_T_S(long[] groupIds, long companyId, String type, int status)
      Returns the number of commerce price lists where groupId = any ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the number of matching commerce price lists
    • filterCountByG_C_T_S

      int filterCountByG_C_T_S(long groupId, long companyId, String type, int status)
      Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • filterCountByG_C_T_S

      int filterCountByG_C_T_S(long[] groupIds, long companyId, String type, int status)
      Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • findByG_C_T_NotS

      List<CommercePriceList> findByG_C_T_NotS(long groupId, long companyId, String type, int status)
      Returns all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the matching commerce price lists
    • findByG_C_T_NotS

      List<CommercePriceList> findByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end)
      Returns a range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C_T_NotS

      List<CommercePriceList> findByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_T_NotS

      List<CommercePriceList> findByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_T_NotS_First

      CommercePriceList findByG_C_T_NotS_First(long groupId, long companyId, String type, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator) throws NoSuchPriceListException
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and type = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByG_C_T_NotS_First

      CommercePriceList fetchByG_C_T_NotS_First(long groupId, long companyId, String type, int status, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns the first commerce price list in the ordered set where groupId = ? and companyId = ? and type = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce price list, or null if a matching commerce price list could not be found
    • filterFindByG_C_T_NotS

      List<CommercePriceList> filterFindByG_C_T_NotS(long groupId, long companyId, String type, int status)
      Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C_T_NotS

      List<CommercePriceList> filterFindByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_T_NotS

      List<CommercePriceList> filterFindByG_C_T_NotS(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permissions to view where groupId = ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_T_NotS

      List<CommercePriceList> filterFindByG_C_T_NotS(long[] groupIds, long companyId, String type, int status)
      Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C_T_NotS

      List<CommercePriceList> filterFindByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_T_NotS

      List<CommercePriceList> filterFindByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists that the user has permission to view
    • findByG_C_T_NotS

      List<CommercePriceList> findByG_C_T_NotS(long[] groupIds, long companyId, String type, int status)
      Returns all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the matching commerce price lists
    • findByG_C_T_NotS

      List<CommercePriceList> findByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end)
      Returns a range of all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C_T_NotS

      List<CommercePriceList> findByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status ≠ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_T_NotS

      List<CommercePriceList> findByG_C_T_NotS(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?, optionally using the finder cache.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce price lists
    • removeByG_C_T_NotS

      void removeByG_C_T_NotS(long groupId, long companyId, String type, int status)
      Removes all the commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ? from the database.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
    • countByG_C_T_NotS

      int countByG_C_T_NotS(long groupId, long companyId, String type, int status)
      Returns the number of commerce price lists where groupId = ? and companyId = ? and type = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the number of matching commerce price lists
    • countByG_C_T_NotS

      int countByG_C_T_NotS(long[] groupIds, long companyId, String type, int status)
      Returns the number of commerce price lists where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the number of matching commerce price lists
    • filterCountByG_C_T_NotS

      int filterCountByG_C_T_NotS(long groupId, long companyId, String type, int status)
      Returns the number of commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status ≠ ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • filterCountByG_C_T_NotS

      int filterCountByG_C_T_NotS(long[] groupIds, long companyId, String type, int status)
      Returns the number of commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status ≠ ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the number of matching commerce price lists that the user has permission to view
    • findByERC_C

      CommercePriceList findByERC_C(String externalReferenceCode, long companyId) throws NoSuchPriceListException
      Returns the commerce price list where externalReferenceCode = ? and companyId = ? or throws a NoSuchPriceListException if it could not be found.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      Returns:
      the matching commerce price list
      Throws:
      NoSuchPriceListException - if a matching commerce price list could not be found
    • fetchByERC_C

      CommercePriceList fetchByERC_C(String externalReferenceCode, long companyId, boolean useFinderCache)
      Returns the commerce price list where externalReferenceCode = ? and companyId = ? or returns null if it could not be found, optionally using the finder cache.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      useFinderCache - whether to use the finder cache
      Returns:
      the matching commerce price list, or null if a matching commerce price list could not be found
    • removeByERC_C

      CommercePriceList removeByERC_C(String externalReferenceCode, long companyId) throws NoSuchPriceListException
      Removes the commerce price list where externalReferenceCode = ? and companyId = ? from the database.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      Returns:
      the commerce price list that was removed
      Throws:
      NoSuchPriceListException
    • countByERC_C

      int countByERC_C(String externalReferenceCode, long companyId)
      Returns the number of commerce price lists where externalReferenceCode = ? and companyId = ?.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      Returns:
      the number of matching commerce price lists
    • create

      CommercePriceList create(long commercePriceListId)
      Creates a new commerce price list with the primary key. Does not add the commerce price list to the database.
      Parameters:
      commercePriceListId - the primary key for the new commerce price list
      Returns:
      the new commerce price list
    • remove

      CommercePriceList remove(long commercePriceListId) throws NoSuchPriceListException
      Removes the commerce price list with the primary key from the database. Also notifies the appropriate model listeners.
      Parameters:
      commercePriceListId - the primary key of the commerce price list
      Returns:
      the commerce price list that was removed
      Throws:
      NoSuchPriceListException - if a commerce price list with the primary key could not be found
    • updateImpl

      CommercePriceList updateImpl(CommercePriceList commercePriceList)
    • findByPrimaryKey

      CommercePriceList findByPrimaryKey(long commercePriceListId) throws NoSuchPriceListException
      Returns the commerce price list with the primary key or throws a NoSuchPriceListException if it could not be found.
      Parameters:
      commercePriceListId - the primary key of the commerce price list
      Returns:
      the commerce price list
      Throws:
      NoSuchPriceListException - if a commerce price list with the primary key could not be found
    • fetchByPrimaryKey

      CommercePriceList fetchByPrimaryKey(long commercePriceListId)
      Returns the commerce price list with the primary key or returns null if it could not be found.
      Parameters:
      commercePriceListId - the primary key of the commerce price list
      Returns:
      the commerce price list, or null if a commerce price list with the primary key could not be found
    • fetchByUUID_G

      default CommercePriceList fetchByUUID_G(String uuid, long groupId)
      Returns the commerce price list where uuid = ? and groupId = ? or returns null if it could not be found. Uses the finder cache.
      Parameters:
      uuid - the uuid
      groupId - the group ID
      Returns:
      the matching commerce price list, or null if a matching commerce price list could not be found
    • fetchByERC_C

      default CommercePriceList fetchByERC_C(String externalReferenceCode, long companyId)
      Returns the commerce price list where externalReferenceCode = ? and companyId = ? or returns null if it could not be found. Uses the finder cache.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      Returns:
      the matching commerce price list, or null if a matching commerce price list could not be found
    • findByUuid

      default List<CommercePriceList> findByUuid(String uuid)
      Returns all the commerce price lists where uuid = ?.
      Parameters:
      uuid - the uuid
      Returns:
      the matching commerce price lists
    • findByUuid

      default List<CommercePriceList> findByUuid(String uuid, int start, int end)
      Returns a range of all the commerce price lists where uuid = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      uuid - the uuid
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByUuid

      default List<CommercePriceList> findByUuid(String uuid, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where uuid = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      uuid - the uuid
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByUuid_C

      default List<CommercePriceList> findByUuid_C(String uuid, long companyId)
      Returns all the commerce price lists where uuid = ? and companyId = ?.
      Parameters:
      uuid - the uuid
      companyId - the company ID
      Returns:
      the matching commerce price lists
    • findByUuid_C

      default List<CommercePriceList> findByUuid_C(String uuid, long companyId, int start, int end)
      Returns a range of all the commerce price lists where uuid = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      uuid - the uuid
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByUuid_C

      default List<CommercePriceList> findByUuid_C(String uuid, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where uuid = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      uuid - the uuid
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByCompanyId

      default List<CommercePriceList> findByCompanyId(long companyId)
      Returns all the commerce price lists where companyId = ?.
      Parameters:
      companyId - the company ID
      Returns:
      the matching commerce price lists
    • findByCompanyId

      default List<CommercePriceList> findByCompanyId(long companyId, int start, int end)
      Returns a range of all the commerce price lists where companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByCompanyId

      default List<CommercePriceList> findByCompanyId(long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByParentCommercePriceListId

      default List<CommercePriceList> findByParentCommercePriceListId(long parentCommercePriceListId)
      Returns all the commerce price lists where parentCommercePriceListId = ?.
      Parameters:
      parentCommercePriceListId - the parent commerce price list ID
      Returns:
      the matching commerce price lists
    • findByParentCommercePriceListId

      default List<CommercePriceList> findByParentCommercePriceListId(long parentCommercePriceListId, int start, int end)
      Returns a range of all the commerce price lists where parentCommercePriceListId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      parentCommercePriceListId - the parent commerce price list ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByParentCommercePriceListId

      default List<CommercePriceList> findByParentCommercePriceListId(long parentCommercePriceListId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where parentCommercePriceListId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      parentCommercePriceListId - the parent commerce price list ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C

      default List<CommercePriceList> findByG_C(long groupId, long companyId)
      Returns all the commerce price lists where groupId = ? and companyId = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      Returns:
      the matching commerce price lists
    • findByG_C

      default List<CommercePriceList> findByG_C(long groupId, long companyId, int start, int end)
      Returns a range of all the commerce price lists where groupId = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C

      default List<CommercePriceList> findByG_C(long groupId, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C

      default List<CommercePriceList> findByG_C(long[] groupIds, long companyId)
      Returns all the commerce price lists where groupId = any ? and companyId = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      Returns:
      the matching commerce price lists
    • findByG_C

      default List<CommercePriceList> findByG_C(long[] groupIds, long companyId, int start, int end)
      Returns a range of all the commerce price lists where groupId = any ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C

      default List<CommercePriceList> findByG_C(long[] groupIds, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • filterFindByG_C

      default List<CommercePriceList> filterFindByG_C(long groupId, long companyId)
      Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C

      default List<CommercePriceList> filterFindByG_C(long groupId, long companyId, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • filterFindByG_C

      default List<CommercePriceList> filterFindByG_C(long[] groupIds, long companyId)
      Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C

      default List<CommercePriceList> filterFindByG_C(long[] groupIds, long companyId, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • findByG_CBPL

      default List<CommercePriceList> findByG_CBPL(long groupId, boolean catalogBasePriceList)
      Returns all the commerce price lists where groupId = ? and catalogBasePriceList = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      Returns:
      the matching commerce price lists
    • findByG_CBPL

      default List<CommercePriceList> findByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end)
      Returns a range of all the commerce price lists where groupId = ? and catalogBasePriceList = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_CBPL

      default List<CommercePriceList> findByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = ? and catalogBasePriceList = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • filterFindByG_CBPL

      default List<CommercePriceList> filterFindByG_CBPL(long groupId, boolean catalogBasePriceList)
      Returns all the commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_CBPL

      default List<CommercePriceList> filterFindByG_CBPL(long groupId, boolean catalogBasePriceList, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • findByC_C

      default List<CommercePriceList> findByC_C(long companyId, String commerceCurrencyCode)
      Returns all the commerce price lists where companyId = ? and commerceCurrencyCode = ?.
      Parameters:
      companyId - the company ID
      commerceCurrencyCode - the commerce currency code
      Returns:
      the matching commerce price lists
    • findByC_C

      default List<CommercePriceList> findByC_C(long companyId, String commerceCurrencyCode, int start, int end)
      Returns a range of all the commerce price lists where companyId = ? and commerceCurrencyCode = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      companyId - the company ID
      commerceCurrencyCode - the commerce currency code
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByC_C

      default List<CommercePriceList> findByC_C(long companyId, String commerceCurrencyCode, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where companyId = ? and commerceCurrencyCode = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      companyId - the company ID
      commerceCurrencyCode - the commerce currency code
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_S

      default List<CommercePriceList> findByG_C_S(long groupId, long companyId, int status)
      Returns all the commerce price lists where groupId = ? and companyId = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      Returns:
      the matching commerce price lists
    • findByG_C_S

      default List<CommercePriceList> findByG_C_S(long groupId, long companyId, int status, int start, int end)
      Returns a range of all the commerce price lists where groupId = ? and companyId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C_S

      default List<CommercePriceList> findByG_C_S(long groupId, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_S

      default List<CommercePriceList> findByG_C_S(long[] groupIds, long companyId, int status)
      Returns all the commerce price lists where groupId = any ? and companyId = ? and status = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      Returns:
      the matching commerce price lists
    • findByG_C_S

      default List<CommercePriceList> findByG_C_S(long[] groupIds, long companyId, int status, int start, int end)
      Returns a range of all the commerce price lists where groupId = any ? and companyId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C_S

      default List<CommercePriceList> findByG_C_S(long[] groupIds, long companyId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • filterFindByG_C_S

      default List<CommercePriceList> filterFindByG_C_S(long groupId, long companyId, int status)
      Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C_S

      default List<CommercePriceList> filterFindByG_C_S(long groupId, long companyId, int status, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_S

      default List<CommercePriceList> filterFindByG_C_S(long[] groupIds, long companyId, int status)
      Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C_S

      default List<CommercePriceList> filterFindByG_C_S(long[] groupIds, long companyId, int status, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • findByG_CBPL_T

      default List<CommercePriceList> findByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
      Returns all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      Returns:
      the matching commerce price lists
    • findByG_CBPL_T

      default List<CommercePriceList> findByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end)
      Returns a range of all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_CBPL_T

      default List<CommercePriceList> findByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = ? and catalogBasePriceList = ? and type = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • filterFindByG_CBPL_T

      default List<CommercePriceList> filterFindByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type)
      Returns all the commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ? and type = ?.
      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_CBPL_T

      default List<CommercePriceList> filterFindByG_CBPL_T(long groupId, boolean catalogBasePriceList, String type, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and catalogBasePriceList = ? and type = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      catalogBasePriceList - the catalog base price list
      type - the type
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • findByG_C_T_S

      default List<CommercePriceList> findByG_C_T_S(long groupId, long companyId, String type, int status)
      Returns all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the matching commerce price lists
    • findByG_C_T_S

      default List<CommercePriceList> findByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end)
      Returns a range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C_T_S

      default List<CommercePriceList> findByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = ? and companyId = ? and type = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • findByG_C_T_S

      default List<CommercePriceList> findByG_C_T_S(long[] groupIds, long companyId, String type, int status)
      Returns all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the matching commerce price lists
    • findByG_C_T_S

      default List<CommercePriceList> findByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end)
      Returns a range of all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists
    • findByG_C_T_S

      default List<CommercePriceList> findByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommercePriceList> orderByComparator)
      Returns an ordered range of all the commerce price lists where groupId = any ? and companyId = ? and type = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce price lists
    • filterFindByG_C_T_S

      default List<CommercePriceList> filterFindByG_C_T_S(long groupId, long companyId, String type, int status)
      Returns all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C_T_S

      default List<CommercePriceList> filterFindByG_C_T_S(long groupId, long companyId, String type, int status, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = ? and companyId = ? and type = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupId - the group ID
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view
    • filterFindByG_C_T_S

      default List<CommercePriceList> filterFindByG_C_T_S(long[] groupIds, long companyId, String type, int status)
      Returns all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status = ?.
      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      Returns:
      the matching commerce price lists that the user has permission to view
    • filterFindByG_C_T_S

      default List<CommercePriceList> filterFindByG_C_T_S(long[] groupIds, long companyId, String type, int status, int start, int end)
      Returns a range of all the commerce price lists that the user has permission to view where groupId = any ? and companyId = ? and type = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommercePriceListModelImpl.

      Parameters:
      groupIds - the group IDs
      companyId - the company ID
      type - the type
      status - the status
      start - the lower bound of the range of commerce price lists
      end - the upper bound of the range of commerce price lists (not inclusive)
      Returns:
      the range of matching commerce price lists that the user has permission to view