com.liferay.portlet.expando.service.persistence
Class ExpandoColumnUtil

java.lang.Object
  com.liferay.portlet.expando.service.persistence.ExpandoColumnUtil

public class ExpandoColumnUtil
extends Object

The persistence utility for the expando column service. This utility wraps ExpandoColumnPersistenceImpl and provides direct access to the database for CRUD operations. This utility should only be used by the service layer, as it must operate within a transaction. Never access this utility in a JSP, controller, model, or other front-end class.

Caching information and settings can be found in portal.properties

See Also:

ExpandoColumnPersistence, ExpandoColumnPersistenceImpl

Constructor Summary

ExpandoColumnUtil()

Method Summary

static void	cacheResult(ExpandoColumn expandoColumn) Caches the expando column in the entity cache if it is enabled.
static void	cacheResult(List<ExpandoColumn> expandoColumns) Caches the expando columns in the entity cache if it is enabled.
static void	clearCache()
static void	clearCache(ExpandoColumn expandoColumn)
static int	countAll() Returns the number of expando columns.
static int	countByT_N(long tableId, String name) Returns the number of expando columns where tableId = ? and name = ?.
static int	countByT_N(long tableId, String[] names) Returns the number of expando columns where tableId = ? and name = any ?.
static int	countByTableId(long tableId) Returns the number of expando columns where tableId = ?.
long	countWithDynamicQuery(DynamicQuery dynamicQuery)
static ExpandoColumn	create(long columnId) Creates a new expando column with the primary key.
static ExpandoColumn	fetchByPrimaryKey(long columnId) Returns the expando column with the primary key or returns null if it could not be found.
static ExpandoColumn	fetchByT_N_First(long tableId, String name, OrderByComparator orderByComparator) Returns the first expando column in the ordered set where tableId = ? and name = ?.
static ExpandoColumn	fetchByT_N_Last(long tableId, String name, OrderByComparator orderByComparator) Returns the last expando column in the ordered set where tableId = ? and name = ?.
static ExpandoColumn	fetchByTableId_First(long tableId, OrderByComparator orderByComparator) Returns the first expando column in the ordered set where tableId = ?.
static ExpandoColumn	fetchByTableId_Last(long tableId, OrderByComparator orderByComparator) Returns the last expando column in the ordered set where tableId = ?.
static int	filterCountByT_N(long tableId, String name) Returns the number of expando columns that the user has permission to view where tableId = ? and name = ?.
static int	filterCountByT_N(long tableId, String[] names) Returns the number of expando columns that the user has permission to view where tableId = ? and name = any ?.
static int	filterCountByTableId(long tableId) Returns the number of expando columns that the user has permission to view where tableId = ?.
static ExpandoColumn[]	filterFindByT_N_PrevAndNext(long columnId, long tableId, String name, OrderByComparator orderByComparator) Returns the expando columns before and after the current expando column in the ordered set of expando columns that the user has permission to view where tableId = ? and name = ?.
static List<ExpandoColumn>	filterFindByT_N(long tableId, String name) Returns all the expando columns that the user has permission to view where tableId = ? and name = ?.
static List<ExpandoColumn>	filterFindByT_N(long tableId, String[] names) Returns all the expando columns that the user has permission to view where tableId = ? and name = any ?.
static List<ExpandoColumn>	filterFindByT_N(long tableId, String[] names, int start, int end) Returns a range of all the expando columns that the user has permission to view where tableId = ? and name = any ?.
static List<ExpandoColumn>	filterFindByT_N(long tableId, String[] names, int start, int end, OrderByComparator orderByComparator) Returns an ordered range of all the expando columns that the user has permission to view where tableId = ? and name = any ?.
static List<ExpandoColumn>	filterFindByT_N(long tableId, String name, int start, int end) Returns a range of all the expando columns that the user has permission to view where tableId = ? and name = ?.
static List<ExpandoColumn>	filterFindByT_N(long tableId, String name, int start, int end, OrderByComparator orderByComparator) Returns an ordered range of all the expando columns that the user has permissions to view where tableId = ? and name = ?.
static ExpandoColumn[]	filterFindByTableId_PrevAndNext(long columnId, long tableId, OrderByComparator orderByComparator) Returns the expando columns before and after the current expando column in the ordered set of expando columns that the user has permission to view where tableId = ?.
static List<ExpandoColumn>	filterFindByTableId(long tableId) Returns all the expando columns that the user has permission to view where tableId = ?.
static List<ExpandoColumn>	filterFindByTableId(long tableId, int start, int end) Returns a range of all the expando columns that the user has permission to view where tableId = ?.
static List<ExpandoColumn>	filterFindByTableId(long tableId, int start, int end, OrderByComparator orderByComparator) Returns an ordered range of all the expando columns that the user has permissions to view where tableId = ?.
static List<ExpandoColumn>	findAll() Returns all the expando columns.
static List<ExpandoColumn>	findAll(int start, int end) Returns a range of all the expando columns.
static List<ExpandoColumn>	findAll(int start, int end, OrderByComparator orderByComparator) Returns an ordered range of all the expando columns.
static ExpandoColumn	findByPrimaryKey(long columnId) Returns the expando column with the primary key or throws a NoSuchColumnException if it could not be found.
static ExpandoColumn	findByT_N_First(long tableId, String name, OrderByComparator orderByComparator) Returns the first expando column in the ordered set where tableId = ? and name = ?.
static ExpandoColumn	findByT_N_Last(long tableId, String name, OrderByComparator orderByComparator) Returns the last expando column in the ordered set where tableId = ? and name = ?.
static ExpandoColumn[]	findByT_N_PrevAndNext(long columnId, long tableId, String name, OrderByComparator orderByComparator) Returns the expando columns before and after the current expando column in the ordered set where tableId = ? and name = ?.
static List<ExpandoColumn>	findByT_N(long tableId, String name) Returns all the expando columns where tableId = ? and name = ?.
static List<ExpandoColumn>	findByT_N(long tableId, String[] names) Returns all the expando columns where tableId = ? and name = any ?.
static List<ExpandoColumn>	findByT_N(long tableId, String[] names, int start, int end) Returns a range of all the expando columns where tableId = ? and name = any ?.
static List<ExpandoColumn>	findByT_N(long tableId, String[] names, int start, int end, OrderByComparator orderByComparator) Returns an ordered range of all the expando columns where tableId = ? and name = any ?.
static List<ExpandoColumn>	findByT_N(long tableId, String name, int start, int end) Returns a range of all the expando columns where tableId = ? and name = ?.
static List<ExpandoColumn>	findByT_N(long tableId, String name, int start, int end, OrderByComparator orderByComparator) Returns an ordered range of all the expando columns where tableId = ? and name = ?.
static ExpandoColumn	findByTableId_First(long tableId, OrderByComparator orderByComparator) Returns the first expando column in the ordered set where tableId = ?.
static ExpandoColumn	findByTableId_Last(long tableId, OrderByComparator orderByComparator) Returns the last expando column in the ordered set where tableId = ?.
static ExpandoColumn[]	findByTableId_PrevAndNext(long columnId, long tableId, OrderByComparator orderByComparator) Returns the expando columns before and after the current expando column in the ordered set where tableId = ?.
static List<ExpandoColumn>	findByTableId(long tableId) Returns all the expando columns where tableId = ?.
static List<ExpandoColumn>	findByTableId(long tableId, int start, int end) Returns a range of all the expando columns where tableId = ?.
static List<ExpandoColumn>	findByTableId(long tableId, int start, int end, OrderByComparator orderByComparator) Returns an ordered range of all the expando columns where tableId = ?.
static List<ExpandoColumn>	findWithDynamicQuery(DynamicQuery dynamicQuery)
static List<ExpandoColumn>	findWithDynamicQuery(DynamicQuery dynamicQuery, int start, int end)
static List<ExpandoColumn>	findWithDynamicQuery(DynamicQuery dynamicQuery, int start, int end, OrderByComparator orderByComparator)
static ExpandoColumnPersistence	getPersistence()
static ExpandoColumn	remove(long columnId) Removes the expando column with the primary key from the database.
static void	removeAll() Removes all the expando columns from the database.
static void	removeByT_N(long tableId, String name) Removes all the expando columns where tableId = ? and name = ? from the database.
static void	removeByTableId(long tableId) Removes all the expando columns where tableId = ? from the database.
void	setPersistence(ExpandoColumnPersistence persistence) Deprecated.
static ExpandoColumn	update(ExpandoColumn expandoColumn, boolean merge)
static ExpandoColumn	update(ExpandoColumn expandoColumn, boolean merge, ServiceContext serviceContext)
static ExpandoColumn	updateImpl(ExpandoColumn expandoColumn, boolean merge)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ExpandoColumnUtil

