001    /**
002     * Copyright (c) 2000-2013 Liferay, Inc. All rights reserved.
003     *
004     * This library is free software; you can redistribute it and/or modify it under
005     * the terms of the GNU Lesser General Public License as published by the Free
006     * Software Foundation; either version 2.1 of the License, or (at your option)
007     * any later version.
008     *
009     * This library is distributed in the hope that it will be useful, but WITHOUT
010     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
011     * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
012     * details.
013     */
014    
015    package com.liferay.portlet.messageboards.service.persistence;
016    
017    import com.liferay.portal.service.persistence.BasePersistence;
018    
019    import com.liferay.portlet.messageboards.model.MBCategory;
020    
021    /**
022     * The persistence interface for the message boards category service.
023     *
024     * <p>
025     * Caching information and settings can be found in <code>portal.properties</code>
026     * </p>
027     *
028     * @author Brian Wing Shun Chan
029     * @see MBCategoryPersistenceImpl
030     * @see MBCategoryUtil
031     * @generated
032     */
033    public interface MBCategoryPersistence extends BasePersistence<MBCategory> {
034            /*
035             * NOTE FOR DEVELOPERS:
036             *
037             * Never modify or reference this interface directly. Always use {@link MBCategoryUtil} to access the message boards category persistence. Modify <code>service.xml</code> and rerun ServiceBuilder to regenerate this interface.
038             */
039    
040            /**
041            * Returns all the message boards categories where uuid = &#63;.
042            *
043            * @param uuid the uuid
044            * @return the matching message boards categories
045            * @throws SystemException if a system exception occurred
046            */
047            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByUuid(
048                    java.lang.String uuid)
049                    throws com.liferay.portal.kernel.exception.SystemException;
050    
051            /**
052            * Returns a range of all the message boards categories where uuid = &#63;.
053            *
054            * <p>
055            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
056            * </p>
057            *
058            * @param uuid the uuid
059            * @param start the lower bound of the range of message boards categories
060            * @param end the upper bound of the range of message boards categories (not inclusive)
061            * @return the range of matching message boards categories
062            * @throws SystemException if a system exception occurred
063            */
064            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByUuid(
065                    java.lang.String uuid, int start, int end)
066                    throws com.liferay.portal.kernel.exception.SystemException;
067    
068            /**
069            * Returns an ordered range of all the message boards categories where uuid = &#63;.
070            *
071            * <p>
072            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
073            * </p>
074            *
075            * @param uuid the uuid
076            * @param start the lower bound of the range of message boards categories
077            * @param end the upper bound of the range of message boards categories (not inclusive)
078            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
079            * @return the ordered range of matching message boards categories
080            * @throws SystemException if a system exception occurred
081            */
082            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByUuid(
083                    java.lang.String uuid, int start, int end,
084                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
085                    throws com.liferay.portal.kernel.exception.SystemException;
086    
087            /**
088            * Returns the first message boards category in the ordered set where uuid = &#63;.
089            *
090            * @param uuid the uuid
091            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
092            * @return the first matching message boards category
093            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
094            * @throws SystemException if a system exception occurred
095            */
096            public com.liferay.portlet.messageboards.model.MBCategory findByUuid_First(
097                    java.lang.String uuid,
098                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
099                    throws com.liferay.portal.kernel.exception.SystemException,
100                            com.liferay.portlet.messageboards.NoSuchCategoryException;
101    
102            /**
103            * Returns the first message boards category in the ordered set where uuid = &#63;.
104            *
105            * @param uuid the uuid
106            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
107            * @return the first matching message boards category, or <code>null</code> if a matching message boards category could not be found
108            * @throws SystemException if a system exception occurred
109            */
110            public com.liferay.portlet.messageboards.model.MBCategory fetchByUuid_First(
111                    java.lang.String uuid,
112                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
113                    throws com.liferay.portal.kernel.exception.SystemException;
114    
115            /**
116            * Returns the last message boards category in the ordered set where uuid = &#63;.
117            *
118            * @param uuid the uuid
119            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
120            * @return the last matching message boards category
121            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
122            * @throws SystemException if a system exception occurred
123            */
124            public com.liferay.portlet.messageboards.model.MBCategory findByUuid_Last(
125                    java.lang.String uuid,
126                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
127                    throws com.liferay.portal.kernel.exception.SystemException,
128                            com.liferay.portlet.messageboards.NoSuchCategoryException;
129    
130            /**
131            * Returns the last message boards category in the ordered set where uuid = &#63;.
132            *
133            * @param uuid the uuid
134            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
135            * @return the last matching message boards category, or <code>null</code> if a matching message boards category could not be found
136            * @throws SystemException if a system exception occurred
137            */
138            public com.liferay.portlet.messageboards.model.MBCategory fetchByUuid_Last(
139                    java.lang.String uuid,
140                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
141                    throws com.liferay.portal.kernel.exception.SystemException;
142    
143            /**
144            * Returns the message boards categories before and after the current message boards category in the ordered set where uuid = &#63;.
145            *
146            * @param categoryId the primary key of the current message boards category
147            * @param uuid the uuid
148            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
149            * @return the previous, current, and next message boards category
150            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
151            * @throws SystemException if a system exception occurred
152            */
153            public com.liferay.portlet.messageboards.model.MBCategory[] findByUuid_PrevAndNext(
154                    long categoryId, java.lang.String uuid,
155                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
156                    throws com.liferay.portal.kernel.exception.SystemException,
157                            com.liferay.portlet.messageboards.NoSuchCategoryException;
158    
159            /**
160            * Removes all the message boards categories where uuid = &#63; from the database.
161            *
162            * @param uuid the uuid
163            * @throws SystemException if a system exception occurred
164            */
165            public void removeByUuid(java.lang.String uuid)
166                    throws com.liferay.portal.kernel.exception.SystemException;
167    
168            /**
169            * Returns the number of message boards categories where uuid = &#63;.
170            *
171            * @param uuid the uuid
172            * @return the number of matching message boards categories
173            * @throws SystemException if a system exception occurred
174            */
175            public int countByUuid(java.lang.String uuid)
176                    throws com.liferay.portal.kernel.exception.SystemException;
177    
178            /**
179            * Returns the message boards category where uuid = &#63; and groupId = &#63; or throws a {@link com.liferay.portlet.messageboards.NoSuchCategoryException} if it could not be found.
180            *
181            * @param uuid the uuid
182            * @param groupId the group ID
183            * @return the matching message boards category
184            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
185            * @throws SystemException if a system exception occurred
186            */
187            public com.liferay.portlet.messageboards.model.MBCategory findByUUID_G(
188                    java.lang.String uuid, long groupId)
189                    throws com.liferay.portal.kernel.exception.SystemException,
190                            com.liferay.portlet.messageboards.NoSuchCategoryException;
191    
192            /**
193            * Returns the message boards category where uuid = &#63; and groupId = &#63; or returns <code>null</code> if it could not be found. Uses the finder cache.
194            *
195            * @param uuid the uuid
196            * @param groupId the group ID
197            * @return the matching message boards category, or <code>null</code> if a matching message boards category could not be found
198            * @throws SystemException if a system exception occurred
199            */
200            public com.liferay.portlet.messageboards.model.MBCategory fetchByUUID_G(
201                    java.lang.String uuid, long groupId)
202                    throws com.liferay.portal.kernel.exception.SystemException;
203    
204            /**
205            * Returns the message boards category where uuid = &#63; and groupId = &#63; or returns <code>null</code> if it could not be found, optionally using the finder cache.
206            *
207            * @param uuid the uuid
208            * @param groupId the group ID
209            * @param retrieveFromCache whether to use the finder cache
210            * @return the matching message boards category, or <code>null</code> if a matching message boards category could not be found
211            * @throws SystemException if a system exception occurred
212            */
213            public com.liferay.portlet.messageboards.model.MBCategory fetchByUUID_G(
214                    java.lang.String uuid, long groupId, boolean retrieveFromCache)
215                    throws com.liferay.portal.kernel.exception.SystemException;
216    
217            /**
218            * Removes the message boards category where uuid = &#63; and groupId = &#63; from the database.
219            *
220            * @param uuid the uuid
221            * @param groupId the group ID
222            * @return the message boards category that was removed
223            * @throws SystemException if a system exception occurred
224            */
225            public com.liferay.portlet.messageboards.model.MBCategory removeByUUID_G(
226                    java.lang.String uuid, long groupId)
227                    throws com.liferay.portal.kernel.exception.SystemException,
228                            com.liferay.portlet.messageboards.NoSuchCategoryException;
229    
230            /**
231            * Returns the number of message boards categories where uuid = &#63; and groupId = &#63;.
232            *
233            * @param uuid the uuid
234            * @param groupId the group ID
235            * @return the number of matching message boards categories
236            * @throws SystemException if a system exception occurred
237            */
238            public int countByUUID_G(java.lang.String uuid, long groupId)
239                    throws com.liferay.portal.kernel.exception.SystemException;
240    
241            /**
242            * Returns all the message boards categories where uuid = &#63; and companyId = &#63;.
243            *
244            * @param uuid the uuid
245            * @param companyId the company ID
246            * @return the matching message boards categories
247            * @throws SystemException if a system exception occurred
248            */
249            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByUuid_C(
250                    java.lang.String uuid, long companyId)
251                    throws com.liferay.portal.kernel.exception.SystemException;
252    
253            /**
254            * Returns a range of all the message boards categories where uuid = &#63; and companyId = &#63;.
255            *
256            * <p>
257            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
258            * </p>
259            *
260            * @param uuid the uuid
261            * @param companyId the company ID
262            * @param start the lower bound of the range of message boards categories
263            * @param end the upper bound of the range of message boards categories (not inclusive)
264            * @return the range of matching message boards categories
265            * @throws SystemException if a system exception occurred
266            */
267            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByUuid_C(
268                    java.lang.String uuid, long companyId, int start, int end)
269                    throws com.liferay.portal.kernel.exception.SystemException;
270    
271            /**
272            * Returns an ordered range of all the message boards categories where uuid = &#63; and companyId = &#63;.
273            *
274            * <p>
275            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
276            * </p>
277            *
278            * @param uuid the uuid
279            * @param companyId the company ID
280            * @param start the lower bound of the range of message boards categories
281            * @param end the upper bound of the range of message boards categories (not inclusive)
282            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
283            * @return the ordered range of matching message boards categories
284            * @throws SystemException if a system exception occurred
285            */
286            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByUuid_C(
287                    java.lang.String uuid, long companyId, int start, int end,
288                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
289                    throws com.liferay.portal.kernel.exception.SystemException;
290    
291            /**
292            * Returns the first message boards category in the ordered set where uuid = &#63; and companyId = &#63;.
293            *
294            * @param uuid the uuid
295            * @param companyId the company ID
296            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
297            * @return the first matching message boards category
298            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
299            * @throws SystemException if a system exception occurred
300            */
301            public com.liferay.portlet.messageboards.model.MBCategory findByUuid_C_First(
302                    java.lang.String uuid, long companyId,
303                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
304                    throws com.liferay.portal.kernel.exception.SystemException,
305                            com.liferay.portlet.messageboards.NoSuchCategoryException;
306    
307            /**
308            * Returns the first message boards category in the ordered set where uuid = &#63; and companyId = &#63;.
309            *
310            * @param uuid the uuid
311            * @param companyId the company ID
312            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
313            * @return the first matching message boards category, or <code>null</code> if a matching message boards category could not be found
314            * @throws SystemException if a system exception occurred
315            */
316            public com.liferay.portlet.messageboards.model.MBCategory fetchByUuid_C_First(
317                    java.lang.String uuid, long companyId,
318                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
319                    throws com.liferay.portal.kernel.exception.SystemException;
320    
321            /**
322            * Returns the last message boards category in the ordered set where uuid = &#63; and companyId = &#63;.
323            *
324            * @param uuid the uuid
325            * @param companyId the company ID
326            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
327            * @return the last matching message boards category
328            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
329            * @throws SystemException if a system exception occurred
330            */
331            public com.liferay.portlet.messageboards.model.MBCategory findByUuid_C_Last(
332                    java.lang.String uuid, long companyId,
333                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
334                    throws com.liferay.portal.kernel.exception.SystemException,
335                            com.liferay.portlet.messageboards.NoSuchCategoryException;
336    
337            /**
338            * Returns the last message boards category in the ordered set where uuid = &#63; and companyId = &#63;.
339            *
340            * @param uuid the uuid
341            * @param companyId the company ID
342            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
343            * @return the last matching message boards category, or <code>null</code> if a matching message boards category could not be found
344            * @throws SystemException if a system exception occurred
345            */
346            public com.liferay.portlet.messageboards.model.MBCategory fetchByUuid_C_Last(
347                    java.lang.String uuid, long companyId,
348                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
349                    throws com.liferay.portal.kernel.exception.SystemException;
350    
351            /**
352            * Returns the message boards categories before and after the current message boards category in the ordered set where uuid = &#63; and companyId = &#63;.
353            *
354            * @param categoryId the primary key of the current message boards category
355            * @param uuid the uuid
356            * @param companyId the company ID
357            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
358            * @return the previous, current, and next message boards category
359            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
360            * @throws SystemException if a system exception occurred
361            */
362            public com.liferay.portlet.messageboards.model.MBCategory[] findByUuid_C_PrevAndNext(
363                    long categoryId, java.lang.String uuid, long companyId,
364                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
365                    throws com.liferay.portal.kernel.exception.SystemException,
366                            com.liferay.portlet.messageboards.NoSuchCategoryException;
367    
368            /**
369            * Removes all the message boards categories where uuid = &#63; and companyId = &#63; from the database.
370            *
371            * @param uuid the uuid
372            * @param companyId the company ID
373            * @throws SystemException if a system exception occurred
374            */
375            public void removeByUuid_C(java.lang.String uuid, long companyId)
376                    throws com.liferay.portal.kernel.exception.SystemException;
377    
378            /**
379            * Returns the number of message boards categories where uuid = &#63; and companyId = &#63;.
380            *
381            * @param uuid the uuid
382            * @param companyId the company ID
383            * @return the number of matching message boards categories
384            * @throws SystemException if a system exception occurred
385            */
386            public int countByUuid_C(java.lang.String uuid, long companyId)
387                    throws com.liferay.portal.kernel.exception.SystemException;
388    
389            /**
390            * Returns all the message boards categories where groupId = &#63;.
391            *
392            * @param groupId the group ID
393            * @return the matching message boards categories
394            * @throws SystemException if a system exception occurred
395            */
396            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByGroupId(
397                    long groupId)
398                    throws com.liferay.portal.kernel.exception.SystemException;
399    
400            /**
401            * Returns a range of all the message boards categories where groupId = &#63;.
402            *
403            * <p>
404            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
405            * </p>
406            *
407            * @param groupId the group ID
408            * @param start the lower bound of the range of message boards categories
409            * @param end the upper bound of the range of message boards categories (not inclusive)
410            * @return the range of matching message boards categories
411            * @throws SystemException if a system exception occurred
412            */
413            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByGroupId(
414                    long groupId, int start, int end)
415                    throws com.liferay.portal.kernel.exception.SystemException;
416    
417            /**
418            * Returns an ordered range of all the message boards categories where groupId = &#63;.
419            *
420            * <p>
421            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
422            * </p>
423            *
424            * @param groupId the group ID
425            * @param start the lower bound of the range of message boards categories
426            * @param end the upper bound of the range of message boards categories (not inclusive)
427            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
428            * @return the ordered range of matching message boards categories
429            * @throws SystemException if a system exception occurred
430            */
431            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByGroupId(
432                    long groupId, int start, int end,
433                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
434                    throws com.liferay.portal.kernel.exception.SystemException;
435    
436            /**
437            * Returns the first message boards category in the ordered set where groupId = &#63;.
438            *
439            * @param groupId the group ID
440            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
441            * @return the first matching message boards category
442            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
443            * @throws SystemException if a system exception occurred
444            */
445            public com.liferay.portlet.messageboards.model.MBCategory findByGroupId_First(
446                    long groupId,
447                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
448                    throws com.liferay.portal.kernel.exception.SystemException,
449                            com.liferay.portlet.messageboards.NoSuchCategoryException;
450    
451            /**
452            * Returns the first message boards category in the ordered set where groupId = &#63;.
453            *
454            * @param groupId the group ID
455            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
456            * @return the first matching message boards category, or <code>null</code> if a matching message boards category could not be found
457            * @throws SystemException if a system exception occurred
458            */
459            public com.liferay.portlet.messageboards.model.MBCategory fetchByGroupId_First(
460                    long groupId,
461                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
462                    throws com.liferay.portal.kernel.exception.SystemException;
463    
464            /**
465            * Returns the last message boards category in the ordered set where groupId = &#63;.
466            *
467            * @param groupId the group ID
468            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
469            * @return the last matching message boards category
470            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
471            * @throws SystemException if a system exception occurred
472            */
473            public com.liferay.portlet.messageboards.model.MBCategory findByGroupId_Last(
474                    long groupId,
475                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
476                    throws com.liferay.portal.kernel.exception.SystemException,
477                            com.liferay.portlet.messageboards.NoSuchCategoryException;
478    
479            /**
480            * Returns the last message boards category in the ordered set where groupId = &#63;.
481            *
482            * @param groupId the group ID
483            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
484            * @return the last matching message boards category, or <code>null</code> if a matching message boards category could not be found
485            * @throws SystemException if a system exception occurred
486            */
487            public com.liferay.portlet.messageboards.model.MBCategory fetchByGroupId_Last(
488                    long groupId,
489                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
490                    throws com.liferay.portal.kernel.exception.SystemException;
491    
492            /**
493            * Returns the message boards categories before and after the current message boards category in the ordered set where groupId = &#63;.
494            *
495            * @param categoryId the primary key of the current message boards category
496            * @param groupId the group ID
497            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
498            * @return the previous, current, and next message boards category
499            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
500            * @throws SystemException if a system exception occurred
501            */
502            public com.liferay.portlet.messageboards.model.MBCategory[] findByGroupId_PrevAndNext(
503                    long categoryId, long groupId,
504                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
505                    throws com.liferay.portal.kernel.exception.SystemException,
506                            com.liferay.portlet.messageboards.NoSuchCategoryException;
507    
508            /**
509            * Returns all the message boards categories that the user has permission to view where groupId = &#63;.
510            *
511            * @param groupId the group ID
512            * @return the matching message boards categories that the user has permission to view
513            * @throws SystemException if a system exception occurred
514            */
515            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByGroupId(
516                    long groupId)
517                    throws com.liferay.portal.kernel.exception.SystemException;
518    
519            /**
520            * Returns a range of all the message boards categories that the user has permission to view where groupId = &#63;.
521            *
522            * <p>
523            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
524            * </p>
525            *
526            * @param groupId the group ID
527            * @param start the lower bound of the range of message boards categories
528            * @param end the upper bound of the range of message boards categories (not inclusive)
529            * @return the range of matching message boards categories that the user has permission to view
530            * @throws SystemException if a system exception occurred
531            */
532            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByGroupId(
533                    long groupId, int start, int end)
534                    throws com.liferay.portal.kernel.exception.SystemException;
535    
536            /**
537            * Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = &#63;.
538            *
539            * <p>
540            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
541            * </p>
542            *
543            * @param groupId the group ID
544            * @param start the lower bound of the range of message boards categories
545            * @param end the upper bound of the range of message boards categories (not inclusive)
546            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
547            * @return the ordered range of matching message boards categories that the user has permission to view
548            * @throws SystemException if a system exception occurred
549            */
550            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByGroupId(
551                    long groupId, int start, int end,
552                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
553                    throws com.liferay.portal.kernel.exception.SystemException;
554    
555            /**
556            * 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 = &#63;.
557            *
558            * @param categoryId the primary key of the current message boards category
559            * @param groupId the group ID
560            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
561            * @return the previous, current, and next message boards category
562            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
563            * @throws SystemException if a system exception occurred
564            */
565            public com.liferay.portlet.messageboards.model.MBCategory[] filterFindByGroupId_PrevAndNext(
566                    long categoryId, long groupId,
567                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
568                    throws com.liferay.portal.kernel.exception.SystemException,
569                            com.liferay.portlet.messageboards.NoSuchCategoryException;
570    
571            /**
572            * Removes all the message boards categories where groupId = &#63; from the database.
573            *
574            * @param groupId the group ID
575            * @throws SystemException if a system exception occurred
576            */
577            public void removeByGroupId(long groupId)
578                    throws com.liferay.portal.kernel.exception.SystemException;
579    
580            /**
581            * Returns the number of message boards categories where groupId = &#63;.
582            *
583            * @param groupId the group ID
584            * @return the number of matching message boards categories
585            * @throws SystemException if a system exception occurred
586            */
587            public int countByGroupId(long groupId)
588                    throws com.liferay.portal.kernel.exception.SystemException;
589    
590            /**
591            * Returns the number of message boards categories that the user has permission to view where groupId = &#63;.
592            *
593            * @param groupId the group ID
594            * @return the number of matching message boards categories that the user has permission to view
595            * @throws SystemException if a system exception occurred
596            */
597            public int filterCountByGroupId(long groupId)
598                    throws com.liferay.portal.kernel.exception.SystemException;
599    
600            /**
601            * Returns all the message boards categories where companyId = &#63;.
602            *
603            * @param companyId the company ID
604            * @return the matching message boards categories
605            * @throws SystemException if a system exception occurred
606            */
607            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByCompanyId(
608                    long companyId)
609                    throws com.liferay.portal.kernel.exception.SystemException;
610    
611            /**
612            * Returns a range of all the message boards categories where companyId = &#63;.
613            *
614            * <p>
615            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
616            * </p>
617            *
618            * @param companyId the company ID
619            * @param start the lower bound of the range of message boards categories
620            * @param end the upper bound of the range of message boards categories (not inclusive)
621            * @return the range of matching message boards categories
622            * @throws SystemException if a system exception occurred
623            */
624            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByCompanyId(
625                    long companyId, int start, int end)
626                    throws com.liferay.portal.kernel.exception.SystemException;
627    
628            /**
629            * Returns an ordered range of all the message boards categories where companyId = &#63;.
630            *
631            * <p>
632            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
633            * </p>
634            *
635            * @param companyId the company ID
636            * @param start the lower bound of the range of message boards categories
637            * @param end the upper bound of the range of message boards categories (not inclusive)
638            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
639            * @return the ordered range of matching message boards categories
640            * @throws SystemException if a system exception occurred
641            */
642            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByCompanyId(
643                    long companyId, int start, int end,
644                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
645                    throws com.liferay.portal.kernel.exception.SystemException;
646    
647            /**
648            * Returns the first message boards category in the ordered set where companyId = &#63;.
649            *
650            * @param companyId the company ID
651            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
652            * @return the first matching message boards category
653            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
654            * @throws SystemException if a system exception occurred
655            */
656            public com.liferay.portlet.messageboards.model.MBCategory findByCompanyId_First(
657                    long companyId,
658                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
659                    throws com.liferay.portal.kernel.exception.SystemException,
660                            com.liferay.portlet.messageboards.NoSuchCategoryException;
661    
662            /**
663            * Returns the first message boards category in the ordered set where companyId = &#63;.
664            *
665            * @param companyId the company ID
666            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
667            * @return the first matching message boards category, or <code>null</code> if a matching message boards category could not be found
668            * @throws SystemException if a system exception occurred
669            */
670            public com.liferay.portlet.messageboards.model.MBCategory fetchByCompanyId_First(
671                    long companyId,
672                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
673                    throws com.liferay.portal.kernel.exception.SystemException;
674    
675            /**
676            * Returns the last message boards category in the ordered set where companyId = &#63;.
677            *
678            * @param companyId the company ID
679            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
680            * @return the last matching message boards category
681            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
682            * @throws SystemException if a system exception occurred
683            */
684            public com.liferay.portlet.messageboards.model.MBCategory findByCompanyId_Last(
685                    long companyId,
686                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
687                    throws com.liferay.portal.kernel.exception.SystemException,
688                            com.liferay.portlet.messageboards.NoSuchCategoryException;
689    
690            /**
691            * Returns the last message boards category in the ordered set where companyId = &#63;.
692            *
693            * @param companyId the company ID
694            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
695            * @return the last matching message boards category, or <code>null</code> if a matching message boards category could not be found
696            * @throws SystemException if a system exception occurred
697            */
698            public com.liferay.portlet.messageboards.model.MBCategory fetchByCompanyId_Last(
699                    long companyId,
700                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
701                    throws com.liferay.portal.kernel.exception.SystemException;
702    
703            /**
704            * Returns the message boards categories before and after the current message boards category in the ordered set where companyId = &#63;.
705            *
706            * @param categoryId the primary key of the current message boards category
707            * @param companyId the company ID
708            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
709            * @return the previous, current, and next message boards category
710            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
711            * @throws SystemException if a system exception occurred
712            */
713            public com.liferay.portlet.messageboards.model.MBCategory[] findByCompanyId_PrevAndNext(
714                    long categoryId, long companyId,
715                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
716                    throws com.liferay.portal.kernel.exception.SystemException,
717                            com.liferay.portlet.messageboards.NoSuchCategoryException;
718    
719            /**
720            * Removes all the message boards categories where companyId = &#63; from the database.
721            *
722            * @param companyId the company ID
723            * @throws SystemException if a system exception occurred
724            */
725            public void removeByCompanyId(long companyId)
726                    throws com.liferay.portal.kernel.exception.SystemException;
727    
728            /**
729            * Returns the number of message boards categories where companyId = &#63;.
730            *
731            * @param companyId the company ID
732            * @return the number of matching message boards categories
733            * @throws SystemException if a system exception occurred
734            */
735            public int countByCompanyId(long companyId)
736                    throws com.liferay.portal.kernel.exception.SystemException;
737    
738            /**
739            * Returns all the message boards categories where groupId = &#63; and parentCategoryId = &#63;.
740            *
741            * @param groupId the group ID
742            * @param parentCategoryId the parent category ID
743            * @return the matching message boards categories
744            * @throws SystemException if a system exception occurred
745            */
746            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P(
747                    long groupId, long parentCategoryId)
748                    throws com.liferay.portal.kernel.exception.SystemException;
749    
750            /**
751            * Returns a range of all the message boards categories where groupId = &#63; and parentCategoryId = &#63;.
752            *
753            * <p>
754            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
755            * </p>
756            *
757            * @param groupId the group ID
758            * @param parentCategoryId the parent category ID
759            * @param start the lower bound of the range of message boards categories
760            * @param end the upper bound of the range of message boards categories (not inclusive)
761            * @return the range of matching message boards categories
762            * @throws SystemException if a system exception occurred
763            */
764            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P(
765                    long groupId, long parentCategoryId, int start, int end)
766                    throws com.liferay.portal.kernel.exception.SystemException;
767    
768            /**
769            * Returns an ordered range of all the message boards categories where groupId = &#63; and parentCategoryId = &#63;.
770            *
771            * <p>
772            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
773            * </p>
774            *
775            * @param groupId the group ID
776            * @param parentCategoryId the parent category ID
777            * @param start the lower bound of the range of message boards categories
778            * @param end the upper bound of the range of message boards categories (not inclusive)
779            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
780            * @return the ordered range of matching message boards categories
781            * @throws SystemException if a system exception occurred
782            */
783            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P(
784                    long groupId, long parentCategoryId, int start, int end,
785                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
786                    throws com.liferay.portal.kernel.exception.SystemException;
787    
788            /**
789            * Returns the first message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63;.
790            *
791            * @param groupId the group ID
792            * @param parentCategoryId the parent category ID
793            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
794            * @return the first matching message boards category
795            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
796            * @throws SystemException if a system exception occurred
797            */
798            public com.liferay.portlet.messageboards.model.MBCategory findByG_P_First(
799                    long groupId, long parentCategoryId,
800                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
801                    throws com.liferay.portal.kernel.exception.SystemException,
802                            com.liferay.portlet.messageboards.NoSuchCategoryException;
803    
804            /**
805            * Returns the first message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63;.
806            *
807            * @param groupId the group ID
808            * @param parentCategoryId the parent category ID
809            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
810            * @return the first matching message boards category, or <code>null</code> if a matching message boards category could not be found
811            * @throws SystemException if a system exception occurred
812            */
813            public com.liferay.portlet.messageboards.model.MBCategory fetchByG_P_First(
814                    long groupId, long parentCategoryId,
815                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
816                    throws com.liferay.portal.kernel.exception.SystemException;
817    
818            /**
819            * Returns the last message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63;.
820            *
821            * @param groupId the group ID
822            * @param parentCategoryId the parent category ID
823            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
824            * @return the last matching message boards category
825            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
826            * @throws SystemException if a system exception occurred
827            */
828            public com.liferay.portlet.messageboards.model.MBCategory findByG_P_Last(
829                    long groupId, long parentCategoryId,
830                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
831                    throws com.liferay.portal.kernel.exception.SystemException,
832                            com.liferay.portlet.messageboards.NoSuchCategoryException;
833    
834            /**
835            * Returns the last message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63;.
836            *
837            * @param groupId the group ID
838            * @param parentCategoryId the parent category ID
839            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
840            * @return the last matching message boards category, or <code>null</code> if a matching message boards category could not be found
841            * @throws SystemException if a system exception occurred
842            */
843            public com.liferay.portlet.messageboards.model.MBCategory fetchByG_P_Last(
844                    long groupId, long parentCategoryId,
845                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
846                    throws com.liferay.portal.kernel.exception.SystemException;
847    
848            /**
849            * Returns the message boards categories before and after the current message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63;.
850            *
851            * @param categoryId the primary key of the current message boards category
852            * @param groupId the group ID
853            * @param parentCategoryId the parent category ID
854            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
855            * @return the previous, current, and next message boards category
856            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
857            * @throws SystemException if a system exception occurred
858            */
859            public com.liferay.portlet.messageboards.model.MBCategory[] findByG_P_PrevAndNext(
860                    long categoryId, long groupId, long parentCategoryId,
861                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
862                    throws com.liferay.portal.kernel.exception.SystemException,
863                            com.liferay.portlet.messageboards.NoSuchCategoryException;
864    
865            /**
866            * Returns all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = &#63;.
867            *
868            * @param groupId the group ID
869            * @param parentCategoryId the parent category ID
870            * @return the matching message boards categories that the user has permission to view
871            * @throws SystemException if a system exception occurred
872            */
873            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P(
874                    long groupId, long parentCategoryId)
875                    throws com.liferay.portal.kernel.exception.SystemException;
876    
877            /**
878            * Returns a range of all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = &#63;.
879            *
880            * <p>
881            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
882            * </p>
883            *
884            * @param groupId the group ID
885            * @param parentCategoryId the parent category ID
886            * @param start the lower bound of the range of message boards categories
887            * @param end the upper bound of the range of message boards categories (not inclusive)
888            * @return the range of matching message boards categories that the user has permission to view
889            * @throws SystemException if a system exception occurred
890            */
891            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P(
892                    long groupId, long parentCategoryId, int start, int end)
893                    throws com.liferay.portal.kernel.exception.SystemException;
894    
895            /**
896            * Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = &#63; and parentCategoryId = &#63;.
897            *
898            * <p>
899            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
900            * </p>
901            *
902            * @param groupId the group ID
903            * @param parentCategoryId the parent category ID
904            * @param start the lower bound of the range of message boards categories
905            * @param end the upper bound of the range of message boards categories (not inclusive)
906            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
907            * @return the ordered range of matching message boards categories that the user has permission to view
908            * @throws SystemException if a system exception occurred
909            */
910            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P(
911                    long groupId, long parentCategoryId, int start, int end,
912                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
913                    throws com.liferay.portal.kernel.exception.SystemException;
914    
915            /**
916            * 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 = &#63; and parentCategoryId = &#63;.
917            *
918            * @param categoryId the primary key of the current message boards category
919            * @param groupId the group ID
920            * @param parentCategoryId the parent category ID
921            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
922            * @return the previous, current, and next message boards category
923            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
924            * @throws SystemException if a system exception occurred
925            */
926            public com.liferay.portlet.messageboards.model.MBCategory[] filterFindByG_P_PrevAndNext(
927                    long categoryId, long groupId, long parentCategoryId,
928                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
929                    throws com.liferay.portal.kernel.exception.SystemException,
930                            com.liferay.portlet.messageboards.NoSuchCategoryException;
931    
932            /**
933            * Returns all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = any &#63;.
934            *
935            * @param groupId the group ID
936            * @param parentCategoryIds the parent category IDs
937            * @return the matching message boards categories that the user has permission to view
938            * @throws SystemException if a system exception occurred
939            */
940            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P(
941                    long groupId, long[] parentCategoryIds)
942                    throws com.liferay.portal.kernel.exception.SystemException;
943    
944            /**
945            * Returns a range of all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = any &#63;.
946            *
947            * <p>
948            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
949            * </p>
950            *
951            * @param groupId the group ID
952            * @param parentCategoryIds the parent category IDs
953            * @param start the lower bound of the range of message boards categories
954            * @param end the upper bound of the range of message boards categories (not inclusive)
955            * @return the range of matching message boards categories that the user has permission to view
956            * @throws SystemException if a system exception occurred
957            */
958            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P(
959                    long groupId, long[] parentCategoryIds, int start, int end)
960                    throws com.liferay.portal.kernel.exception.SystemException;
961    
962            /**
963            * Returns an ordered range of all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = any &#63;.
964            *
965            * <p>
966            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
967            * </p>
968            *
969            * @param groupId the group ID
970            * @param parentCategoryIds the parent category IDs
971            * @param start the lower bound of the range of message boards categories
972            * @param end the upper bound of the range of message boards categories (not inclusive)
973            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
974            * @return the ordered range of matching message boards categories that the user has permission to view
975            * @throws SystemException if a system exception occurred
976            */
977            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P(
978                    long groupId, long[] parentCategoryIds, int start, int end,
979                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
980                    throws com.liferay.portal.kernel.exception.SystemException;
981    
982            /**
983            * Returns all the message boards categories where groupId = &#63; and parentCategoryId = any &#63;.
984            *
985            * <p>
986            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
987            * </p>
988            *
989            * @param groupId the group ID
990            * @param parentCategoryIds the parent category IDs
991            * @return the matching message boards categories
992            * @throws SystemException if a system exception occurred
993            */
994            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P(
995                    long groupId, long[] parentCategoryIds)
996                    throws com.liferay.portal.kernel.exception.SystemException;
997    
998            /**
999            * Returns a range of all the message boards categories where groupId = &#63; and parentCategoryId = any &#63;.
1000            *
1001            * <p>
1002            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1003            * </p>
1004            *
1005            * @param groupId the group ID
1006            * @param parentCategoryIds the parent category IDs
1007            * @param start the lower bound of the range of message boards categories
1008            * @param end the upper bound of the range of message boards categories (not inclusive)
1009            * @return the range of matching message boards categories
1010            * @throws SystemException if a system exception occurred
1011            */
1012            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P(
1013                    long groupId, long[] parentCategoryIds, int start, int end)
1014                    throws com.liferay.portal.kernel.exception.SystemException;
1015    
1016            /**
1017            * Returns an ordered range of all the message boards categories where groupId = &#63; and parentCategoryId = any &#63;.
1018            *
1019            * <p>
1020            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1021            * </p>
1022            *
1023            * @param groupId the group ID
1024            * @param parentCategoryIds the parent category IDs
1025            * @param start the lower bound of the range of message boards categories
1026            * @param end the upper bound of the range of message boards categories (not inclusive)
1027            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
1028            * @return the ordered range of matching message boards categories
1029            * @throws SystemException if a system exception occurred
1030            */
1031            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P(
1032                    long groupId, long[] parentCategoryIds, int start, int end,
1033                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1034                    throws com.liferay.portal.kernel.exception.SystemException;
1035    
1036            /**
1037            * Removes all the message boards categories where groupId = &#63; and parentCategoryId = &#63; from the database.
1038            *
1039            * @param groupId the group ID
1040            * @param parentCategoryId the parent category ID
1041            * @throws SystemException if a system exception occurred
1042            */
1043            public void removeByG_P(long groupId, long parentCategoryId)
1044                    throws com.liferay.portal.kernel.exception.SystemException;
1045    
1046            /**
1047            * Returns the number of message boards categories where groupId = &#63; and parentCategoryId = &#63;.
1048            *
1049            * @param groupId the group ID
1050            * @param parentCategoryId the parent category ID
1051            * @return the number of matching message boards categories
1052            * @throws SystemException if a system exception occurred
1053            */
1054            public int countByG_P(long groupId, long parentCategoryId)
1055                    throws com.liferay.portal.kernel.exception.SystemException;
1056    
1057            /**
1058            * Returns the number of message boards categories where groupId = &#63; and parentCategoryId = any &#63;.
1059            *
1060            * @param groupId the group ID
1061            * @param parentCategoryIds the parent category IDs
1062            * @return the number of matching message boards categories
1063            * @throws SystemException if a system exception occurred
1064            */
1065            public int countByG_P(long groupId, long[] parentCategoryIds)
1066                    throws com.liferay.portal.kernel.exception.SystemException;
1067    
1068            /**
1069            * Returns the number of message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = &#63;.
1070            *
1071            * @param groupId the group ID
1072            * @param parentCategoryId the parent category ID
1073            * @return the number of matching message boards categories that the user has permission to view
1074            * @throws SystemException if a system exception occurred
1075            */
1076            public int filterCountByG_P(long groupId, long parentCategoryId)
1077                    throws com.liferay.portal.kernel.exception.SystemException;
1078    
1079            /**
1080            * Returns the number of message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = any &#63;.
1081            *
1082            * @param groupId the group ID
1083            * @param parentCategoryIds the parent category IDs
1084            * @return the number of matching message boards categories that the user has permission to view
1085            * @throws SystemException if a system exception occurred
1086            */
1087            public int filterCountByG_P(long groupId, long[] parentCategoryIds)
1088                    throws com.liferay.portal.kernel.exception.SystemException;
1089    
1090            /**
1091            * Returns all the message boards categories where groupId = &#63; and status = &#63;.
1092            *
1093            * @param groupId the group ID
1094            * @param status the status
1095            * @return the matching message boards categories
1096            * @throws SystemException if a system exception occurred
1097            */
1098            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_S(
1099                    long groupId, int status)
1100                    throws com.liferay.portal.kernel.exception.SystemException;
1101    
1102            /**
1103            * Returns a range of all the message boards categories where groupId = &#63; and status = &#63;.
1104            *
1105            * <p>
1106            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1107            * </p>
1108            *
1109            * @param groupId the group ID
1110            * @param status the status
1111            * @param start the lower bound of the range of message boards categories
1112            * @param end the upper bound of the range of message boards categories (not inclusive)
1113            * @return the range of matching message boards categories
1114            * @throws SystemException if a system exception occurred
1115            */
1116            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_S(
1117                    long groupId, int status, int start, int end)
1118                    throws com.liferay.portal.kernel.exception.SystemException;
1119    
1120            /**
1121            * Returns an ordered range of all the message boards categories where groupId = &#63; and status = &#63;.
1122            *
1123            * <p>
1124            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1125            * </p>
1126            *
1127            * @param groupId the group ID
1128            * @param status the status
1129            * @param start the lower bound of the range of message boards categories
1130            * @param end the upper bound of the range of message boards categories (not inclusive)
1131            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
1132            * @return the ordered range of matching message boards categories
1133            * @throws SystemException if a system exception occurred
1134            */
1135            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_S(
1136                    long groupId, int status, int start, int end,
1137                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1138                    throws com.liferay.portal.kernel.exception.SystemException;
1139    
1140            /**
1141            * Returns the first message boards category in the ordered set where groupId = &#63; and status = &#63;.
1142            *
1143            * @param groupId the group ID
1144            * @param status the status
1145            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1146            * @return the first matching message boards category
1147            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
1148            * @throws SystemException if a system exception occurred
1149            */
1150            public com.liferay.portlet.messageboards.model.MBCategory findByG_S_First(
1151                    long groupId, int status,
1152                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1153                    throws com.liferay.portal.kernel.exception.SystemException,
1154                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1155    
1156            /**
1157            * Returns the first message boards category in the ordered set where groupId = &#63; and status = &#63;.
1158            *
1159            * @param groupId the group ID
1160            * @param status the status
1161            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1162            * @return the first matching message boards category, or <code>null</code> if a matching message boards category could not be found
1163            * @throws SystemException if a system exception occurred
1164            */
1165            public com.liferay.portlet.messageboards.model.MBCategory fetchByG_S_First(
1166                    long groupId, int status,
1167                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1168                    throws com.liferay.portal.kernel.exception.SystemException;
1169    
1170            /**
1171            * Returns the last message boards category in the ordered set where groupId = &#63; and status = &#63;.
1172            *
1173            * @param groupId the group ID
1174            * @param status the status
1175            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1176            * @return the last matching message boards category
1177            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
1178            * @throws SystemException if a system exception occurred
1179            */
1180            public com.liferay.portlet.messageboards.model.MBCategory findByG_S_Last(
1181                    long groupId, int status,
1182                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1183                    throws com.liferay.portal.kernel.exception.SystemException,
1184                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1185    
1186            /**
1187            * Returns the last message boards category in the ordered set where groupId = &#63; and status = &#63;.
1188            *
1189            * @param groupId the group ID
1190            * @param status the status
1191            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1192            * @return the last matching message boards category, or <code>null</code> if a matching message boards category could not be found
1193            * @throws SystemException if a system exception occurred
1194            */
1195            public com.liferay.portlet.messageboards.model.MBCategory fetchByG_S_Last(
1196                    long groupId, int status,
1197                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1198                    throws com.liferay.portal.kernel.exception.SystemException;
1199    
1200            /**
1201            * Returns the message boards categories before and after the current message boards category in the ordered set where groupId = &#63; and status = &#63;.
1202            *
1203            * @param categoryId the primary key of the current message boards category
1204            * @param groupId the group ID
1205            * @param status the status
1206            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1207            * @return the previous, current, and next message boards category
1208            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
1209            * @throws SystemException if a system exception occurred
1210            */
1211            public com.liferay.portlet.messageboards.model.MBCategory[] findByG_S_PrevAndNext(
1212                    long categoryId, long groupId, int status,
1213                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1214                    throws com.liferay.portal.kernel.exception.SystemException,
1215                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1216    
1217            /**
1218            * Returns all the message boards categories that the user has permission to view where groupId = &#63; and status = &#63;.
1219            *
1220            * @param groupId the group ID
1221            * @param status the status
1222            * @return the matching message boards categories that the user has permission to view
1223            * @throws SystemException if a system exception occurred
1224            */
1225            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_S(
1226                    long groupId, int status)
1227                    throws com.liferay.portal.kernel.exception.SystemException;
1228    
1229            /**
1230            * Returns a range of all the message boards categories that the user has permission to view where groupId = &#63; and status = &#63;.
1231            *
1232            * <p>
1233            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1234            * </p>
1235            *
1236            * @param groupId the group ID
1237            * @param status the status
1238            * @param start the lower bound of the range of message boards categories
1239            * @param end the upper bound of the range of message boards categories (not inclusive)
1240            * @return the range of matching message boards categories that the user has permission to view
1241            * @throws SystemException if a system exception occurred
1242            */
1243            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_S(
1244                    long groupId, int status, int start, int end)
1245                    throws com.liferay.portal.kernel.exception.SystemException;
1246    
1247            /**
1248            * Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = &#63; and status = &#63;.
1249            *
1250            * <p>
1251            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1252            * </p>
1253            *
1254            * @param groupId the group ID
1255            * @param status the status
1256            * @param start the lower bound of the range of message boards categories
1257            * @param end the upper bound of the range of message boards categories (not inclusive)
1258            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
1259            * @return the ordered range of matching message boards categories that the user has permission to view
1260            * @throws SystemException if a system exception occurred
1261            */
1262            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_S(
1263                    long groupId, int status, int start, int end,
1264                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1265                    throws com.liferay.portal.kernel.exception.SystemException;
1266    
1267            /**
1268            * 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 = &#63; and status = &#63;.
1269            *
1270            * @param categoryId the primary key of the current message boards category
1271            * @param groupId the group ID
1272            * @param status the status
1273            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1274            * @return the previous, current, and next message boards category
1275            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
1276            * @throws SystemException if a system exception occurred
1277            */
1278            public com.liferay.portlet.messageboards.model.MBCategory[] filterFindByG_S_PrevAndNext(
1279                    long categoryId, long groupId, int status,
1280                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1281                    throws com.liferay.portal.kernel.exception.SystemException,
1282                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1283    
1284            /**
1285            * Removes all the message boards categories where groupId = &#63; and status = &#63; from the database.
1286            *
1287            * @param groupId the group ID
1288            * @param status the status
1289            * @throws SystemException if a system exception occurred
1290            */
1291            public void removeByG_S(long groupId, int status)
1292                    throws com.liferay.portal.kernel.exception.SystemException;
1293    
1294            /**
1295            * Returns the number of message boards categories where groupId = &#63; and status = &#63;.
1296            *
1297            * @param groupId the group ID
1298            * @param status the status
1299            * @return the number of matching message boards categories
1300            * @throws SystemException if a system exception occurred
1301            */
1302            public int countByG_S(long groupId, int status)
1303                    throws com.liferay.portal.kernel.exception.SystemException;
1304    
1305            /**
1306            * Returns the number of message boards categories that the user has permission to view where groupId = &#63; and status = &#63;.
1307            *
1308            * @param groupId the group ID
1309            * @param status the status
1310            * @return the number of matching message boards categories that the user has permission to view
1311            * @throws SystemException if a system exception occurred
1312            */
1313            public int filterCountByG_S(long groupId, int status)
1314                    throws com.liferay.portal.kernel.exception.SystemException;
1315    
1316            /**
1317            * Returns all the message boards categories where companyId = &#63; and status = &#63;.
1318            *
1319            * @param companyId the company ID
1320            * @param status the status
1321            * @return the matching message boards categories
1322            * @throws SystemException if a system exception occurred
1323            */
1324            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByC_S(
1325                    long companyId, int status)
1326                    throws com.liferay.portal.kernel.exception.SystemException;
1327    
1328            /**
1329            * Returns a range of all the message boards categories where companyId = &#63; and status = &#63;.
1330            *
1331            * <p>
1332            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1333            * </p>
1334            *
1335            * @param companyId the company ID
1336            * @param status the status
1337            * @param start the lower bound of the range of message boards categories
1338            * @param end the upper bound of the range of message boards categories (not inclusive)
1339            * @return the range of matching message boards categories
1340            * @throws SystemException if a system exception occurred
1341            */
1342            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByC_S(
1343                    long companyId, int status, int start, int end)
1344                    throws com.liferay.portal.kernel.exception.SystemException;
1345    
1346            /**
1347            * Returns an ordered range of all the message boards categories where companyId = &#63; and status = &#63;.
1348            *
1349            * <p>
1350            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1351            * </p>
1352            *
1353            * @param companyId the company ID
1354            * @param status the status
1355            * @param start the lower bound of the range of message boards categories
1356            * @param end the upper bound of the range of message boards categories (not inclusive)
1357            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
1358            * @return the ordered range of matching message boards categories
1359            * @throws SystemException if a system exception occurred
1360            */
1361            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByC_S(
1362                    long companyId, int status, int start, int end,
1363                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1364                    throws com.liferay.portal.kernel.exception.SystemException;
1365    
1366            /**
1367            * Returns the first message boards category in the ordered set where companyId = &#63; and status = &#63;.
1368            *
1369            * @param companyId the company ID
1370            * @param status the status
1371            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1372            * @return the first matching message boards category
1373            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
1374            * @throws SystemException if a system exception occurred
1375            */
1376            public com.liferay.portlet.messageboards.model.MBCategory findByC_S_First(
1377                    long companyId, int status,
1378                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1379                    throws com.liferay.portal.kernel.exception.SystemException,
1380                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1381    
1382            /**
1383            * Returns the first message boards category in the ordered set where companyId = &#63; and status = &#63;.
1384            *
1385            * @param companyId the company ID
1386            * @param status the status
1387            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1388            * @return the first matching message boards category, or <code>null</code> if a matching message boards category could not be found
1389            * @throws SystemException if a system exception occurred
1390            */
1391            public com.liferay.portlet.messageboards.model.MBCategory fetchByC_S_First(
1392                    long companyId, int status,
1393                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1394                    throws com.liferay.portal.kernel.exception.SystemException;
1395    
1396            /**
1397            * Returns the last message boards category in the ordered set where companyId = &#63; and status = &#63;.
1398            *
1399            * @param companyId the company ID
1400            * @param status the status
1401            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1402            * @return the last matching message boards category
1403            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
1404            * @throws SystemException if a system exception occurred
1405            */
1406            public com.liferay.portlet.messageboards.model.MBCategory findByC_S_Last(
1407                    long companyId, int status,
1408                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1409                    throws com.liferay.portal.kernel.exception.SystemException,
1410                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1411    
1412            /**
1413            * Returns the last message boards category in the ordered set where companyId = &#63; and status = &#63;.
1414            *
1415            * @param companyId the company ID
1416            * @param status the status
1417            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1418            * @return the last matching message boards category, or <code>null</code> if a matching message boards category could not be found
1419            * @throws SystemException if a system exception occurred
1420            */
1421            public com.liferay.portlet.messageboards.model.MBCategory fetchByC_S_Last(
1422                    long companyId, int status,
1423                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1424                    throws com.liferay.portal.kernel.exception.SystemException;
1425    
1426            /**
1427            * Returns the message boards categories before and after the current message boards category in the ordered set where companyId = &#63; and status = &#63;.
1428            *
1429            * @param categoryId the primary key of the current message boards category
1430            * @param companyId the company ID
1431            * @param status the status
1432            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1433            * @return the previous, current, and next message boards category
1434            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
1435            * @throws SystemException if a system exception occurred
1436            */
1437            public com.liferay.portlet.messageboards.model.MBCategory[] findByC_S_PrevAndNext(
1438                    long categoryId, long companyId, int status,
1439                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1440                    throws com.liferay.portal.kernel.exception.SystemException,
1441                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1442    
1443            /**
1444            * Removes all the message boards categories where companyId = &#63; and status = &#63; from the database.
1445            *
1446            * @param companyId the company ID
1447            * @param status the status
1448            * @throws SystemException if a system exception occurred
1449            */
1450            public void removeByC_S(long companyId, int status)
1451                    throws com.liferay.portal.kernel.exception.SystemException;
1452    
1453            /**
1454            * Returns the number of message boards categories where companyId = &#63; and status = &#63;.
1455            *
1456            * @param companyId the company ID
1457            * @param status the status
1458            * @return the number of matching message boards categories
1459            * @throws SystemException if a system exception occurred
1460            */
1461            public int countByC_S(long companyId, int status)
1462                    throws com.liferay.portal.kernel.exception.SystemException;
1463    
1464            /**
1465            * Returns all the message boards categories where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1466            *
1467            * @param groupId the group ID
1468            * @param parentCategoryId the parent category ID
1469            * @param status the status
1470            * @return the matching message boards categories
1471            * @throws SystemException if a system exception occurred
1472            */
1473            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P_S(
1474                    long groupId, long parentCategoryId, int status)
1475                    throws com.liferay.portal.kernel.exception.SystemException;
1476    
1477            /**
1478            * Returns a range of all the message boards categories where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1479            *
1480            * <p>
1481            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1482            * </p>
1483            *
1484            * @param groupId the group ID
1485            * @param parentCategoryId the parent category ID
1486            * @param status the status
1487            * @param start the lower bound of the range of message boards categories
1488            * @param end the upper bound of the range of message boards categories (not inclusive)
1489            * @return the range of matching message boards categories
1490            * @throws SystemException if a system exception occurred
1491            */
1492            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P_S(
1493                    long groupId, long parentCategoryId, int status, int start, int end)
1494                    throws com.liferay.portal.kernel.exception.SystemException;
1495    
1496            /**
1497            * Returns an ordered range of all the message boards categories where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1498            *
1499            * <p>
1500            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1501            * </p>
1502            *
1503            * @param groupId the group ID
1504            * @param parentCategoryId the parent category ID
1505            * @param status the status
1506            * @param start the lower bound of the range of message boards categories
1507            * @param end the upper bound of the range of message boards categories (not inclusive)
1508            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
1509            * @return the ordered range of matching message boards categories
1510            * @throws SystemException if a system exception occurred
1511            */
1512            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P_S(
1513                    long groupId, long parentCategoryId, int status, int start, int end,
1514                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1515                    throws com.liferay.portal.kernel.exception.SystemException;
1516    
1517            /**
1518            * Returns the first message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1519            *
1520            * @param groupId the group ID
1521            * @param parentCategoryId the parent category ID
1522            * @param status the status
1523            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1524            * @return the first matching message boards category
1525            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
1526            * @throws SystemException if a system exception occurred
1527            */
1528            public com.liferay.portlet.messageboards.model.MBCategory findByG_P_S_First(
1529                    long groupId, long parentCategoryId, int status,
1530                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1531                    throws com.liferay.portal.kernel.exception.SystemException,
1532                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1533    
1534            /**
1535            * Returns the first message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1536            *
1537            * @param groupId the group ID
1538            * @param parentCategoryId the parent category ID
1539            * @param status the status
1540            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1541            * @return the first matching message boards category, or <code>null</code> if a matching message boards category could not be found
1542            * @throws SystemException if a system exception occurred
1543            */
1544            public com.liferay.portlet.messageboards.model.MBCategory fetchByG_P_S_First(
1545                    long groupId, long parentCategoryId, int status,
1546                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1547                    throws com.liferay.portal.kernel.exception.SystemException;
1548    
1549            /**
1550            * Returns the last message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1551            *
1552            * @param groupId the group ID
1553            * @param parentCategoryId the parent category ID
1554            * @param status the status
1555            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1556            * @return the last matching message boards category
1557            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a matching message boards category could not be found
1558            * @throws SystemException if a system exception occurred
1559            */
1560            public com.liferay.portlet.messageboards.model.MBCategory findByG_P_S_Last(
1561                    long groupId, long parentCategoryId, int status,
1562                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1563                    throws com.liferay.portal.kernel.exception.SystemException,
1564                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1565    
1566            /**
1567            * Returns the last message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1568            *
1569            * @param groupId the group ID
1570            * @param parentCategoryId the parent category ID
1571            * @param status the status
1572            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1573            * @return the last matching message boards category, or <code>null</code> if a matching message boards category could not be found
1574            * @throws SystemException if a system exception occurred
1575            */
1576            public com.liferay.portlet.messageboards.model.MBCategory fetchByG_P_S_Last(
1577                    long groupId, long parentCategoryId, int status,
1578                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1579                    throws com.liferay.portal.kernel.exception.SystemException;
1580    
1581            /**
1582            * Returns the message boards categories before and after the current message boards category in the ordered set where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1583            *
1584            * @param categoryId the primary key of the current message boards category
1585            * @param groupId the group ID
1586            * @param parentCategoryId the parent category ID
1587            * @param status the status
1588            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1589            * @return the previous, current, and next message boards category
1590            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
1591            * @throws SystemException if a system exception occurred
1592            */
1593            public com.liferay.portlet.messageboards.model.MBCategory[] findByG_P_S_PrevAndNext(
1594                    long categoryId, long groupId, long parentCategoryId, int status,
1595                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1596                    throws com.liferay.portal.kernel.exception.SystemException,
1597                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1598    
1599            /**
1600            * Returns all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1601            *
1602            * @param groupId the group ID
1603            * @param parentCategoryId the parent category ID
1604            * @param status the status
1605            * @return the matching message boards categories that the user has permission to view
1606            * @throws SystemException if a system exception occurred
1607            */
1608            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P_S(
1609                    long groupId, long parentCategoryId, int status)
1610                    throws com.liferay.portal.kernel.exception.SystemException;
1611    
1612            /**
1613            * Returns a range of all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1614            *
1615            * <p>
1616            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1617            * </p>
1618            *
1619            * @param groupId the group ID
1620            * @param parentCategoryId the parent category ID
1621            * @param status the status
1622            * @param start the lower bound of the range of message boards categories
1623            * @param end the upper bound of the range of message boards categories (not inclusive)
1624            * @return the range of matching message boards categories that the user has permission to view
1625            * @throws SystemException if a system exception occurred
1626            */
1627            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P_S(
1628                    long groupId, long parentCategoryId, int status, int start, int end)
1629                    throws com.liferay.portal.kernel.exception.SystemException;
1630    
1631            /**
1632            * Returns an ordered range of all the message boards categories that the user has permissions to view where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1633            *
1634            * <p>
1635            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1636            * </p>
1637            *
1638            * @param groupId the group ID
1639            * @param parentCategoryId the parent category ID
1640            * @param status the status
1641            * @param start the lower bound of the range of message boards categories
1642            * @param end the upper bound of the range of message boards categories (not inclusive)
1643            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
1644            * @return the ordered range of matching message boards categories that the user has permission to view
1645            * @throws SystemException if a system exception occurred
1646            */
1647            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P_S(
1648                    long groupId, long parentCategoryId, int status, int start, int end,
1649                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1650                    throws com.liferay.portal.kernel.exception.SystemException;
1651    
1652            /**
1653            * 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 = &#63; and parentCategoryId = &#63; and status = &#63;.
1654            *
1655            * @param categoryId the primary key of the current message boards category
1656            * @param groupId the group ID
1657            * @param parentCategoryId the parent category ID
1658            * @param status the status
1659            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
1660            * @return the previous, current, and next message boards category
1661            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
1662            * @throws SystemException if a system exception occurred
1663            */
1664            public com.liferay.portlet.messageboards.model.MBCategory[] filterFindByG_P_S_PrevAndNext(
1665                    long categoryId, long groupId, long parentCategoryId, int status,
1666                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1667                    throws com.liferay.portal.kernel.exception.SystemException,
1668                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1669    
1670            /**
1671            * Returns all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = any &#63; and status = &#63;.
1672            *
1673            * @param groupId the group ID
1674            * @param parentCategoryIds the parent category IDs
1675            * @param status the status
1676            * @return the matching message boards categories that the user has permission to view
1677            * @throws SystemException if a system exception occurred
1678            */
1679            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P_S(
1680                    long groupId, long[] parentCategoryIds, int status)
1681                    throws com.liferay.portal.kernel.exception.SystemException;
1682    
1683            /**
1684            * Returns a range of all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = any &#63; and status = &#63;.
1685            *
1686            * <p>
1687            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1688            * </p>
1689            *
1690            * @param groupId the group ID
1691            * @param parentCategoryIds the parent category IDs
1692            * @param status the status
1693            * @param start the lower bound of the range of message boards categories
1694            * @param end the upper bound of the range of message boards categories (not inclusive)
1695            * @return the range of matching message boards categories that the user has permission to view
1696            * @throws SystemException if a system exception occurred
1697            */
1698            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P_S(
1699                    long groupId, long[] parentCategoryIds, int status, int start, int end)
1700                    throws com.liferay.portal.kernel.exception.SystemException;
1701    
1702            /**
1703            * Returns an ordered range of all the message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = any &#63; and status = &#63;.
1704            *
1705            * <p>
1706            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1707            * </p>
1708            *
1709            * @param groupId the group ID
1710            * @param parentCategoryIds the parent category IDs
1711            * @param status the status
1712            * @param start the lower bound of the range of message boards categories
1713            * @param end the upper bound of the range of message boards categories (not inclusive)
1714            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
1715            * @return the ordered range of matching message boards categories that the user has permission to view
1716            * @throws SystemException if a system exception occurred
1717            */
1718            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> filterFindByG_P_S(
1719                    long groupId, long[] parentCategoryIds, int status, int start, int end,
1720                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1721                    throws com.liferay.portal.kernel.exception.SystemException;
1722    
1723            /**
1724            * Returns all the message boards categories where groupId = &#63; and parentCategoryId = any &#63; and status = &#63;.
1725            *
1726            * <p>
1727            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1728            * </p>
1729            *
1730            * @param groupId the group ID
1731            * @param parentCategoryIds the parent category IDs
1732            * @param status the status
1733            * @return the matching message boards categories
1734            * @throws SystemException if a system exception occurred
1735            */
1736            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P_S(
1737                    long groupId, long[] parentCategoryIds, int status)
1738                    throws com.liferay.portal.kernel.exception.SystemException;
1739    
1740            /**
1741            * Returns a range of all the message boards categories where groupId = &#63; and parentCategoryId = any &#63; and status = &#63;.
1742            *
1743            * <p>
1744            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1745            * </p>
1746            *
1747            * @param groupId the group ID
1748            * @param parentCategoryIds the parent category IDs
1749            * @param status the status
1750            * @param start the lower bound of the range of message boards categories
1751            * @param end the upper bound of the range of message boards categories (not inclusive)
1752            * @return the range of matching message boards categories
1753            * @throws SystemException if a system exception occurred
1754            */
1755            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P_S(
1756                    long groupId, long[] parentCategoryIds, int status, int start, int end)
1757                    throws com.liferay.portal.kernel.exception.SystemException;
1758    
1759            /**
1760            * Returns an ordered range of all the message boards categories where groupId = &#63; and parentCategoryId = any &#63; and status = &#63;.
1761            *
1762            * <p>
1763            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1764            * </p>
1765            *
1766            * @param groupId the group ID
1767            * @param parentCategoryIds the parent category IDs
1768            * @param status the status
1769            * @param start the lower bound of the range of message boards categories
1770            * @param end the upper bound of the range of message boards categories (not inclusive)
1771            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
1772            * @return the ordered range of matching message boards categories
1773            * @throws SystemException if a system exception occurred
1774            */
1775            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findByG_P_S(
1776                    long groupId, long[] parentCategoryIds, int status, int start, int end,
1777                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1778                    throws com.liferay.portal.kernel.exception.SystemException;
1779    
1780            /**
1781            * Removes all the message boards categories where groupId = &#63; and parentCategoryId = &#63; and status = &#63; from the database.
1782            *
1783            * @param groupId the group ID
1784            * @param parentCategoryId the parent category ID
1785            * @param status the status
1786            * @throws SystemException if a system exception occurred
1787            */
1788            public void removeByG_P_S(long groupId, long parentCategoryId, int status)
1789                    throws com.liferay.portal.kernel.exception.SystemException;
1790    
1791            /**
1792            * Returns the number of message boards categories where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1793            *
1794            * @param groupId the group ID
1795            * @param parentCategoryId the parent category ID
1796            * @param status the status
1797            * @return the number of matching message boards categories
1798            * @throws SystemException if a system exception occurred
1799            */
1800            public int countByG_P_S(long groupId, long parentCategoryId, int status)
1801                    throws com.liferay.portal.kernel.exception.SystemException;
1802    
1803            /**
1804            * Returns the number of message boards categories where groupId = &#63; and parentCategoryId = any &#63; and status = &#63;.
1805            *
1806            * @param groupId the group ID
1807            * @param parentCategoryIds the parent category IDs
1808            * @param status the status
1809            * @return the number of matching message boards categories
1810            * @throws SystemException if a system exception occurred
1811            */
1812            public int countByG_P_S(long groupId, long[] parentCategoryIds, int status)
1813                    throws com.liferay.portal.kernel.exception.SystemException;
1814    
1815            /**
1816            * Returns the number of message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = &#63; and status = &#63;.
1817            *
1818            * @param groupId the group ID
1819            * @param parentCategoryId the parent category ID
1820            * @param status the status
1821            * @return the number of matching message boards categories that the user has permission to view
1822            * @throws SystemException if a system exception occurred
1823            */
1824            public int filterCountByG_P_S(long groupId, long parentCategoryId,
1825                    int status) throws com.liferay.portal.kernel.exception.SystemException;
1826    
1827            /**
1828            * Returns the number of message boards categories that the user has permission to view where groupId = &#63; and parentCategoryId = any &#63; and status = &#63;.
1829            *
1830            * @param groupId the group ID
1831            * @param parentCategoryIds the parent category IDs
1832            * @param status the status
1833            * @return the number of matching message boards categories that the user has permission to view
1834            * @throws SystemException if a system exception occurred
1835            */
1836            public int filterCountByG_P_S(long groupId, long[] parentCategoryIds,
1837                    int status) throws com.liferay.portal.kernel.exception.SystemException;
1838    
1839            /**
1840            * Caches the message boards category in the entity cache if it is enabled.
1841            *
1842            * @param mbCategory the message boards category
1843            */
1844            public void cacheResult(
1845                    com.liferay.portlet.messageboards.model.MBCategory mbCategory);
1846    
1847            /**
1848            * Caches the message boards categories in the entity cache if it is enabled.
1849            *
1850            * @param mbCategories the message boards categories
1851            */
1852            public void cacheResult(
1853                    java.util.List<com.liferay.portlet.messageboards.model.MBCategory> mbCategories);
1854    
1855            /**
1856            * Creates a new message boards category with the primary key. Does not add the message boards category to the database.
1857            *
1858            * @param categoryId the primary key for the new message boards category
1859            * @return the new message boards category
1860            */
1861            public com.liferay.portlet.messageboards.model.MBCategory create(
1862                    long categoryId);
1863    
1864            /**
1865            * Removes the message boards category with the primary key from the database. Also notifies the appropriate model listeners.
1866            *
1867            * @param categoryId the primary key of the message boards category
1868            * @return the message boards category that was removed
1869            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
1870            * @throws SystemException if a system exception occurred
1871            */
1872            public com.liferay.portlet.messageboards.model.MBCategory remove(
1873                    long categoryId)
1874                    throws com.liferay.portal.kernel.exception.SystemException,
1875                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1876    
1877            public com.liferay.portlet.messageboards.model.MBCategory updateImpl(
1878                    com.liferay.portlet.messageboards.model.MBCategory mbCategory)
1879                    throws com.liferay.portal.kernel.exception.SystemException;
1880    
1881            /**
1882            * Returns the message boards category with the primary key or throws a {@link com.liferay.portlet.messageboards.NoSuchCategoryException} if it could not be found.
1883            *
1884            * @param categoryId the primary key of the message boards category
1885            * @return the message boards category
1886            * @throws com.liferay.portlet.messageboards.NoSuchCategoryException if a message boards category with the primary key could not be found
1887            * @throws SystemException if a system exception occurred
1888            */
1889            public com.liferay.portlet.messageboards.model.MBCategory findByPrimaryKey(
1890                    long categoryId)
1891                    throws com.liferay.portal.kernel.exception.SystemException,
1892                            com.liferay.portlet.messageboards.NoSuchCategoryException;
1893    
1894            /**
1895            * Returns the message boards category with the primary key or returns <code>null</code> if it could not be found.
1896            *
1897            * @param categoryId the primary key of the message boards category
1898            * @return the message boards category, or <code>null</code> if a message boards category with the primary key could not be found
1899            * @throws SystemException if a system exception occurred
1900            */
1901            public com.liferay.portlet.messageboards.model.MBCategory fetchByPrimaryKey(
1902                    long categoryId)
1903                    throws com.liferay.portal.kernel.exception.SystemException;
1904    
1905            /**
1906            * Returns all the message boards categories.
1907            *
1908            * @return the message boards categories
1909            * @throws SystemException if a system exception occurred
1910            */
1911            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findAll()
1912                    throws com.liferay.portal.kernel.exception.SystemException;
1913    
1914            /**
1915            * Returns a range of all the message boards categories.
1916            *
1917            * <p>
1918            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1919            * </p>
1920            *
1921            * @param start the lower bound of the range of message boards categories
1922            * @param end the upper bound of the range of message boards categories (not inclusive)
1923            * @return the range of message boards categories
1924            * @throws SystemException if a system exception occurred
1925            */
1926            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findAll(
1927                    int start, int end)
1928                    throws com.liferay.portal.kernel.exception.SystemException;
1929    
1930            /**
1931            * Returns an ordered range of all the message boards categories.
1932            *
1933            * <p>
1934            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.messageboards.model.impl.MBCategoryModelImpl}. If both <code>orderByComparator</code> 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.
1935            * </p>
1936            *
1937            * @param start the lower bound of the range of message boards categories
1938            * @param end the upper bound of the range of message boards categories (not inclusive)
1939            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
1940            * @return the ordered range of message boards categories
1941            * @throws SystemException if a system exception occurred
1942            */
1943            public java.util.List<com.liferay.portlet.messageboards.model.MBCategory> findAll(
1944                    int start, int end,
1945                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
1946                    throws com.liferay.portal.kernel.exception.SystemException;
1947    
1948            /**
1949            * Removes all the message boards categories from the database.
1950            *
1951            * @throws SystemException if a system exception occurred
1952            */
1953            public void removeAll()
1954                    throws com.liferay.portal.kernel.exception.SystemException;
1955    
1956            /**
1957            * Returns the number of message boards categories.
1958            *
1959            * @return the number of message boards categories
1960            * @throws SystemException if a system exception occurred
1961            */
1962            public int countAll()
1963                    throws com.liferay.portal.kernel.exception.SystemException;
1964    }