MBCategoryUtil

java.lang.Object
- com.liferay.message.boards.kernel.service.persistence.MBCategoryUtil

```
@ProviderType
public class MBCategoryUtil
extends java.lang.Object
```
The persistence utility for the message boards category service. This utility wraps MBCategoryPersistenceImpl and provides direct access to the database for CRUD operations. This utility should only be used by the service layer, as it must operate within a transaction. Never access this utility in a JSP, controller, model, or other front-end class.
Caching information and settings can be found in portal.properties

Author:

Brian Wing Shun Chan

See Also:

MBCategoryPersistence, MBCategoryPersistenceImpl

Generated:

Constructor Summary

Constructors
Constructor and Description

MBCategoryUtil()

Constructors
Constructor and Description
`MBCategoryUtil()`

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static void`	`cacheResult(java.util.List<MBCategory> mbCategories)` Caches the message boards categories in the entity cache if it is enabled.
`static void`	`cacheResult(MBCategory mbCategory)` Caches the message boards category in the entity cache if it is enabled.
`static void`	`clearCache()`
`static void`	`clearCache(MBCategory mbCategory)`
`static int`	`countAll()` Returns the number of message boards categories.
`static int`	`countByC_S(long companyId, int status)` Returns the number of message boards categories where companyId = ? and status = ?.
`static int`	`countByCompanyId(long companyId)` Returns the number of message boards categories where companyId = ?.
`static int`	`countByG_P_S(long groupId, long[] parentCategoryIds, int status)` Returns the number of message boards categories where groupId = ? and parentCategoryId = any ? and status = ?.
`static int`	`countByG_P_S(long groupId, long parentCategoryId, int status)` Returns the number of message boards categories where groupId = ? and parentCategoryId = ? and status = ?.
`static int`	`countByG_P(long groupId, long parentCategoryId)` Returns the number of message boards categories where groupId = ? and parentCategoryId = ?.
`static int`	`countByG_P(long groupId, long[] parentCategoryIds)` Returns the number of message boards categories where groupId = ? and parentCategoryId = any ?.
`static int`	`countByG_S(long groupId, int status)` Returns the number of message boards categories where groupId = ? and status = ?.
`static int`	`countByGroupId(long groupId)` Returns the number of message boards categories where groupId = ?.
`static int`	`countByNotC_G_P_S(long[] categoryIds, long groupId, long[] parentCategoryIds, int status)` Returns the number of message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
`static int`	`countByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status)` Returns the number of message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static int`	`countByNotC_G_P(long[] categoryIds, long groupId, long[] parentCategoryIds)` Returns the number of message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
`static int`	`countByNotC_G_P(long categoryId, long groupId, long parentCategoryId)` Returns the number of message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static int`	`countByUuid_C(java.lang.String uuid, long companyId)` Returns the number of message boards categories where uuid = ? and companyId = ?.
`static int`	`countByUUID_G(java.lang.String uuid, long groupId)` Returns the number of message boards categories where uuid = ? and groupId = ?.
`static int`	`countByUuid(java.lang.String uuid)` Returns the number of message boards categories where uuid = ?.
`static long`	`countWithDynamicQuery(DynamicQuery dynamicQuery)`
`static MBCategory`	`create(long categoryId)` Creates a new message boards category with the primary key.
`static MBCategory`	`fetchByC_S_First(long companyId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where companyId = ? and status = ?.
`static MBCategory`	`fetchByC_S_Last(long companyId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where companyId = ? and status = ?.
`static MBCategory`	`fetchByCompanyId_First(long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where companyId = ?.
`static MBCategory`	`fetchByCompanyId_Last(long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where companyId = ?.
`static MBCategory`	`fetchByG_P_First(long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
`static MBCategory`	`fetchByG_P_Last(long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
`static MBCategory`	`fetchByG_P_S_First(long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
`static MBCategory`	`fetchByG_P_S_Last(long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
`static MBCategory`	`fetchByG_S_First(long groupId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where groupId = ? and status = ?.
`static MBCategory`	`fetchByG_S_Last(long groupId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where groupId = ? and status = ?.
`static MBCategory`	`fetchByGroupId_First(long groupId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where groupId = ?.
`static MBCategory`	`fetchByGroupId_Last(long groupId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where groupId = ?.
`static MBCategory`	`fetchByNotC_G_P_First(long categoryId, long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static MBCategory`	`fetchByNotC_G_P_Last(long categoryId, long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static MBCategory`	`fetchByNotC_G_P_S_First(long categoryId, long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static MBCategory`	`fetchByNotC_G_P_S_Last(long categoryId, long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static MBCategory`	`fetchByPrimaryKey(long categoryId)` Returns the message boards category with the primary key or returns `null` if it could not be found.
`static java.util.Map<java.io.Serializable,MBCategory>`	`fetchByPrimaryKeys(java.util.Set<java.io.Serializable> primaryKeys)`
`static MBCategory`	`fetchByUuid_C_First(java.lang.String uuid, long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where uuid = ? and companyId = ?.
`static MBCategory`	`fetchByUuid_C_Last(java.lang.String uuid, long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where uuid = ? and companyId = ?.
`static MBCategory`	`fetchByUuid_First(java.lang.String uuid, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where uuid = ?.
`static MBCategory`	`fetchByUUID_G(java.lang.String uuid, long groupId)` Returns the message boards category where uuid = ? and groupId = ? or returns `null` if it could not be found.
`static MBCategory`	`fetchByUUID_G(java.lang.String uuid, long groupId, boolean retrieveFromCache)` Returns the message boards category where uuid = ? and groupId = ? or returns `null` if it could not be found, optionally using the finder cache.
`static MBCategory`	`fetchByUuid_Last(java.lang.String uuid, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where uuid = ?.
`static int`	`filterCountByG_P_S(long groupId, long[] parentCategoryIds, int status)` Returns the number of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ? and status = ?.
`static int`	`filterCountByG_P_S(long groupId, long parentCategoryId, int status)` Returns the number of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ? and status = ?.
`static int`	`filterCountByG_P(long groupId, long parentCategoryId)` Returns the number of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ?.
`static int`	`filterCountByG_P(long groupId, long[] parentCategoryIds)` Returns the number of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ?.
`static int`	`filterCountByG_S(long groupId, int status)` Returns the number of message boards categories that the user has permission to view where groupId = ? and status = ?.
`static int`	`filterCountByGroupId(long groupId)` Returns the number of message boards categories that the user has permission to view where groupId = ?.
`static int`	`filterCountByNotC_G_P_S(long[] categoryIds, long groupId, long[] parentCategoryIds, int status)` Returns the number of message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
`static int`	`filterCountByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status)` Returns the number of message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static int`	`filterCountByNotC_G_P(long[] categoryIds, long groupId, long[] parentCategoryIds)` Returns the number of message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
`static int`	`filterCountByNotC_G_P(long categoryId, long groupId, long parentCategoryId)` Returns the number of message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static MBCategory[]`	`filterFindByG_P_PrevAndNext(long categoryId, long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ?.
`static MBCategory[]`	`filterFindByG_P_S_PrevAndNext(long categoryId, long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_P_S(long groupId, long[] parentCategoryIds, int status)` Returns all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_P_S(long groupId, long[] parentCategoryIds, int status, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_P_S(long groupId, long[] parentCategoryIds, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_P_S(long groupId, long parentCategoryId, int status)` Returns all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_P_S(long groupId, long parentCategoryId, int status, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_P_S(long groupId, long parentCategoryId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_P(long groupId, long parentCategoryId)` Returns all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`filterFindByG_P(long groupId, long[] parentCategoryIds)` Returns all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`filterFindByG_P(long groupId, long[] parentCategoryIds, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`filterFindByG_P(long groupId, long[] parentCategoryIds, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`filterFindByG_P(long groupId, long parentCategoryId, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`filterFindByG_P(long groupId, long parentCategoryId, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = ? and parentCategoryId = ?.
`static MBCategory[]`	`filterFindByG_S_PrevAndNext(long categoryId, long groupId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set of message boards categories that the user has permission to view where groupId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_S(long groupId, int status)` Returns all the message boards categories that the user has permission to view where groupId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_S(long groupId, int status, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where groupId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByG_S(long groupId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = ? and status = ?.
`static MBCategory[]`	`filterFindByGroupId_PrevAndNext(long categoryId, long groupId, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set of message boards categories that the user has permission to view where groupId = ?.
`static java.util.List<MBCategory>`	`filterFindByGroupId(long groupId)` Returns all the message boards categories that the user has permission to view where groupId = ?.
`static java.util.List<MBCategory>`	`filterFindByGroupId(long groupId, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where groupId = ?.
`static java.util.List<MBCategory>`	`filterFindByGroupId(long groupId, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P_S(long[] categoryIds, long groupId, long[] parentCategoryIds, int status)` Returns all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P_S(long[] categoryIds, long groupId, long[] parentCategoryIds, int status, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P_S(long[] categoryIds, long groupId, long[] parentCategoryIds, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status)` Returns all the message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permissions to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P(long[] categoryIds, long groupId, long[] parentCategoryIds)` Returns all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P(long[] categoryIds, long groupId, long[] parentCategoryIds, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P(long[] categoryIds, long groupId, long[] parentCategoryIds, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P(long categoryId, long groupId, long parentCategoryId)` Returns all the message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P(long categoryId, long groupId, long parentCategoryId, int start, int end)` Returns a range of all the message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`filterFindByNotC_G_P(long categoryId, long groupId, long parentCategoryId, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories that the user has permissions to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`findAll()` Returns all the message boards categories.
`static java.util.List<MBCategory>`	`findAll(int start, int end)` Returns a range of all the message boards categories.
`static java.util.List<MBCategory>`	`findAll(int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories.
`static java.util.List<MBCategory>`	`findAll(int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories.
`static MBCategory`	`findByC_S_First(long companyId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where companyId = ? and status = ?.
`static MBCategory`	`findByC_S_Last(long companyId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where companyId = ? and status = ?.
`static MBCategory[]`	`findByC_S_PrevAndNext(long categoryId, long companyId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set where companyId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByC_S(long companyId, int status)` Returns all the message boards categories where companyId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByC_S(long companyId, int status, int start, int end)` Returns a range of all the message boards categories where companyId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByC_S(long companyId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where companyId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByC_S(long companyId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where companyId = ? and status = ?.
`static MBCategory`	`findByCompanyId_First(long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where companyId = ?.
`static MBCategory`	`findByCompanyId_Last(long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where companyId = ?.
`static MBCategory[]`	`findByCompanyId_PrevAndNext(long categoryId, long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set where companyId = ?.
`static java.util.List<MBCategory>`	`findByCompanyId(long companyId)` Returns all the message boards categories where companyId = ?.
`static java.util.List<MBCategory>`	`findByCompanyId(long companyId, int start, int end)` Returns a range of all the message boards categories where companyId = ?.
`static java.util.List<MBCategory>`	`findByCompanyId(long companyId, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where companyId = ?.
`static java.util.List<MBCategory>`	`findByCompanyId(long companyId, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where companyId = ?.
`static MBCategory`	`findByG_P_First(long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
`static MBCategory`	`findByG_P_Last(long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
`static MBCategory[]`	`findByG_P_PrevAndNext(long categoryId, long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
`static MBCategory`	`findByG_P_S_First(long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
`static MBCategory`	`findByG_P_S_Last(long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
`static MBCategory[]`	`findByG_P_S_PrevAndNext(long categoryId, long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_P_S(long groupId, long[] parentCategoryIds, int status)` Returns all the message boards categories where groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_P_S(long groupId, long[] parentCategoryIds, int status, int start, int end)` Returns a range of all the message boards categories where groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_P_S(long groupId, long[] parentCategoryIds, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_P_S(long groupId, long[] parentCategoryIds, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ? and status = ?, optionally using the finder cache.
`static java.util.List<MBCategory>`	`findByG_P_S(long groupId, long parentCategoryId, int status)` Returns all the message boards categories where groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_P_S(long groupId, long parentCategoryId, int status, int start, int end)` Returns a range of all the message boards categories where groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_P_S(long groupId, long parentCategoryId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_P_S(long groupId, long parentCategoryId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_P(long groupId, long parentCategoryId)` Returns all the message boards categories where groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`findByG_P(long groupId, long[] parentCategoryIds)` Returns all the message boards categories where groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`findByG_P(long groupId, long[] parentCategoryIds, int start, int end)` Returns a range of all the message boards categories where groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`findByG_P(long groupId, long[] parentCategoryIds, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`findByG_P(long groupId, long[] parentCategoryIds, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ?, optionally using the finder cache.
`static java.util.List<MBCategory>`	`findByG_P(long groupId, long parentCategoryId, int start, int end)` Returns a range of all the message boards categories where groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`findByG_P(long groupId, long parentCategoryId, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`findByG_P(long groupId, long parentCategoryId, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ?.
`static MBCategory`	`findByG_S_First(long groupId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where groupId = ? and status = ?.
`static MBCategory`	`findByG_S_Last(long groupId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where groupId = ? and status = ?.
`static MBCategory[]`	`findByG_S_PrevAndNext(long categoryId, long groupId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set where groupId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_S(long groupId, int status)` Returns all the message boards categories where groupId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_S(long groupId, int status, int start, int end)` Returns a range of all the message boards categories where groupId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_S(long groupId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where groupId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByG_S(long groupId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where groupId = ? and status = ?.
`static MBCategory`	`findByGroupId_First(long groupId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where groupId = ?.
`static MBCategory`	`findByGroupId_Last(long groupId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where groupId = ?.
`static MBCategory[]`	`findByGroupId_PrevAndNext(long categoryId, long groupId, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set where groupId = ?.
`static java.util.List<MBCategory>`	`findByGroupId(long groupId)` Returns all the message boards categories where groupId = ?.
`static java.util.List<MBCategory>`	`findByGroupId(long groupId, int start, int end)` Returns a range of all the message boards categories where groupId = ?.
`static java.util.List<MBCategory>`	`findByGroupId(long groupId, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where groupId = ?.
`static java.util.List<MBCategory>`	`findByGroupId(long groupId, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where groupId = ?.
`static MBCategory`	`findByNotC_G_P_First(long categoryId, long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static MBCategory`	`findByNotC_G_P_Last(long categoryId, long groupId, long parentCategoryId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static MBCategory`	`findByNotC_G_P_S_First(long categoryId, long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static MBCategory`	`findByNotC_G_P_S_Last(long categoryId, long groupId, long parentCategoryId, int status, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P_S(long[] categoryIds, long groupId, long[] parentCategoryIds, int status)` Returns all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P_S(long[] categoryIds, long groupId, long[] parentCategoryIds, int status, int start, int end)` Returns a range of all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P_S(long[] categoryIds, long groupId, long[] parentCategoryIds, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P_S(long[] categoryIds, long groupId, long[] parentCategoryIds, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?, optionally using the finder cache.
`static java.util.List<MBCategory>`	`findByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status)` Returns all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status, int start, int end)` Returns a range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P(long[] categoryIds, long groupId, long[] parentCategoryIds)` Returns all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P(long[] categoryIds, long groupId, long[] parentCategoryIds, int start, int end)` Returns a range of all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P(long[] categoryIds, long groupId, long[] parentCategoryIds, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P(long[] categoryIds, long groupId, long[] parentCategoryIds, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?, optionally using the finder cache.
`static java.util.List<MBCategory>`	`findByNotC_G_P(long categoryId, long groupId, long parentCategoryId)` Returns all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P(long categoryId, long groupId, long parentCategoryId, int start, int end)` Returns a range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P(long categoryId, long groupId, long parentCategoryId, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static java.util.List<MBCategory>`	`findByNotC_G_P(long categoryId, long groupId, long parentCategoryId, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
`static MBCategory`	`findByPrimaryKey(long categoryId)` Returns the message boards category with the primary key or throws a `NoSuchCategoryException` if it could not be found.
`static MBCategory`	`findByUuid_C_First(java.lang.String uuid, long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where uuid = ? and companyId = ?.
`static MBCategory`	`findByUuid_C_Last(java.lang.String uuid, long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where uuid = ? and companyId = ?.
`static MBCategory[]`	`findByUuid_C_PrevAndNext(long categoryId, java.lang.String uuid, long companyId, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set where uuid = ? and companyId = ?.
`static java.util.List<MBCategory>`	`findByUuid_C(java.lang.String uuid, long companyId)` Returns all the message boards categories where uuid = ? and companyId = ?.
`static java.util.List<MBCategory>`	`findByUuid_C(java.lang.String uuid, long companyId, int start, int end)` Returns a range of all the message boards categories where uuid = ? and companyId = ?.
`static java.util.List<MBCategory>`	`findByUuid_C(java.lang.String uuid, long companyId, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where uuid = ? and companyId = ?.
`static java.util.List<MBCategory>`	`findByUuid_C(java.lang.String uuid, long companyId, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where uuid = ? and companyId = ?.
`static MBCategory`	`findByUuid_First(java.lang.String uuid, OrderByComparator<MBCategory> orderByComparator)` Returns the first message boards category in the ordered set where uuid = ?.
`static MBCategory`	`findByUUID_G(java.lang.String uuid, long groupId)` Returns the message boards category where uuid = ? and groupId = ? or throws a `NoSuchCategoryException` if it could not be found.
`static MBCategory`	`findByUuid_Last(java.lang.String uuid, OrderByComparator<MBCategory> orderByComparator)` Returns the last message boards category in the ordered set where uuid = ?.
`static MBCategory[]`	`findByUuid_PrevAndNext(long categoryId, java.lang.String uuid, OrderByComparator<MBCategory> orderByComparator)` Returns the message boards categories before and after the current message boards category in the ordered set where uuid = ?.
`static java.util.List<MBCategory>`	`findByUuid(java.lang.String uuid)` Returns all the message boards categories where uuid = ?.
`static java.util.List<MBCategory>`	`findByUuid(java.lang.String uuid, int start, int end)` Returns a range of all the message boards categories where uuid = ?.
`static java.util.List<MBCategory>`	`findByUuid(java.lang.String uuid, int start, int end, OrderByComparator<MBCategory> orderByComparator)` Returns an ordered range of all the message boards categories where uuid = ?.
`static java.util.List<MBCategory>`	`findByUuid(java.lang.String uuid, int start, int end, OrderByComparator<MBCategory> orderByComparator, boolean retrieveFromCache)` Returns an ordered range of all the message boards categories where uuid = ?.
`static java.util.List<MBCategory>`	`findWithDynamicQuery(DynamicQuery dynamicQuery)`
`static java.util.List<MBCategory>`	`findWithDynamicQuery(DynamicQuery dynamicQuery, int start, int end)`
`static java.util.List<MBCategory>`	`findWithDynamicQuery(DynamicQuery dynamicQuery, int start, int end, OrderByComparator<MBCategory> orderByComparator)`
`static java.util.Set<java.lang.String>`	`getBadColumnNames()`
`static MBCategoryPersistence`	`getPersistence()`
`static MBCategory`	`remove(long categoryId)` Removes the message boards category with the primary key from the database.
`static void`	`removeAll()` Removes all the message boards categories from the database.
`static void`	`removeByC_S(long companyId, int status)` Removes all the message boards categories where companyId = ? and status = ? from the database.
`static void`	`removeByCompanyId(long companyId)` Removes all the message boards categories where companyId = ? from the database.
`static void`	`removeByG_P_S(long groupId, long parentCategoryId, int status)` Removes all the message boards categories where groupId = ? and parentCategoryId = ? and status = ? from the database.
`static void`	`removeByG_P(long groupId, long parentCategoryId)` Removes all the message boards categories where groupId = ? and parentCategoryId = ? from the database.
`static void`	`removeByG_S(long groupId, int status)` Removes all the message boards categories where groupId = ? and status = ? from the database.
`static void`	`removeByGroupId(long groupId)` Removes all the message boards categories where groupId = ? from the database.
`static void`	`removeByNotC_G_P_S(long categoryId, long groupId, long parentCategoryId, int status)` Removes all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ? from the database.
`static void`	`removeByNotC_G_P(long categoryId, long groupId, long parentCategoryId)` Removes all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? from the database.
`static void`	`removeByUuid_C(java.lang.String uuid, long companyId)` Removes all the message boards categories where uuid = ? and companyId = ? from the database.
`static MBCategory`	`removeByUUID_G(java.lang.String uuid, long groupId)` Removes the message boards category where uuid = ? and groupId = ? from the database.
`static void`	`removeByUuid(java.lang.String uuid)` Removes all the message boards categories where uuid = ? from the database.
`static MBCategory`	`update(MBCategory mbCategory)`
`static MBCategory`	`update(MBCategory mbCategory, ServiceContext serviceContext)`
`static MBCategory`	`updateImpl(MBCategory mbCategory)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - MBCategoryUtil
```
public MBCategoryUtil()
```
- Method Detail
  - clearCache
```
public static void clearCache()
```
    See Also:
    
    BasePersistence.clearCache()
  - clearCache
```
public static void clearCache(MBCategory mbCategory)
```
    See Also:
    
    BasePersistence.clearCache(com.liferay.portal.kernel.model.BaseModel)
  - countWithDynamicQuery
```
public static long countWithDynamicQuery(DynamicQuery dynamicQuery)
```
    See Also:
    
    BasePersistence.countWithDynamicQuery(DynamicQuery)
  - findWithDynamicQuery
```
public static java.util.List<MBCategory> findWithDynamicQuery(DynamicQuery dynamicQuery)
```
    See Also:
    
    BasePersistence.findWithDynamicQuery(DynamicQuery)
  - findWithDynamicQuery
```
public static java.util.List<MBCategory> findWithDynamicQuery(DynamicQuery dynamicQuery,
                                                              int start,
                                                              int end)
```
    See Also:
    
    BasePersistence.findWithDynamicQuery(DynamicQuery, int, int)
  - findWithDynamicQuery
```
public static java.util.List<MBCategory> findWithDynamicQuery(DynamicQuery dynamicQuery,
                                                              int start,
                                                              int end,
                                                              OrderByComparator<MBCategory> orderByComparator)
```
    See Also:
    
    BasePersistence.findWithDynamicQuery(DynamicQuery, int, int, OrderByComparator)
  - update
```
public static MBCategory update(MBCategory mbCategory)
```
    See Also:
    
    BasePersistence.update(com.liferay.portal.kernel.model.BaseModel)
  - update
```
public static MBCategory update(MBCategory mbCategory,
                                ServiceContext serviceContext)
```
    See Also:
    
    BasePersistence.update(com.liferay.portal.kernel.model.BaseModel, ServiceContext)
  - findByUuid
```
public static java.util.List<MBCategory> findByUuid(java.lang.String uuid)
```
    Returns all the message boards categories where uuid = ?.
    
    Parameters:
    
    uuid - the uuid
    
    Returns:
    
    the matching message boards categories
  - findByUuid
```
public static java.util.List<MBCategory> findByUuid(java.lang.String uuid,
                                                    int start,
                                                    int end)
```
    Returns a range of all the message boards categories 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    uuid - the uuid
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByUuid
```
public static java.util.List<MBCategory> findByUuid(java.lang.String uuid,
                                                    int start,
                                                    int end,
                                                    OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    uuid - the uuid
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByUuid
```
public static java.util.List<MBCategory> findByUuid(java.lang.String uuid,
                                                    int start,
                                                    int end,
                                                    OrderByComparator<MBCategory> orderByComparator,
                                                    boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    uuid - the uuid
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByUuid_First
```
public static MBCategory findByUuid_First(java.lang.String uuid,
                                          OrderByComparator<MBCategory> orderByComparator)
                                   throws NoSuchCategoryException
```
    Returns the first message boards category in the ordered set where uuid = ?.
    
    Parameters:
    
    uuid - the uuid
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByUuid_First
```
public static MBCategory fetchByUuid_First(java.lang.String uuid,
                                           OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category in the ordered set where uuid = ?.
    
    Parameters:
    
    uuid - the uuid
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category, or null if a matching message boards category could not be found
  - findByUuid_Last
```
public static MBCategory findByUuid_Last(java.lang.String uuid,
                                         OrderByComparator<MBCategory> orderByComparator)
                                  throws NoSuchCategoryException
```
    Returns the last message boards category in the ordered set where uuid = ?.
    
    Parameters:
    
    uuid - the uuid
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByUuid_Last
```
public static MBCategory fetchByUuid_Last(java.lang.String uuid,
                                          OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category in the ordered set where uuid = ?.
    
    Parameters:
    
    uuid - the uuid
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category, or null if a matching message boards category could not be found
  - findByUuid_PrevAndNext
```
public static MBCategory[] findByUuid_PrevAndNext(long categoryId,
                                                  java.lang.String uuid,
                                                  OrderByComparator<MBCategory> orderByComparator)
                                           throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set where uuid = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    uuid - the uuid
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - removeByUuid
```
public static void removeByUuid(java.lang.String uuid)
```
    Removes all the message boards categories where uuid = ? from the database.
    
    Parameters:
    
    uuid - the uuid
  - countByUuid
```
public static int countByUuid(java.lang.String uuid)
```
    Returns the number of message boards categories where uuid = ?.
    
    Parameters:
    
    uuid - the uuid
    
    Returns:
    
    the number of matching message boards categories
  - findByUUID_G
```
public static MBCategory findByUUID_G(java.lang.String uuid,
                                      long groupId)
                               throws NoSuchCategoryException
```
    Returns the message boards category where uuid = ? and groupId = ? or throws a NoSuchCategoryException if it could not be found.
    
    Parameters:
    
    uuid - the uuid
    
    groupId - the group ID
    
    Returns:
    
    the matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByUUID_G
```
public static MBCategory fetchByUUID_G(java.lang.String uuid,
                                       long groupId)
```
    Returns the message boards category 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 message boards category, or null if a matching message boards category could not be found
  - fetchByUUID_G
```
public static MBCategory fetchByUUID_G(java.lang.String uuid,
                                       long groupId,
                                       boolean retrieveFromCache)
```
    Returns the message boards category 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
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the matching message boards category, or null if a matching message boards category could not be found
  - removeByUUID_G
```
public static MBCategory removeByUUID_G(java.lang.String uuid,
                                        long groupId)
                                 throws NoSuchCategoryException
```
    Removes the message boards category where uuid = ? and groupId = ? from the database.
    
    Parameters:
    
    uuid - the uuid
    
    groupId - the group ID
    
    Returns:
    
    the message boards category that was removed
    
    Throws:
    
    NoSuchCategoryException
  - countByUUID_G
```
public static int countByUUID_G(java.lang.String uuid,
                                long groupId)
```
    Returns the number of message boards categories where uuid = ? and groupId = ?.
    
    Parameters:
    
    uuid - the uuid
    
    groupId - the group ID
    
    Returns:
    
    the number of matching message boards categories
  - findByUuid_C
```
public static java.util.List<MBCategory> findByUuid_C(java.lang.String uuid,
                                                      long companyId)
```
    Returns all the message boards categories where uuid = ? and companyId = ?.
    
    Parameters:
    
    uuid - the uuid
    
    companyId - the company ID
    
    Returns:
    
    the matching message boards categories
  - findByUuid_C
```
public static java.util.List<MBCategory> findByUuid_C(java.lang.String uuid,
                                                      long companyId,
                                                      int start,
                                                      int end)
```
    Returns a range of all the message boards categories 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    uuid - the uuid
    
    companyId - the company ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByUuid_C
```
public static java.util.List<MBCategory> findByUuid_C(java.lang.String uuid,
                                                      long companyId,
                                                      int start,
                                                      int end,
                                                      OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    uuid - the uuid
    
    companyId - the company ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByUuid_C
```
public static java.util.List<MBCategory> findByUuid_C(java.lang.String uuid,
                                                      long companyId,
                                                      int start,
                                                      int end,
                                                      OrderByComparator<MBCategory> orderByComparator,
                                                      boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    uuid - the uuid
    
    companyId - the company ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByUuid_C_First
```
public static MBCategory findByUuid_C_First(java.lang.String uuid,
                                            long companyId,
                                            OrderByComparator<MBCategory> orderByComparator)
                                     throws NoSuchCategoryException
```
    Returns the first message boards category 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 message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByUuid_C_First
```
public static MBCategory fetchByUuid_C_First(java.lang.String uuid,
                                             long companyId,
                                             OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category 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 message boards category, or null if a matching message boards category could not be found
  - findByUuid_C_Last
```
public static MBCategory findByUuid_C_Last(java.lang.String uuid,
                                           long companyId,
                                           OrderByComparator<MBCategory> orderByComparator)
                                    throws NoSuchCategoryException
```
    Returns the last message boards category 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 last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByUuid_C_Last
```
public static MBCategory fetchByUuid_C_Last(java.lang.String uuid,
                                            long companyId,
                                            OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category 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 last matching message boards category, or null if a matching message boards category could not be found
  - findByUuid_C_PrevAndNext
```
public static MBCategory[] findByUuid_C_PrevAndNext(long categoryId,
                                                    java.lang.String uuid,
                                                    long companyId,
                                                    OrderByComparator<MBCategory> orderByComparator)
                                             throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set where uuid = ? and companyId = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    uuid - the uuid
    
    companyId - the company ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - removeByUuid_C
```
public static void removeByUuid_C(java.lang.String uuid,
                                  long companyId)
```
    Removes all the message boards categories where uuid = ? and companyId = ? from the database.
    
    Parameters:
    
    uuid - the uuid
    
    companyId - the company ID
  - countByUuid_C
```
public static int countByUuid_C(java.lang.String uuid,
                                long companyId)
```
    Returns the number of message boards categories where uuid = ? and companyId = ?.
    
    Parameters:
    
    uuid - the uuid
    
    companyId - the company ID
    
    Returns:
    
    the number of matching message boards categories
  - findByGroupId
```
public static java.util.List<MBCategory> findByGroupId(long groupId)
```
    Returns all the message boards categories where groupId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    Returns:
    
    the matching message boards categories
  - findByGroupId
```
public static java.util.List<MBCategory> findByGroupId(long groupId,
                                                       int start,
                                                       int end)
```
    Returns a range of all the message boards categories where groupId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByGroupId
```
public static java.util.List<MBCategory> findByGroupId(long groupId,
                                                       int start,
                                                       int end,
                                                       OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where groupId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByGroupId
```
public static java.util.List<MBCategory> findByGroupId(long groupId,
                                                       int start,
                                                       int end,
                                                       OrderByComparator<MBCategory> orderByComparator,
                                                       boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where groupId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByGroupId_First
```
public static MBCategory findByGroupId_First(long groupId,
                                             OrderByComparator<MBCategory> orderByComparator)
                                      throws NoSuchCategoryException
```
    Returns the first message boards category in the ordered set where groupId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByGroupId_First
```
public static MBCategory fetchByGroupId_First(long groupId,
                                              OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category in the ordered set where groupId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category, or null if a matching message boards category could not be found
  - findByGroupId_Last
```
public static MBCategory findByGroupId_Last(long groupId,
                                            OrderByComparator<MBCategory> orderByComparator)
                                     throws NoSuchCategoryException
```
    Returns the last message boards category in the ordered set where groupId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByGroupId_Last
```
public static MBCategory fetchByGroupId_Last(long groupId,
                                             OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category in the ordered set where groupId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category, or null if a matching message boards category could not be found
  - findByGroupId_PrevAndNext
```
public static MBCategory[] findByGroupId_PrevAndNext(long categoryId,
                                                     long groupId,
                                                     OrderByComparator<MBCategory> orderByComparator)
                                              throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set where groupId = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    groupId - the group ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - filterFindByGroupId
```
public static java.util.List<MBCategory> filterFindByGroupId(long groupId)
```
    Returns all the message boards categories that the user has permission to view where groupId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByGroupId
```
public static java.util.List<MBCategory> filterFindByGroupId(long groupId,
                                                             int start,
                                                             int end)
```
    Returns a range of all the message boards categories that the user has permission to view where groupId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByGroupId
```
public static java.util.List<MBCategory> filterFindByGroupId(long groupId,
                                                             int start,
                                                             int end,
                                                             OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - filterFindByGroupId_PrevAndNext
```
public static MBCategory[] filterFindByGroupId_PrevAndNext(long categoryId,
                                                           long groupId,
                                                           OrderByComparator<MBCategory> orderByComparator)
                                                    throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set of message boards categories that the user has permission to view where groupId = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    groupId - the group ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - removeByGroupId
```
public static void removeByGroupId(long groupId)
```
    Removes all the message boards categories where groupId = ? from the database.
    
    Parameters:
    
    groupId - the group ID
  - countByGroupId
```
public static int countByGroupId(long groupId)
```
    Returns the number of message boards categories where groupId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    Returns:
    
    the number of matching message boards categories
  - filterCountByGroupId
```
public static int filterCountByGroupId(long groupId)
```
    Returns the number of message boards categories that the user has permission to view where groupId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - findByCompanyId
```
public static java.util.List<MBCategory> findByCompanyId(long companyId)
```
    Returns all the message boards categories where companyId = ?.
    
    Parameters:
    
    companyId - the company ID
    
    Returns:
    
    the matching message boards categories
  - findByCompanyId
```
public static java.util.List<MBCategory> findByCompanyId(long companyId,
                                                         int start,
                                                         int end)
```
    Returns a range of all the message boards categories 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    companyId - the company ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByCompanyId
```
public static java.util.List<MBCategory> findByCompanyId(long companyId,
                                                         int start,
                                                         int end,
                                                         OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    companyId - the company ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByCompanyId
```
public static java.util.List<MBCategory> findByCompanyId(long companyId,
                                                         int start,
                                                         int end,
                                                         OrderByComparator<MBCategory> orderByComparator,
                                                         boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    companyId - the company ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByCompanyId_First
```
public static MBCategory findByCompanyId_First(long companyId,
                                               OrderByComparator<MBCategory> orderByComparator)
                                        throws NoSuchCategoryException
```
    Returns the first message boards category 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 message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByCompanyId_First
```
public static MBCategory fetchByCompanyId_First(long companyId,
                                                OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category 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 message boards category, or null if a matching message boards category could not be found
  - findByCompanyId_Last
```
public static MBCategory findByCompanyId_Last(long companyId,
                                              OrderByComparator<MBCategory> orderByComparator)
                                       throws NoSuchCategoryException
```
    Returns the last message boards category in the ordered set where companyId = ?.
    
    Parameters:
    
    companyId - the company ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByCompanyId_Last
```
public static MBCategory fetchByCompanyId_Last(long companyId,
                                               OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category in the ordered set where companyId = ?.
    
    Parameters:
    
    companyId - the company ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category, or null if a matching message boards category could not be found
  - findByCompanyId_PrevAndNext
```
public static MBCategory[] findByCompanyId_PrevAndNext(long categoryId,
                                                       long companyId,
                                                       OrderByComparator<MBCategory> orderByComparator)
                                                throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set where companyId = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    companyId - the company ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - removeByCompanyId
```
public static void removeByCompanyId(long companyId)
```
    Removes all the message boards categories where companyId = ? from the database.
    
    Parameters:
    
    companyId - the company ID
  - countByCompanyId
```
public static int countByCompanyId(long companyId)
```
    Returns the number of message boards categories where companyId = ?.
    
    Parameters:
    
    companyId - the company ID
    
    Returns:
    
    the number of matching message boards categories
  - findByG_P
```
public static java.util.List<MBCategory> findByG_P(long groupId,
                                                   long parentCategoryId)
```
    Returns all the message boards categories where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    Returns:
    
    the matching message boards categories
  - findByG_P
```
public static java.util.List<MBCategory> findByG_P(long groupId,
                                                   long parentCategoryId,
                                                   int start,
                                                   int end)
```
    Returns a range of all the message boards categories where groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByG_P
```
public static java.util.List<MBCategory> findByG_P(long groupId,
                                                   long parentCategoryId,
                                                   int start,
                                                   int end,
                                                   OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByG_P
```
public static java.util.List<MBCategory> findByG_P(long groupId,
                                                   long parentCategoryId,
                                                   int start,
                                                   int end,
                                                   OrderByComparator<MBCategory> orderByComparator,
                                                   boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByG_P_First
```
public static MBCategory findByG_P_First(long groupId,
                                         long parentCategoryId,
                                         OrderByComparator<MBCategory> orderByComparator)
                                  throws NoSuchCategoryException
```
    Returns the first message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByG_P_First
```
public static MBCategory fetchByG_P_First(long groupId,
                                          long parentCategoryId,
                                          OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category, or null if a matching message boards category could not be found
  - findByG_P_Last
```
public static MBCategory findByG_P_Last(long groupId,
                                        long parentCategoryId,
                                        OrderByComparator<MBCategory> orderByComparator)
                                 throws NoSuchCategoryException
```
    Returns the last message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByG_P_Last
```
public static MBCategory fetchByG_P_Last(long groupId,
                                         long parentCategoryId,
                                         OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category, or null if a matching message boards category could not be found
  - findByG_P_PrevAndNext
```
public static MBCategory[] findByG_P_PrevAndNext(long categoryId,
                                                 long groupId,
                                                 long parentCategoryId,
                                                 OrderByComparator<MBCategory> orderByComparator)
                                          throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - filterFindByG_P
```
public static java.util.List<MBCategory> filterFindByG_P(long groupId,
                                                         long parentCategoryId)
```
    Returns all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByG_P
```
public static java.util.List<MBCategory> filterFindByG_P(long groupId,
                                                         long parentCategoryId,
                                                         int start,
                                                         int end)
```
    Returns a range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByG_P
```
public static java.util.List<MBCategory> filterFindByG_P(long groupId,
                                                         long parentCategoryId,
                                                         int start,
                                                         int end,
                                                         OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - filterFindByG_P_PrevAndNext
```
public static MBCategory[] filterFindByG_P_PrevAndNext(long categoryId,
                                                       long groupId,
                                                       long parentCategoryId,
                                                       OrderByComparator<MBCategory> orderByComparator)
                                                throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - filterFindByG_P
```
public static java.util.List<MBCategory> filterFindByG_P(long groupId,
                                                         long[] parentCategoryIds)
```
    Returns all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByG_P
```
public static java.util.List<MBCategory> filterFindByG_P(long groupId,
                                                         long[] parentCategoryIds,
                                                         int start,
                                                         int end)
```
    Returns a range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByG_P
```
public static java.util.List<MBCategory> filterFindByG_P(long groupId,
                                                         long[] parentCategoryIds,
                                                         int start,
                                                         int end,
                                                         OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - findByG_P
```
public static java.util.List<MBCategory> findByG_P(long groupId,
                                                   long[] parentCategoryIds)
```
    Returns all the message boards categories where groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    Returns:
    
    the matching message boards categories
  - findByG_P
```
public static java.util.List<MBCategory> findByG_P(long groupId,
                                                   long[] parentCategoryIds,
                                                   int start,
                                                   int end)
```
    Returns a range of all the message boards categories where groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByG_P
```
public static java.util.List<MBCategory> findByG_P(long groupId,
                                                   long[] parentCategoryIds,
                                                   int start,
                                                   int end,
                                                   OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByG_P
```
public static java.util.List<MBCategory> findByG_P(long groupId,
                                                   long[] parentCategoryIds,
                                                   int start,
                                                   int end,
                                                   OrderByComparator<MBCategory> orderByComparator,
                                                   boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ?, 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - removeByG_P
```
public static void removeByG_P(long groupId,
                               long parentCategoryId)
```
    Removes all the message boards categories where groupId = ? and parentCategoryId = ? from the database.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
  - countByG_P
```
public static int countByG_P(long groupId,
                             long parentCategoryId)
```
    Returns the number of message boards categories where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    Returns:
    
    the number of matching message boards categories
  - countByG_P
```
public static int countByG_P(long groupId,
                             long[] parentCategoryIds)
```
    Returns the number of message boards categories where groupId = ? and parentCategoryId = any ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    Returns:
    
    the number of matching message boards categories
  - filterCountByG_P
```
public static int filterCountByG_P(long groupId,
                                   long parentCategoryId)
```
    Returns the number of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - filterCountByG_P
```
public static int filterCountByG_P(long groupId,
                                   long[] parentCategoryIds)
```
    Returns the number of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - findByG_S
```
public static java.util.List<MBCategory> findByG_S(long groupId,
                                                   int status)
```
    Returns all the message boards categories where groupId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    Returns:
    
    the matching message boards categories
  - findByG_S
```
public static java.util.List<MBCategory> findByG_S(long groupId,
                                                   int status,
                                                   int start,
                                                   int end)
```
    Returns a range of all the message boards categories where groupId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByG_S
```
public static java.util.List<MBCategory> findByG_S(long groupId,
                                                   int status,
                                                   int start,
                                                   int end,
                                                   OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where groupId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByG_S
```
public static java.util.List<MBCategory> findByG_S(long groupId,
                                                   int status,
                                                   int start,
                                                   int end,
                                                   OrderByComparator<MBCategory> orderByComparator,
                                                   boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where groupId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByG_S_First
```
public static MBCategory findByG_S_First(long groupId,
                                         int status,
                                         OrderByComparator<MBCategory> orderByComparator)
                                  throws NoSuchCategoryException
```
    Returns the first message boards category in the ordered set where groupId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByG_S_First
```
public static MBCategory fetchByG_S_First(long groupId,
                                          int status,
                                          OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category in the ordered set where groupId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category, or null if a matching message boards category could not be found
  - findByG_S_Last
```
public static MBCategory findByG_S_Last(long groupId,
                                        int status,
                                        OrderByComparator<MBCategory> orderByComparator)
                                 throws NoSuchCategoryException
```
    Returns the last message boards category in the ordered set where groupId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByG_S_Last
```
public static MBCategory fetchByG_S_Last(long groupId,
                                         int status,
                                         OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category in the ordered set where groupId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category, or null if a matching message boards category could not be found
  - findByG_S_PrevAndNext
```
public static MBCategory[] findByG_S_PrevAndNext(long categoryId,
                                                 long groupId,
                                                 int status,
                                                 OrderByComparator<MBCategory> orderByComparator)
                                          throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set where groupId = ? and status = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    groupId - the group ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - filterFindByG_S
```
public static java.util.List<MBCategory> filterFindByG_S(long groupId,
                                                         int status)
```
    Returns all the message boards categories that the user has permission to view where groupId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByG_S
```
public static java.util.List<MBCategory> filterFindByG_S(long groupId,
                                                         int status,
                                                         int start,
                                                         int end)
```
    Returns a range of all the message boards categories that the user has permission to view where groupId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByG_S
```
public static java.util.List<MBCategory> filterFindByG_S(long groupId,
                                                         int status,
                                                         int start,
                                                         int end,
                                                         OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - filterFindByG_S_PrevAndNext
```
public static MBCategory[] filterFindByG_S_PrevAndNext(long categoryId,
                                                       long groupId,
                                                       int status,
                                                       OrderByComparator<MBCategory> orderByComparator)
                                                throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set of message boards categories that the user has permission to view where groupId = ? and status = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    groupId - the group ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - removeByG_S
```
public static void removeByG_S(long groupId,
                               int status)
```
    Removes all the message boards categories where groupId = ? and status = ? from the database.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
  - countByG_S
```
public static int countByG_S(long groupId,
                             int status)
```
    Returns the number of message boards categories where groupId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories
  - filterCountByG_S
```
public static int filterCountByG_S(long groupId,
                                   int status)
```
    Returns the number of message boards categories that the user has permission to view where groupId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - findByC_S
```
public static java.util.List<MBCategory> findByC_S(long companyId,
                                                   int status)
```
    Returns all the message boards categories where companyId = ? and status = ?.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
    
    Returns:
    
    the matching message boards categories
  - findByC_S
```
public static java.util.List<MBCategory> findByC_S(long companyId,
                                                   int status,
                                                   int start,
                                                   int end)
```
    Returns a range of all the message boards categories where 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByC_S
```
public static java.util.List<MBCategory> findByC_S(long companyId,
                                                   int status,
                                                   int start,
                                                   int end,
                                                   OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByC_S
```
public static java.util.List<MBCategory> findByC_S(long companyId,
                                                   int status,
                                                   int start,
                                                   int end,
                                                   OrderByComparator<MBCategory> orderByComparator,
                                                   boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByC_S_First
```
public static MBCategory findByC_S_First(long companyId,
                                         int status,
                                         OrderByComparator<MBCategory> orderByComparator)
                                  throws NoSuchCategoryException
```
    Returns the first message boards category in the ordered set where companyId = ? and status = ?.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByC_S_First
```
public static MBCategory fetchByC_S_First(long companyId,
                                          int status,
                                          OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category in the ordered set where companyId = ? and status = ?.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category, or null if a matching message boards category could not be found
  - findByC_S_Last
```
public static MBCategory findByC_S_Last(long companyId,
                                        int status,
                                        OrderByComparator<MBCategory> orderByComparator)
                                 throws NoSuchCategoryException
```
    Returns the last message boards category in the ordered set where companyId = ? and status = ?.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByC_S_Last
```
public static MBCategory fetchByC_S_Last(long companyId,
                                         int status,
                                         OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category in the ordered set where companyId = ? and status = ?.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category, or null if a matching message boards category could not be found
  - findByC_S_PrevAndNext
```
public static MBCategory[] findByC_S_PrevAndNext(long categoryId,
                                                 long companyId,
                                                 int status,
                                                 OrderByComparator<MBCategory> orderByComparator)
                                          throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set where companyId = ? and status = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    companyId - the company ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - removeByC_S
```
public static void removeByC_S(long companyId,
                               int status)
```
    Removes all the message boards categories where companyId = ? and status = ? from the database.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
  - countByC_S
```
public static int countByC_S(long companyId,
                             int status)
```
    Returns the number of message boards categories where companyId = ? and status = ?.
    
    Parameters:
    
    companyId - the company ID
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories
  - findByNotC_G_P
```
public static java.util.List<MBCategory> findByNotC_G_P(long categoryId,
                                                        long groupId,
                                                        long parentCategoryId)
```
    Returns all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    Returns:
    
    the matching message boards categories
  - findByNotC_G_P
```
public static java.util.List<MBCategory> findByNotC_G_P(long categoryId,
                                                        long groupId,
                                                        long parentCategoryId,
                                                        int start,
                                                        int end)
```
    Returns a range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByNotC_G_P
```
public static java.util.List<MBCategory> findByNotC_G_P(long categoryId,
                                                        long groupId,
                                                        long parentCategoryId,
                                                        int start,
                                                        int end,
                                                        OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByNotC_G_P
```
public static java.util.List<MBCategory> findByNotC_G_P(long categoryId,
                                                        long groupId,
                                                        long parentCategoryId,
                                                        int start,
                                                        int end,
                                                        OrderByComparator<MBCategory> orderByComparator,
                                                        boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByNotC_G_P_First
```
public static MBCategory findByNotC_G_P_First(long categoryId,
                                              long groupId,
                                              long parentCategoryId,
                                              OrderByComparator<MBCategory> orderByComparator)
                                       throws NoSuchCategoryException
```
    Returns the first message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByNotC_G_P_First
```
public static MBCategory fetchByNotC_G_P_First(long categoryId,
                                               long groupId,
                                               long parentCategoryId,
                                               OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category, or null if a matching message boards category could not be found
  - findByNotC_G_P_Last
```
public static MBCategory findByNotC_G_P_Last(long categoryId,
                                             long groupId,
                                             long parentCategoryId,
                                             OrderByComparator<MBCategory> orderByComparator)
                                      throws NoSuchCategoryException
```
    Returns the last message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByNotC_G_P_Last
```
public static MBCategory fetchByNotC_G_P_Last(long categoryId,
                                              long groupId,
                                              long parentCategoryId,
                                              OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category, or null if a matching message boards category could not be found
  - filterFindByNotC_G_P
```
public static java.util.List<MBCategory> filterFindByNotC_G_P(long categoryId,
                                                              long groupId,
                                                              long parentCategoryId)
```
    Returns all the message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P
```
public static java.util.List<MBCategory> filterFindByNotC_G_P(long categoryId,
                                                              long groupId,
                                                              long parentCategoryId,
                                                              int start,
                                                              int end)
```
    Returns a range of all the message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P
```
public static java.util.List<MBCategory> filterFindByNotC_G_P(long categoryId,
                                                              long groupId,
                                                              long parentCategoryId,
                                                              int start,
                                                              int end,
                                                              OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permissions to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P
```
public static java.util.List<MBCategory> filterFindByNotC_G_P(long[] categoryIds,
                                                              long groupId,
                                                              long[] parentCategoryIds)
```
    Returns all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P
```
public static java.util.List<MBCategory> filterFindByNotC_G_P(long[] categoryIds,
                                                              long groupId,
                                                              long[] parentCategoryIds,
                                                              int start,
                                                              int end)
```
    Returns a range of all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P
```
public static java.util.List<MBCategory> filterFindByNotC_G_P(long[] categoryIds,
                                                              long groupId,
                                                              long[] parentCategoryIds,
                                                              int start,
                                                              int end,
                                                              OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - findByNotC_G_P
```
public static java.util.List<MBCategory> findByNotC_G_P(long[] categoryIds,
                                                        long groupId,
                                                        long[] parentCategoryIds)
```
    Returns all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    Returns:
    
    the matching message boards categories
  - findByNotC_G_P
```
public static java.util.List<MBCategory> findByNotC_G_P(long[] categoryIds,
                                                        long groupId,
                                                        long[] parentCategoryIds,
                                                        int start,
                                                        int end)
```
    Returns a range of all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByNotC_G_P
```
public static java.util.List<MBCategory> findByNotC_G_P(long[] categoryIds,
                                                        long groupId,
                                                        long[] parentCategoryIds,
                                                        int start,
                                                        int end,
                                                        OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByNotC_G_P
```
public static java.util.List<MBCategory> findByNotC_G_P(long[] categoryIds,
                                                        long groupId,
                                                        long[] parentCategoryIds,
                                                        int start,
                                                        int end,
                                                        OrderByComparator<MBCategory> orderByComparator,
                                                        boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?, 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - removeByNotC_G_P
```
public static void removeByNotC_G_P(long categoryId,
                                    long groupId,
                                    long parentCategoryId)
```
    Removes all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? from the database.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
  - countByNotC_G_P
```
public static int countByNotC_G_P(long categoryId,
                                  long groupId,
                                  long parentCategoryId)
```
    Returns the number of message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    Returns:
    
    the number of matching message boards categories
  - countByNotC_G_P
```
public static int countByNotC_G_P(long[] categoryIds,
                                  long groupId,
                                  long[] parentCategoryIds)
```
    Returns the number of message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    Returns:
    
    the number of matching message boards categories
  - filterCountByNotC_G_P
```
public static int filterCountByNotC_G_P(long categoryId,
                                        long groupId,
                                        long parentCategoryId)
```
    Returns the number of message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - filterCountByNotC_G_P
```
public static int filterCountByNotC_G_P(long[] categoryIds,
                                        long groupId,
                                        long[] parentCategoryIds)
```
    Returns the number of message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ?.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - findByG_P_S
```
public static java.util.List<MBCategory> findByG_P_S(long groupId,
                                                     long parentCategoryId,
                                                     int status)
```
    Returns all the message boards categories where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    Returns:
    
    the matching message boards categories
  - findByG_P_S
```
public static java.util.List<MBCategory> findByG_P_S(long groupId,
                                                     long parentCategoryId,
                                                     int status,
                                                     int start,
                                                     int end)
```
    Returns a range of all the message boards categories where groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByG_P_S
```
public static java.util.List<MBCategory> findByG_P_S(long groupId,
                                                     long parentCategoryId,
                                                     int status,
                                                     int start,
                                                     int end,
                                                     OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByG_P_S
```
public static java.util.List<MBCategory> findByG_P_S(long groupId,
                                                     long parentCategoryId,
                                                     int status,
                                                     int start,
                                                     int end,
                                                     OrderByComparator<MBCategory> orderByComparator,
                                                     boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByG_P_S_First
```
public static MBCategory findByG_P_S_First(long groupId,
                                           long parentCategoryId,
                                           int status,
                                           OrderByComparator<MBCategory> orderByComparator)
                                    throws NoSuchCategoryException
```
    Returns the first message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByG_P_S_First
```
public static MBCategory fetchByG_P_S_First(long groupId,
                                            long parentCategoryId,
                                            int status,
                                            OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category, or null if a matching message boards category could not be found
  - findByG_P_S_Last
```
public static MBCategory findByG_P_S_Last(long groupId,
                                          long parentCategoryId,
                                          int status,
                                          OrderByComparator<MBCategory> orderByComparator)
                                   throws NoSuchCategoryException
```
    Returns the last message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByG_P_S_Last
```
public static MBCategory fetchByG_P_S_Last(long groupId,
                                           long parentCategoryId,
                                           int status,
                                           OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category, or null if a matching message boards category could not be found
  - findByG_P_S_PrevAndNext
```
public static MBCategory[] findByG_P_S_PrevAndNext(long categoryId,
                                                   long groupId,
                                                   long parentCategoryId,
                                                   int status,
                                                   OrderByComparator<MBCategory> orderByComparator)
                                            throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - filterFindByG_P_S
```
public static java.util.List<MBCategory> filterFindByG_P_S(long groupId,
                                                           long parentCategoryId,
                                                           int status)
```
    Returns all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByG_P_S
```
public static java.util.List<MBCategory> filterFindByG_P_S(long groupId,
                                                           long parentCategoryId,
                                                           int status,
                                                           int start,
                                                           int end)
```
    Returns a range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByG_P_S
```
public static java.util.List<MBCategory> filterFindByG_P_S(long groupId,
                                                           long parentCategoryId,
                                                           int status,
                                                           int start,
                                                           int end,
                                                           OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - filterFindByG_P_S_PrevAndNext
```
public static MBCategory[] filterFindByG_P_S_PrevAndNext(long categoryId,
                                                         long groupId,
                                                         long parentCategoryId,
                                                         int status,
                                                         OrderByComparator<MBCategory> orderByComparator)
                                                  throws NoSuchCategoryException
```
    Returns the message boards categories before and after the current message boards category in the ordered set of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the primary key of the current message boards category
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the previous, current, and next message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - filterFindByG_P_S
```
public static java.util.List<MBCategory> filterFindByG_P_S(long groupId,
                                                           long[] parentCategoryIds,
                                                           int status)
```
    Returns all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByG_P_S
```
public static java.util.List<MBCategory> filterFindByG_P_S(long groupId,
                                                           long[] parentCategoryIds,
                                                           int status,
                                                           int start,
                                                           int end)
```
    Returns a range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByG_P_S
```
public static java.util.List<MBCategory> filterFindByG_P_S(long groupId,
                                                           long[] parentCategoryIds,
                                                           int status,
                                                           int start,
                                                           int end,
                                                           OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - findByG_P_S
```
public static java.util.List<MBCategory> findByG_P_S(long groupId,
                                                     long[] parentCategoryIds,
                                                     int status)
```
    Returns all the message boards categories where groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    Returns:
    
    the matching message boards categories
  - findByG_P_S
```
public static java.util.List<MBCategory> findByG_P_S(long groupId,
                                                     long[] parentCategoryIds,
                                                     int status,
                                                     int start,
                                                     int end)
```
    Returns a range of all the message boards categories where groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByG_P_S
```
public static java.util.List<MBCategory> findByG_P_S(long groupId,
                                                     long[] parentCategoryIds,
                                                     int status,
                                                     int start,
                                                     int end,
                                                     OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByG_P_S
```
public static java.util.List<MBCategory> findByG_P_S(long groupId,
                                                     long[] parentCategoryIds,
                                                     int status,
                                                     int start,
                                                     int end,
                                                     OrderByComparator<MBCategory> orderByComparator,
                                                     boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - removeByG_P_S
```
public static void removeByG_P_S(long groupId,
                                 long parentCategoryId,
                                 int status)
```
    Removes all the message boards categories where groupId = ? and parentCategoryId = ? and status = ? from the database.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
  - countByG_P_S
```
public static int countByG_P_S(long groupId,
                               long parentCategoryId,
                               int status)
```
    Returns the number of message boards categories where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories
  - countByG_P_S
```
public static int countByG_P_S(long groupId,
                               long[] parentCategoryIds,
                               int status)
```
    Returns the number of message boards categories where groupId = ? and parentCategoryId = any ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories
  - filterCountByG_P_S
```
public static int filterCountByG_P_S(long groupId,
                                     long parentCategoryId,
                                     int status)
```
    Returns the number of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - filterCountByG_P_S
```
public static int filterCountByG_P_S(long groupId,
                                     long[] parentCategoryIds,
                                     int status)
```
    Returns the number of message boards categories that the user has permission to view where groupId = ? and parentCategoryId = any ? and status = ?.
    
    Parameters:
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - findByNotC_G_P_S
```
public static java.util.List<MBCategory> findByNotC_G_P_S(long categoryId,
                                                          long groupId,
                                                          long parentCategoryId,
                                                          int status)
```
    Returns all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    Returns:
    
    the matching message boards categories
  - findByNotC_G_P_S
```
public static java.util.List<MBCategory> findByNotC_G_P_S(long categoryId,
                                                          long groupId,
                                                          long parentCategoryId,
                                                          int status,
                                                          int start,
                                                          int end)
```
    Returns a range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByNotC_G_P_S
```
public static java.util.List<MBCategory> findByNotC_G_P_S(long categoryId,
                                                          long groupId,
                                                          long parentCategoryId,
                                                          int status,
                                                          int start,
                                                          int end,
                                                          OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByNotC_G_P_S
```
public static java.util.List<MBCategory> findByNotC_G_P_S(long categoryId,
                                                          long groupId,
                                                          long parentCategoryId,
                                                          int status,
                                                          int start,
                                                          int end,
                                                          OrderByComparator<MBCategory> orderByComparator,
                                                          boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByNotC_G_P_S_First
```
public static MBCategory findByNotC_G_P_S_First(long categoryId,
                                                long groupId,
                                                long parentCategoryId,
                                                int status,
                                                OrderByComparator<MBCategory> orderByComparator)
                                         throws NoSuchCategoryException
```
    Returns the first message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByNotC_G_P_S_First
```
public static MBCategory fetchByNotC_G_P_S_First(long categoryId,
                                                 long groupId,
                                                 long parentCategoryId,
                                                 int status,
                                                 OrderByComparator<MBCategory> orderByComparator)
```
    Returns the first message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the first matching message boards category, or null if a matching message boards category could not be found
  - findByNotC_G_P_S_Last
```
public static MBCategory findByNotC_G_P_S_Last(long categoryId,
                                               long groupId,
                                               long parentCategoryId,
                                               int status,
                                               OrderByComparator<MBCategory> orderByComparator)
                                        throws NoSuchCategoryException
```
    Returns the last message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category
    
    Throws:
    
    NoSuchCategoryException - if a matching message boards category could not be found
  - fetchByNotC_G_P_S_Last
```
public static MBCategory fetchByNotC_G_P_S_Last(long categoryId,
                                                long groupId,
                                                long parentCategoryId,
                                                int status,
                                                OrderByComparator<MBCategory> orderByComparator)
```
    Returns the last message boards category in the ordered set where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    orderByComparator - the comparator to order the set by (optionally null)
    
    Returns:
    
    the last matching message boards category, or null if a matching message boards category could not be found
  - filterFindByNotC_G_P_S
```
public static java.util.List<MBCategory> filterFindByNotC_G_P_S(long categoryId,
                                                                long groupId,
                                                                long parentCategoryId,
                                                                int status)
```
    Returns all the message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P_S
```
public static java.util.List<MBCategory> filterFindByNotC_G_P_S(long categoryId,
                                                                long groupId,
                                                                long parentCategoryId,
                                                                int status,
                                                                int start,
                                                                int end)
```
    Returns a range of all the message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P_S
```
public static java.util.List<MBCategory> filterFindByNotC_G_P_S(long categoryId,
                                                                long groupId,
                                                                long parentCategoryId,
                                                                int status,
                                                                int start,
                                                                int end,
                                                                OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permissions to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P_S
```
public static java.util.List<MBCategory> filterFindByNotC_G_P_S(long[] categoryIds,
                                                                long groupId,
                                                                long[] parentCategoryIds,
                                                                int status)
```
    Returns all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    Returns:
    
    the matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P_S
```
public static java.util.List<MBCategory> filterFindByNotC_G_P_S(long[] categoryIds,
                                                                long groupId,
                                                                long[] parentCategoryIds,
                                                                int status,
                                                                int start,
                                                                int end)
```
    Returns a range of all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories that the user has permission to view
  - filterFindByNotC_G_P_S
```
public static java.util.List<MBCategory> filterFindByNotC_G_P_S(long[] categoryIds,
                                                                long groupId,
                                                                long[] parentCategoryIds,
                                                                int status,
                                                                int start,
                                                                int end,
                                                                OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories that the user has permission to view
  - findByNotC_G_P_S
```
public static java.util.List<MBCategory> findByNotC_G_P_S(long[] categoryIds,
                                                          long groupId,
                                                          long[] parentCategoryIds,
                                                          int status)
```
    Returns all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    Returns:
    
    the matching message boards categories
  - findByNotC_G_P_S
```
public static java.util.List<MBCategory> findByNotC_G_P_S(long[] categoryIds,
                                                          long groupId,
                                                          long[] parentCategoryIds,
                                                          int status,
                                                          int start,
                                                          int end)
```
    Returns a range of all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of matching message boards categories
  - findByNotC_G_P_S
```
public static java.util.List<MBCategory> findByNotC_G_P_S(long[] categoryIds,
                                                          long groupId,
                                                          long[] parentCategoryIds,
                                                          int status,
                                                          int start,
                                                          int end,
                                                          OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of matching message boards categories
  - findByNotC_G_P_S
```
public static java.util.List<MBCategory> findByNotC_G_P_S(long[] categoryIds,
                                                          long groupId,
                                                          long[] parentCategoryIds,
                                                          int status,
                                                          int start,
                                                          int end,
                                                          OrderByComparator<MBCategory> orderByComparator,
                                                          boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? 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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of matching message boards categories
  - removeByNotC_G_P_S
```
public static void removeByNotC_G_P_S(long categoryId,
                                      long groupId,
                                      long parentCategoryId,
                                      int status)
```
    Removes all the message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ? from the database.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
  - countByNotC_G_P_S
```
public static int countByNotC_G_P_S(long categoryId,
                                    long groupId,
                                    long parentCategoryId,
                                    int status)
```
    Returns the number of message boards categories where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories
  - countByNotC_G_P_S
```
public static int countByNotC_G_P_S(long[] categoryIds,
                                    long groupId,
                                    long[] parentCategoryIds,
                                    int status)
```
    Returns the number of message boards categories where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories
  - filterCountByNotC_G_P_S
```
public static int filterCountByNotC_G_P_S(long categoryId,
                                          long groupId,
                                          long parentCategoryId,
                                          int status)
```
    Returns the number of message boards categories that the user has permission to view where categoryId ≠ ? and groupId = ? and parentCategoryId = ? and status = ?.
    
    Parameters:
    
    categoryId - the category ID
    
    groupId - the group ID
    
    parentCategoryId - the parent category ID
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - filterCountByNotC_G_P_S
```
public static int filterCountByNotC_G_P_S(long[] categoryIds,
                                          long groupId,
                                          long[] parentCategoryIds,
                                          int status)
```
    Returns the number of message boards categories that the user has permission to view where categoryId ≠ all ? and groupId = ? and parentCategoryId = any ? and status = ?.
    
    Parameters:
    
    categoryIds - the category IDs
    
    groupId - the group ID
    
    parentCategoryIds - the parent category IDs
    
    status - the status
    
    Returns:
    
    the number of matching message boards categories that the user has permission to view
  - cacheResult
```
public static void cacheResult(MBCategory mbCategory)
```
    Caches the message boards category in the entity cache if it is enabled.
    
    Parameters:
    
    mbCategory - the message boards category
  - cacheResult
```
public static void cacheResult(java.util.List<MBCategory> mbCategories)
```
    Caches the message boards categories in the entity cache if it is enabled.
    
    Parameters:
    
    mbCategories - the message boards categories
  - create
```
public static MBCategory create(long categoryId)
```
    Creates a new message boards category with the primary key. Does not add the message boards category to the database.
    
    Parameters:
    
    categoryId - the primary key for the new message boards category
    
    Returns:
    
    the new message boards category
  - remove
```
public static MBCategory remove(long categoryId)
                         throws NoSuchCategoryException
```
    Removes the message boards category with the primary key from the database. Also notifies the appropriate model listeners.
    
    Parameters:
    
    categoryId - the primary key of the message boards category
    
    Returns:
    
    the message boards category that was removed
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - updateImpl
```
public static MBCategory updateImpl(MBCategory mbCategory)
```
  - findByPrimaryKey
```
public static MBCategory findByPrimaryKey(long categoryId)
                                   throws NoSuchCategoryException
```
    Returns the message boards category with the primary key or throws a NoSuchCategoryException if it could not be found.
    
    Parameters:
    
    categoryId - the primary key of the message boards category
    
    Returns:
    
    the message boards category
    
    Throws:
    
    NoSuchCategoryException - if a message boards category with the primary key could not be found
  - fetchByPrimaryKey
```
public static MBCategory fetchByPrimaryKey(long categoryId)
```
    Returns the message boards category with the primary key or returns null if it could not be found.
    
    Parameters:
    
    categoryId - the primary key of the message boards category
    
    Returns:
    
    the message boards category, or null if a message boards category with the primary key could not be found
  - fetchByPrimaryKeys
```
public static java.util.Map<java.io.Serializable,MBCategory> fetchByPrimaryKeys(java.util.Set<java.io.Serializable> primaryKeys)
```
  - findAll
```
public static java.util.List<MBCategory> findAll()
```
    Returns all the message boards categories.
    
    Returns:
    
    the message boards categories
  - findAll
```
public static java.util.List<MBCategory> findAll(int start,
                                                 int end)
```
    Returns a range of all the message boards categories.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    Returns:
    
    the range of message boards categories
  - findAll
```
public static java.util.List<MBCategory> findAll(int start,
                                                 int end,
                                                 OrderByComparator<MBCategory> orderByComparator)
```
    Returns an ordered range of all the message boards categories.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    Returns:
    
    the ordered range of message boards categories
  - findAll
```
public static java.util.List<MBCategory> findAll(int start,
                                                 int end,
                                                 OrderByComparator<MBCategory> orderByComparator,
                                                 boolean retrieveFromCache)
```
    Returns an ordered range of all the message boards categories.
    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 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 and pagination is required (start and end are not QueryUtil#ALL_POS), then the query will include the default ORDER BY logic from MBCategoryModelImpl. If both orderByComparator and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
    
    Parameters:
    
    start - the lower bound of the range of message boards categories
    
    end - the upper bound of the range of message boards categories (not inclusive)
    
    orderByComparator - the comparator to order the results by (optionally null)
    
    retrieveFromCache - whether to retrieve from the finder cache
    
    Returns:
    
    the ordered range of message boards categories
  - removeAll
```
public static void removeAll()
```
    Removes all the message boards categories from the database.
  - countAll
```
public static int countAll()
```
    Returns the number of message boards categories.
    
    Returns:
    
    the number of message boards categories
  - getBadColumnNames
```
public static java.util.Set<java.lang.String> getBadColumnNames()
```
  - getPersistence
```
public static MBCategoryPersistence getPersistence()
```

Class MBCategoryUtil

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

MBCategoryUtil

Method Detail

clearCache

clearCache

countWithDynamicQuery

findWithDynamicQuery

findWithDynamicQuery

findWithDynamicQuery

update

update

findByUuid

findByUuid

findByUuid

findByUuid

findByUuid_First

fetchByUuid_First

findByUuid_Last

fetchByUuid_Last

findByUuid_PrevAndNext

removeByUuid

countByUuid

findByUUID_G

fetchByUUID_G

fetchByUUID_G

removeByUUID_G

countByUUID_G

findByUuid_C

findByUuid_C

findByUuid_C

findByUuid_C

findByUuid_C_First

fetchByUuid_C_First

findByUuid_C_Last

fetchByUuid_C_Last

findByUuid_C_PrevAndNext

removeByUuid_C

countByUuid_C

findByGroupId

findByGroupId

findByGroupId

findByGroupId

findByGroupId_First

fetchByGroupId_First

findByGroupId_Last

fetchByGroupId_Last

findByGroupId_PrevAndNext

filterFindByGroupId

filterFindByGroupId

filterFindByGroupId

filterFindByGroupId_PrevAndNext

removeByGroupId

countByGroupId

filterCountByGroupId

findByCompanyId

findByCompanyId

findByCompanyId

findByCompanyId

findByCompanyId_First

fetchByCompanyId_First

findByCompanyId_Last

fetchByCompanyId_Last

findByCompanyId_PrevAndNext

removeByCompanyId

countByCompanyId

findByG_P

findByG_P

findByG_P

findByG_P

findByG_P_First

fetchByG_P_First

findByG_P_Last

fetchByG_P_Last

findByG_P_PrevAndNext

filterFindByG_P

filterFindByG_P