public ExpandoColumnUtil()

Method Detail

clearCache

public static void clearCache()

See Also:

BasePersistence.clearCache()

clearCache

public static void clearCache(ExpandoColumn expandoColumn)

See Also:

BasePersistence.clearCache(com.liferay.portal.model.BaseModel)

countWithDynamicQuery

public long countWithDynamicQuery(DynamicQuery dynamicQuery)
                           throws SystemException

Throws:

SystemException

See Also:

BasePersistence.countWithDynamicQuery(DynamicQuery)

findWithDynamicQuery

public static List<ExpandoColumn> findWithDynamicQuery(DynamicQuery dynamicQuery)
                                                throws SystemException

Throws:

SystemException

See Also:

BasePersistence.findWithDynamicQuery(DynamicQuery)

findWithDynamicQuery

public static List<ExpandoColumn> findWithDynamicQuery(DynamicQuery dynamicQuery,
                                                       int start,
                                                       int end)
                                                throws SystemException

Throws:

SystemException

See Also:

BasePersistence.findWithDynamicQuery(DynamicQuery, int, int)

findWithDynamicQuery

public static List<ExpandoColumn> findWithDynamicQuery(DynamicQuery dynamicQuery,
                                                       int start,
                                                       int end,
                                                       OrderByComparator orderByComparator)
                                                throws SystemException

