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