com.liferay.portlet.expando.service.persistence
Interface ExpandoColumnPersistence

All Superinterfaces:

BasePersistence<ExpandoColumn>

public interface ExpandoColumnPersistence
extends BasePersistence<ExpandoColumn>

The persistence interface for the expando column service.

Caching information and settings can be found in portal.properties

See Also:

ExpandoColumnPersistenceImpl, ExpandoColumnUtil

Method Summary

void	cacheResult(ExpandoColumn expandoColumn) Caches the expando column in the entity cache if it is enabled.
void	cacheResult(List<ExpandoColumn> expandoColumns) Caches the expando columns in the entity cache if it is enabled.
int	countAll() Returns the number of expando columns.
int	countByT_N(long tableId, String name) Returns the number of expando columns where tableId = ? and name = ?.
int	countByT_N(long tableId, String[] names) Returns the number of expando columns where tableId = ? and name = any ?.
int	countByTableId(long tableId) Returns the number of expando columns where tableId = ?.
ExpandoColumn	create(long columnId) Creates a new expando column with the primary key.
ExpandoColumn	fetchByPrimaryKey(long columnId) Returns the expando column with the primary key or returns null if it could not be found.
ExpandoColumn	fetchByT_N_First(long tableId, String name, OrderByComparator orderByComparator) Returns the first expando column in the ordered set where tableId = ? and name = ?.
ExpandoColumn	fetchByT_N_Last(long tableId, String name, OrderByComparator orderByComparator) Returns the last expando column in the ordered set where tableId = ? and name = ?.
ExpandoColumn	fetchByTableId_First(long tableId, OrderByComparator orderByComparator) Returns the first expando column in the ordered set where tableId = ?.
ExpandoColumn	fetchByTableId_Last(long tableId, OrderByComparator orderByComparator) Returns the last expando column in the ordered set where tableId = ?.
int	filterCountByT_N(long tableId, String name) Returns the number of expando columns that the user has permission to view where tableId = ? and name = ?.
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 ?.
int	filterCountByTableId(long tableId) Returns the number of expando columns that the user has permission to view where tableId = ?.
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 = ?.
List<ExpandoColumn>	filterFindByT_N(long tableId, String name) Returns all the expando columns that the user has permission to view where tableId = ? and name = ?.
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 ?.
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 ?.
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 ?.
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 = ?.
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 = ?.
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 = ?.
List<ExpandoColumn>	filterFindByTableId(long tableId) Returns all the expando columns that the user has permission to view where tableId = ?.
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 = ?.
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 = ?.
List<ExpandoColumn>	findAll() Returns all the expando columns.
List<ExpandoColumn>	findAll(int start, int end) Returns a range of all the expando columns.
List<ExpandoColumn>	findAll(int start, int end, OrderByComparator orderByComparator) Returns an ordered range of all the expando columns.
ExpandoColumn	findByPrimaryKey(long columnId) Returns the expando column with the primary key or throws a NoSuchColumnException if it could not be found.
ExpandoColumn	findByT_N_First(long tableId, String name, OrderByComparator orderByComparator) Returns the first expando column in the ordered set where tableId = ? and name = ?.
ExpandoColumn	findByT_N_Last(long tableId, String name, OrderByComparator orderByComparator) Returns the last expando column in the ordered set where tableId = ? and name = ?.
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 = ?.
List<ExpandoColumn>	findByT_N(long tableId, String name) Returns all the expando columns where tableId = ? and name = ?.
List<ExpandoColumn>	findByT_N(long tableId, String[] names) Returns all the expando columns where tableId = ? and name = any ?.
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 ?.
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 ?.
List<ExpandoColumn>	findByT_N(long tableId, String name, int start, int end) Returns a range of all the expando columns where tableId = ? and name = ?.
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 = ?.
ExpandoColumn	findByTableId_First(long tableId, OrderByComparator orderByComparator) Returns the first expando column in the ordered set where tableId = ?.
ExpandoColumn	findByTableId_Last(long tableId, OrderByComparator orderByComparator) Returns the last expando column in the ordered set where tableId = ?.
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 = ?.
List<ExpandoColumn>	findByTableId(long tableId) Returns all the expando columns where tableId = ?.
List<ExpandoColumn>	findByTableId(long tableId, int start, int end) Returns a range of all the expando columns where tableId = ?.
List<ExpandoColumn>	findByTableId(long tableId, int start, int end, OrderByComparator orderByComparator) Returns an ordered range of all the expando columns where tableId = ?.
ExpandoColumn	remove(long columnId) Removes the expando column with the primary key from the database.
void	removeAll() Removes all the expando columns from the database.
void	removeByT_N(long tableId, String name) Removes all the expando columns where tableId = ? and name = ? from the database.
void	removeByTableId(long tableId) Removes all the expando columns where tableId = ? from the database.
ExpandoColumn	updateImpl(ExpandoColumn expandoColumn, boolean merge)

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

clearCache, clearCache, clearCache, closeSession, countWithDynamicQuery, fetchByPrimaryKey, findByPrimaryKey, findWithDynamicQuery, findWithDynamicQuery, findWithDynamicQuery, getDataSource, getListeners, openSession, processException, registerListener, remove, remove, setDataSource, unregisterListener, update, update

Method Detail

cacheResult

void cacheResult(ExpandoColumn expandoColumn)

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

Parameters:

expandoColumn - the expando column

cacheResult

void cacheResult(List<ExpandoColumn> expandoColumns)

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

Parameters:

expandoColumns - the expando columns

create

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

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

ExpandoColumn updateImpl(ExpandoColumn expandoColumn,
                         boolean merge)
                         throws SystemException

Throws:

SystemException

findByPrimaryKey

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

List<ExpandoColumn> findAll()
                            throws SystemException

Returns all the expando columns.

Returns:

the expando columns

Throws:

SystemException - if a system exception occurred

findAll

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

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

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

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

void removeAll()
               throws SystemException

Removes all the expando columns from the database.

Throws:

SystemException - if a system exception occurred

countByTableId

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

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

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

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

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

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

int countAll()
             throws SystemException

Returns the number of expando columns.

Returns:

the number of expando columns

Throws:

SystemException - if a system exception occurred