Throws:

SystemException

See Also:

BasePersistence.findWithDynamicQuery(DynamicQuery, int, int, OrderByComparator)

update

public static ExpandoColumn update(ExpandoColumn expandoColumn,
                                   boolean merge)
                            throws SystemException

Throws:

SystemException

See Also:

BasePersistence.update(com.liferay.portal.model.BaseModel, boolean)

update

public static ExpandoColumn update(ExpandoColumn expandoColumn,
                                   boolean merge,
                                   ServiceContext serviceContext)
                            throws SystemException

Throws:

SystemException

See Also:

BasePersistence.update(com.liferay.portal.model.BaseModel, boolean, ServiceContext)

cacheResult

public static void cacheResult(ExpandoColumn expandoColumn)

Caches the expando column in the entity cache if it is enabled.

Parameters:

expandoColumn - the expando column

cacheResult

public static void cacheResult(List<ExpandoColumn> expandoColumns)

Caches the expando columns in the entity cache if it is enabled.

Parameters:

expandoColumns - the expando columns

create

public static ExpandoColumn create(long columnId)

Creates a new expando column with the primary key. Does not add the expando column to the database.

Parameters:

columnId - the primary key for the new expando column

Returns:

the new expando column

remove

public static ExpandoColumn remove(long columnId)
                            throws SystemException,
                                   NoSuchColumnException

Removes the expando column with the primary key from the database. Also notifies the appropriate model listeners.

Parameters:

columnId - the primary key of the expando column

Returns:

the expando column that was removed

Throws:

NoSuchColumnException - if a expando column with the primary key could not be found

SystemException - if a system exception occurred

updateImpl

public static ExpandoColumn updateImpl(ExpandoColumn expandoColumn,
                                       boolean merge)
                                throws SystemException

Throws:

SystemException

findByPrimaryKey

public static ExpandoColumn findByPrimaryKey(long columnId)
                                      throws SystemException,
                                             NoSuchColumnException

Returns the expando column with the primary key or throws a NoSuchColumnException if it could not be found.

Parameters:

columnId - the primary key of the expando column

Returns:

the expando column

Throws:

NoSuchColumnException - if a expando column with the primary key could not be found

SystemException - if a system exception occurred

fetchByPrimaryKey

public static ExpandoColumn fetchByPrimaryKey(long columnId)
                                       throws SystemException

Returns the expando column with the primary key or returns null if it could not be found.

Parameters:

columnId - the primary key of the expando column

Returns:

the expando column, or null if a expando column with the primary key could not be found

Throws:

SystemException - if a system exception occurred

findByTableId

public static List<ExpandoColumn> findByTableId(long tableId)
                                         throws SystemException

Returns all the expando columns where tableId = ?.

Parameters:

tableId - the table ID

Returns:

the matching expando columns

Throws:

SystemException - if a system exception occurred

findByTableId

public static List<ExpandoColumn> findByTableId(long tableId,
                                                int start,
                                                int end)
                                         throws SystemException

Returns a range of all the expando columns where tableId = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

Returns:

the range of matching expando columns

Throws:

SystemException - if a system exception occurred

findByTableId

public static List<ExpandoColumn> findByTableId(long tableId,
                                                int start,
                                                int end,
                                                OrderByComparator orderByComparator)
                                         throws SystemException

Returns an ordered range of all the expando columns where tableId = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

orderByComparator - the comparator to order the results by (optionally null)

Returns:

the ordered range of matching expando columns

Throws:

SystemException - if a system exception occurred

findByTableId_First

public static ExpandoColumn findByTableId_First(long tableId,
                                                OrderByComparator orderByComparator)
                                         throws SystemException,
                                                NoSuchColumnException

Returns the first expando column in the ordered set where tableId = ?.

Parameters:

tableId - the table ID

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the first matching expando column

Throws:

NoSuchColumnException - if a matching expando column could not be found

SystemException - if a system exception occurred

fetchByTableId_First

public static ExpandoColumn fetchByTableId_First(long tableId,
                                                 OrderByComparator orderByComparator)
                                          throws SystemException

Returns the first expando column in the ordered set where tableId = ?.

Parameters:

tableId - the table ID

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the first matching expando column, or null if a matching expando column could not be found

Throws:

SystemException - if a system exception occurred

findByTableId_Last

public static ExpandoColumn findByTableId_Last(long tableId,
                                               OrderByComparator orderByComparator)
                                        throws SystemException,
                                               NoSuchColumnException

Returns the last expando column in the ordered set where tableId = ?.

Parameters:

tableId - the table ID

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the last matching expando column

Throws:

NoSuchColumnException - if a matching expando column could not be found

SystemException - if a system exception occurred

fetchByTableId_Last

public static ExpandoColumn fetchByTableId_Last(long tableId,
                                                OrderByComparator orderByComparator)
                                         throws SystemException

Returns the last expando column in the ordered set where tableId = ?.

Parameters:

tableId - the table ID

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the last matching expando column, or null if a matching expando column could not be found

Throws:

SystemException - if a system exception occurred

findByTableId_PrevAndNext

public static ExpandoColumn[] findByTableId_PrevAndNext(long columnId,
                                                        long tableId,
                                                        OrderByComparator orderByComparator)
                                                 throws SystemException,
                                                        NoSuchColumnException

Returns the expando columns before and after the current expando column in the ordered set where tableId = ?.

Parameters:

columnId - the primary key of the current expando column

tableId - the table ID

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the previous, current, and next expando column

Throws:

NoSuchColumnException - if a expando column with the primary key could not be found

SystemException - if a system exception occurred

filterFindByTableId

public static List<ExpandoColumn> filterFindByTableId(long tableId)
                                               throws SystemException

Returns all the expando columns that the user has permission to view where tableId = ?.

Parameters:

tableId - the table ID

Returns:

the matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

filterFindByTableId

public static List<ExpandoColumn> filterFindByTableId(long tableId,
                                                      int start,
                                                      int end)
                                               throws SystemException

Returns a range of all the expando columns that the user has permission to view where tableId = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

Returns:

the range of matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

filterFindByTableId

public static List<ExpandoColumn> filterFindByTableId(long tableId,
                                                      int start,
                                                      int end,
                                                      OrderByComparator orderByComparator)
                                               throws SystemException

Returns an ordered range of all the expando columns that the user has permissions to view where tableId = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

orderByComparator - the comparator to order the results by (optionally null)

Returns:

the ordered range of matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

filterFindByTableId_PrevAndNext

public static ExpandoColumn[] filterFindByTableId_PrevAndNext(long columnId,
                                                              long tableId,
                                                              OrderByComparator orderByComparator)
                                                       throws SystemException,
                                                              NoSuchColumnException

Returns the expando columns before and after the current expando column in the ordered set of expando columns that the user has permission to view where tableId = ?.

Parameters:

columnId - the primary key of the current expando column

tableId - the table ID

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the previous, current, and next expando column

Throws:

NoSuchColumnException - if a expando column with the primary key could not be found

SystemException - if a system exception occurred

findByT_N

public static List<ExpandoColumn> findByT_N(long tableId,
                                            String name)
                                     throws SystemException

Returns all the expando columns where tableId = ? and name = ?.

Parameters:

tableId - the table ID

name - the name

Returns:

the matching expando columns

Throws:

SystemException - if a system exception occurred

findByT_N

public static List<ExpandoColumn> findByT_N(long tableId,
                                            String name,
                                            int start,
                                            int end)
                                     throws SystemException

Returns a range of all the expando columns where tableId = ? and name = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

name - the name

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

Returns:

the range of matching expando columns

Throws:

SystemException - if a system exception occurred

findByT_N

public static List<ExpandoColumn> findByT_N(long tableId,
                                            String name,
                                            int start,
                                            int end,
                                            OrderByComparator orderByComparator)
                                     throws SystemException

Returns an ordered range of all the expando columns where tableId = ? and name = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

name - the name

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

orderByComparator - the comparator to order the results by (optionally null)

Returns:

the ordered range of matching expando columns

Throws:

SystemException - if a system exception occurred

findByT_N_First

public static ExpandoColumn findByT_N_First(long tableId,
                                            String name,
                                            OrderByComparator orderByComparator)
                                     throws SystemException,
                                            NoSuchColumnException

Returns the first expando column in the ordered set where tableId = ? and name = ?.

Parameters:

tableId - the table ID

name - the name

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the first matching expando column

Throws:

NoSuchColumnException - if a matching expando column could not be found

SystemException - if a system exception occurred

fetchByT_N_First

public static ExpandoColumn fetchByT_N_First(long tableId,
                                             String name,
                                             OrderByComparator orderByComparator)
                                      throws SystemException

Returns the first expando column in the ordered set where tableId = ? and name = ?.

Parameters:

tableId - the table ID

name - the name

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the first matching expando column, or null if a matching expando column could not be found

Throws:

SystemException - if a system exception occurred

findByT_N_Last

public static ExpandoColumn findByT_N_Last(long tableId,
                                           String name,
                                           OrderByComparator orderByComparator)
                                    throws SystemException,
                                           NoSuchColumnException

Returns the last expando column in the ordered set where tableId = ? and name = ?.

Parameters:

tableId - the table ID

name - the name

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the last matching expando column

Throws:

NoSuchColumnException - if a matching expando column could not be found

SystemException - if a system exception occurred

fetchByT_N_Last

public static ExpandoColumn fetchByT_N_Last(long tableId,
                                            String name,
                                            OrderByComparator orderByComparator)
                                     throws SystemException

Returns the last expando column in the ordered set where tableId = ? and name = ?.

Parameters:

tableId - the table ID

name - the name

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the last matching expando column, or null if a matching expando column could not be found

Throws:

SystemException - if a system exception occurred

findByT_N_PrevAndNext

public static ExpandoColumn[] findByT_N_PrevAndNext(long columnId,
                                                    long tableId,
                                                    String name,
                                                    OrderByComparator orderByComparator)
                                             throws SystemException,
                                                    NoSuchColumnException

Returns the expando columns before and after the current expando column in the ordered set where tableId = ? and name = ?.

Parameters:

columnId - the primary key of the current expando column

tableId - the table ID

name - the name

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the previous, current, and next expando column

Throws:

NoSuchColumnException - if a expando column with the primary key could not be found

SystemException - if a system exception occurred

findByT_N

public static List<ExpandoColumn> findByT_N(long tableId,
                                            String[] names)
                                     throws SystemException

Returns all the expando columns where tableId = ? and name = any ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

names - the names

Returns:

the matching expando columns

Throws:

SystemException - if a system exception occurred

findByT_N

public static List<ExpandoColumn> findByT_N(long tableId,
                                            String[] names,
                                            int start,
                                            int end)
                                     throws SystemException

Returns a range of all the expando columns where tableId = ? and name = any ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

names - the names

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

Returns:

the range of matching expando columns

Throws:

SystemException - if a system exception occurred

findByT_N

public static List<ExpandoColumn> findByT_N(long tableId,
                                            String[] names,
                                            int start,
                                            int end,
                                            OrderByComparator orderByComparator)
                                     throws SystemException

Returns an ordered range of all the expando columns where tableId = ? and name = any ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

names - the names

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

orderByComparator - the comparator to order the results by (optionally null)

Returns:

the ordered range of matching expando columns

Throws:

SystemException - if a system exception occurred

filterFindByT_N

public static List<ExpandoColumn> filterFindByT_N(long tableId,
                                                  String name)
                                           throws SystemException

Returns all the expando columns that the user has permission to view where tableId = ? and name = ?.

Parameters:

tableId - the table ID

name - the name

Returns:

the matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

filterFindByT_N

public static List<ExpandoColumn> filterFindByT_N(long tableId,
                                                  String name,
                                                  int start,
                                                  int end)
                                           throws SystemException

Returns a range of all the expando columns that the user has permission to view where tableId = ? and name = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

name - the name

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

Returns:

the range of matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

filterFindByT_N

public static List<ExpandoColumn> filterFindByT_N(long tableId,
                                                  String name,
                                                  int start,
                                                  int end,
                                                  OrderByComparator orderByComparator)
                                           throws SystemException

Returns an ordered range of all the expando columns that the user has permissions to view where tableId = ? and name = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

name - the name

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

orderByComparator - the comparator to order the results by (optionally null)

Returns:

the ordered range of matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

filterFindByT_N_PrevAndNext

public static ExpandoColumn[] filterFindByT_N_PrevAndNext(long columnId,
                                                          long tableId,
                                                          String name,
                                                          OrderByComparator orderByComparator)
                                                   throws SystemException,
                                                          NoSuchColumnException

Returns the expando columns before and after the current expando column in the ordered set of expando columns that the user has permission to view where tableId = ? and name = ?.

Parameters:

columnId - the primary key of the current expando column

tableId - the table ID

name - the name

orderByComparator - the comparator to order the set by (optionally null)

Returns:

the previous, current, and next expando column

Throws:

NoSuchColumnException - if a expando column with the primary key could not be found

SystemException - if a system exception occurred

filterFindByT_N

public static List<ExpandoColumn> filterFindByT_N(long tableId,
                                                  String[] names)
                                           throws SystemException

Returns all the expando columns that the user has permission to view where tableId = ? and name = any ?.

Parameters:

tableId - the table ID

names - the names

Returns:

the matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

filterFindByT_N

public static List<ExpandoColumn> filterFindByT_N(long tableId,
                                                  String[] names,
                                                  int start,
                                                  int end)
                                           throws SystemException

Returns a range of all the expando columns that the user has permission to view where tableId = ? and name = any ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

names - the names

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

Returns:

the range of matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

filterFindByT_N

public static List<ExpandoColumn> filterFindByT_N(long tableId,
                                                  String[] names,
                                                  int start,
                                                  int end,
                                                  OrderByComparator orderByComparator)
                                           throws SystemException

Returns an ordered range of all the expando columns that the user has permission to view where tableId = ? and name = any ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

tableId - the table ID

names - the names

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

orderByComparator - the comparator to order the results by (optionally null)

Returns:

the ordered range of matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

findAll

public static List<ExpandoColumn> findAll()
                                   throws SystemException

Returns all the expando columns.

Returns:

the expando columns

Throws:

SystemException - if a system exception occurred

findAll

public static List<ExpandoColumn> findAll(int start,
                                          int end)
                                   throws SystemException

Returns a range of all the expando columns.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

Returns:

the range of expando columns

Throws:

SystemException - if a system exception occurred

findAll

public static List<ExpandoColumn> findAll(int start,
                                          int end,
                                          OrderByComparator orderByComparator)
                                   throws SystemException

Returns an ordered range of all the expando columns.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:

start - the lower bound of the range of expando columns

end - the upper bound of the range of expando columns (not inclusive)

orderByComparator - the comparator to order the results by (optionally null)

Returns:

the ordered range of expando columns

Throws:

SystemException - if a system exception occurred

removeByTableId

public static void removeByTableId(long tableId)
                            throws SystemException

Removes all the expando columns where tableId = ? from the database.

Parameters:

tableId - the table ID

Throws:

SystemException - if a system exception occurred

removeByT_N

public static void removeByT_N(long tableId,
                               String name)
                        throws SystemException

Removes all the expando columns where tableId = ? and name = ? from the database.

Parameters:

tableId - the table ID

name - the name

Throws:

SystemException - if a system exception occurred

removeAll

public static void removeAll()
                      throws SystemException

Removes all the expando columns from the database.

Throws:

SystemException - if a system exception occurred

countByTableId

public static int countByTableId(long tableId)
                          throws SystemException

Returns the number of expando columns where tableId = ?.

Parameters:

tableId - the table ID

Returns:

the number of matching expando columns

Throws:

SystemException - if a system exception occurred

filterCountByTableId

public static int filterCountByTableId(long tableId)
                                throws SystemException

Returns the number of expando columns that the user has permission to view where tableId = ?.

Parameters:

tableId - the table ID

Returns:

the number of matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

countByT_N

public static int countByT_N(long tableId,
                             String name)
                      throws SystemException

Returns the number of expando columns where tableId = ? and name = ?.

Parameters:

tableId - the table ID

name - the name

Returns:

the number of matching expando columns

Throws:

SystemException - if a system exception occurred

countByT_N

public static int countByT_N(long tableId,
                             String[] names)
                      throws SystemException

Returns the number of expando columns where tableId = ? and name = any ?.

Parameters:

tableId - the table ID

names - the names

Returns:

the number of matching expando columns

Throws:

SystemException - if a system exception occurred

filterCountByT_N

public static int filterCountByT_N(long tableId,
                                   String name)
                            throws SystemException

Returns the number of expando columns that the user has permission to view where tableId = ? and name = ?.

Parameters:

tableId - the table ID

name - the name

Returns:

the number of matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

filterCountByT_N

public static int filterCountByT_N(long tableId,
                                   String[] names)
                            throws SystemException

Returns the number of expando columns that the user has permission to view where tableId = ? and name = any ?.

Parameters:

tableId - the table ID

names - the names

Returns:

the number of matching expando columns that the user has permission to view

Throws:

SystemException - if a system exception occurred

countAll

public static int countAll()
                    throws SystemException

Returns the number of expando columns.

Returns:

the number of expando columns

Throws:

SystemException - if a system exception occurred

getPersistence

public static ExpandoColumnPersistence getPersistence()

setPersistence

public void setPersistence(ExpandoColumnPersistence persistence)

Deprecated.