Class ExpandoColumnUtil
com.liferay.portlet.expando.service.persistence.impl.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
- Author:
- Brian Wing Shun Chan
- See Also:
- {$generated.description}
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic voidcacheResult(ExpandoColumn expandoColumn) Caches the expando column in the entity cache if it is enabled.static voidcacheResult(List<ExpandoColumn> expandoColumns) Caches the expando columns in the entity cache if it is enabled.static voidstatic voidclearCache(ExpandoColumn expandoColumn) static intcountAll()Returns the number of expando columns.static intcountByT_N(long tableId, String name) Returns the number of expando columns where tableId = ? and name = ?.static intcountByT_N(long tableId, String[] names) Returns the number of expando columns where tableId = ? and name = any ?.static intcountByTableId(long tableId) Returns the number of expando columns where tableId = ?.static longcountWithDynamicQuery(DynamicQuery dynamicQuery) static ExpandoColumncreate(long columnId) Creates a new expando column with the primary key.static ExpandoColumnfetchByPrimaryKey(long columnId) Returns the expando column with the primary key or returnsnullif it could not be found.static Map<Serializable,ExpandoColumn> fetchByPrimaryKeys(Set<Serializable> primaryKeys) static ExpandoColumnfetchByT_N(long tableId, String name) Returns the expando column where tableId = ? and name = ? or returnsnullif it could not be found.static ExpandoColumnfetchByT_N(long tableId, String name, boolean useFinderCache) Returns the expando column where tableId = ? and name = ? or returnsnullif it could not be found, optionally using the finder cache.static ExpandoColumnfetchByTableId_First(long tableId, OrderByComparator<ExpandoColumn> orderByComparator) Returns the first expando column in the ordered set where tableId = ?.static ExpandoColumnfetchByTableId_Last(long tableId, OrderByComparator<ExpandoColumn> orderByComparator) Returns the last expando column in the ordered set where tableId = ?.static intfilterCountByT_N(long tableId, String name) Returns the number of expando columns that the user has permission to view where tableId = ? and name = ?.static intfilterCountByT_N(long tableId, String[] names) Returns the number of expando columns that the user has permission to view where tableId = ? and name = any ?.static intfilterCountByTableId(long tableId) Returns the number 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<ExpandoColumn> orderByComparator) Returns an ordered range of all the expando columns that the user has permissions to view where tableId = ?.static ExpandoColumn[]filterFindByTableId_PrevAndNext(long columnId, long tableId, OrderByComparator<ExpandoColumn> 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>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<ExpandoColumn> orderByComparator) Returns an ordered range of all the expando columns.static List<ExpandoColumn>findAll(int start, int end, OrderByComparator<ExpandoColumn> orderByComparator, boolean useFinderCache) Returns an ordered range of all the expando columns.static ExpandoColumnfindByPrimaryKey(long columnId) Returns the expando column with the primary key or throws aNoSuchColumnExceptionif it could not be found.static ExpandoColumnReturns the expando column where tableId = ? and name = ? or throws aNoSuchColumnExceptionif it could not be found.static List<ExpandoColumn>Returns all the expando columns where tableId = ? and name = any ?.static List<ExpandoColumn>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<ExpandoColumn> orderByComparator) Returns an ordered 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<ExpandoColumn> orderByComparator, boolean useFinderCache) Returns an ordered range of all the expando columns where tableId = ? and name = ?, optionally using the finder cache.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<ExpandoColumn> orderByComparator) Returns an ordered range of all the expando columns where tableId = ?.static List<ExpandoColumn>findByTableId(long tableId, int start, int end, OrderByComparator<ExpandoColumn> orderByComparator, boolean useFinderCache) Returns an ordered range of all the expando columns where tableId = ?.static ExpandoColumnfindByTableId_First(long tableId, OrderByComparator<ExpandoColumn> orderByComparator) Returns the first expando column in the ordered set where tableId = ?.static ExpandoColumnfindByTableId_Last(long tableId, OrderByComparator<ExpandoColumn> orderByComparator) Returns the last expando column in the ordered set where tableId = ?.static ExpandoColumn[]findByTableId_PrevAndNext(long columnId, long tableId, OrderByComparator<ExpandoColumn> orderByComparator) Returns the expando columns before and after the current expando column in the ordered set 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<ExpandoColumn> orderByComparator) static ExpandoColumnPersistencestatic ExpandoColumnremove(long columnId) Removes the expando column with the primary key from the database.static voidRemoves all the expando columns from the database.static ExpandoColumnremoveByT_N(long tableId, String name) Removes the expando column where tableId = ? and name = ? from the database.static voidremoveByTableId(long tableId) Removes all the expando columns where tableId = ? from the database.static voidsetPersistence(ExpandoColumnPersistence persistence) static ExpandoColumnupdate(ExpandoColumn expandoColumn) static ExpandoColumnupdate(ExpandoColumn expandoColumn, ServiceContext serviceContext) static ExpandoColumnupdateImpl(ExpandoColumn expandoColumn)
-
Constructor Details
-
ExpandoColumnUtil
public ExpandoColumnUtil()
-
-
Method Details
-
clearCache
public static void clearCache()- See Also:
-
clearCache
-
countWithDynamicQuery
-
fetchByPrimaryKeys
- See Also:
-
findWithDynamicQuery
-
findWithDynamicQuery
public static List<ExpandoColumn> findWithDynamicQuery(DynamicQuery dynamicQuery, int start, int end) -
findWithDynamicQuery
public static List<ExpandoColumn> findWithDynamicQuery(DynamicQuery dynamicQuery, int start, int end, OrderByComparator<ExpandoColumn> orderByComparator) -
update
-
update
-
findByTableId
Returns all the expando columns where tableId = ?.- Parameters:
tableId- the table ID- Returns:
- the matching expando columns
-
findByTableId
Returns a range of all the expando columns where tableId = ?.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
tableId- the table IDstart- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)- Returns:
- the range of matching expando columns
-
findByTableId
public static List<ExpandoColumn> findByTableId(long tableId, int start, int end, OrderByComparator<ExpandoColumn> orderByComparator) Returns an ordered range of all the expando columns where tableId = ?.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
tableId- the table IDstart- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)orderByComparator- the comparator to order the results by (optionallynull)- Returns:
- the ordered range of matching expando columns
-
findByTableId
public static List<ExpandoColumn> findByTableId(long tableId, int start, int end, OrderByComparator<ExpandoColumn> orderByComparator, boolean useFinderCache) Returns an ordered range of all the expando columns where tableId = ?.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
tableId- the table IDstart- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)orderByComparator- the comparator to order the results by (optionallynull)useFinderCache- whether to use the finder cache- Returns:
- the ordered range of matching expando columns
-
findByTableId_First
public static ExpandoColumn findByTableId_First(long tableId, OrderByComparator<ExpandoColumn> orderByComparator) throws NoSuchColumnException Returns the first expando column in the ordered set where tableId = ?.- Parameters:
tableId- the table IDorderByComparator- the comparator to order the set by (optionallynull)- Returns:
- the first matching expando column
- Throws:
NoSuchColumnException- if a matching expando column could not be foundNoSuchColumnException
-
fetchByTableId_First
public static ExpandoColumn fetchByTableId_First(long tableId, OrderByComparator<ExpandoColumn> orderByComparator) Returns the first expando column in the ordered set where tableId = ?.- Parameters:
tableId- the table IDorderByComparator- the comparator to order the set by (optionallynull)- Returns:
- the first matching expando column, or
nullif a matching expando column could not be found
-
findByTableId_Last
public static ExpandoColumn findByTableId_Last(long tableId, OrderByComparator<ExpandoColumn> orderByComparator) throws NoSuchColumnException Returns the last expando column in the ordered set where tableId = ?.- Parameters:
tableId- the table IDorderByComparator- the comparator to order the set by (optionallynull)- Returns:
- the last matching expando column
- Throws:
NoSuchColumnException- if a matching expando column could not be foundNoSuchColumnException
-
fetchByTableId_Last
public static ExpandoColumn fetchByTableId_Last(long tableId, OrderByComparator<ExpandoColumn> orderByComparator) Returns the last expando column in the ordered set where tableId = ?.- Parameters:
tableId- the table IDorderByComparator- the comparator to order the set by (optionallynull)- Returns:
- the last matching expando column, or
nullif a matching expando column could not be found
-
findByTableId_PrevAndNext
public static ExpandoColumn[] findByTableId_PrevAndNext(long columnId, long tableId, OrderByComparator<ExpandoColumn> orderByComparator) throws 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 columntableId- the table IDorderByComparator- the comparator to order the set by (optionallynull)- Returns:
- the previous, current, and next expando column
- Throws:
NoSuchColumnException- if a expando column with the primary key could not be foundNoSuchColumnException
-
filterFindByTableId
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
-
filterFindByTableId
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 - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
tableId- the table IDstart- the lower bound of the range of expando columnsend- 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
-
filterFindByTableId
public static List<ExpandoColumn> filterFindByTableId(long tableId, int start, int end, OrderByComparator<ExpandoColumn> orderByComparator) 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 - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
tableId- the table IDstart- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)orderByComparator- the comparator to order the results by (optionallynull)- Returns:
- the ordered range of matching expando columns that the user has permission to view
-
filterFindByTableId_PrevAndNext
public static ExpandoColumn[] filterFindByTableId_PrevAndNext(long columnId, long tableId, OrderByComparator<ExpandoColumn> orderByComparator) throws 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 columntableId- the table IDorderByComparator- the comparator to order the set by (optionallynull)- Returns:
- the previous, current, and next expando column
- Throws:
NoSuchColumnException- if a expando column with the primary key could not be foundNoSuchColumnException
-
removeByTableId
public static void removeByTableId(long tableId) Removes all the expando columns where tableId = ? from the database.- Parameters:
tableId- the table ID
-
countByTableId
public static int countByTableId(long tableId) Returns the number of expando columns where tableId = ?.- Parameters:
tableId- the table ID- Returns:
- the number of matching expando columns
-
filterCountByTableId
public static int filterCountByTableId(long tableId) 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
-
findByT_N
Returns all the expando columns where tableId = ? and name = any ?.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
tableId- the table IDnames- the names- Returns:
- the matching expando columns
-
findByT_N
Returns a range of all the expando columns where tableId = ? and name = any ?.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
tableId- the table IDnames- the namesstart- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)- Returns:
- the range of matching expando columns
-
findByT_N
public static List<ExpandoColumn> findByT_N(long tableId, String[] names, int start, int end, OrderByComparator<ExpandoColumn> orderByComparator) Returns an ordered range of all the expando columns where tableId = ? and name = any ?.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
tableId- the table IDnames- the namesstart- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)orderByComparator- the comparator to order the results by (optionallynull)- Returns:
- the ordered range of matching expando columns
-
findByT_N
public static List<ExpandoColumn> findByT_N(long tableId, String[] names, int start, int end, OrderByComparator<ExpandoColumn> orderByComparator, boolean useFinderCache) Returns an ordered range of all the expando columns where tableId = ? and name = ?, optionally using the finder cache.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
tableId- the table IDnames- the namesstart- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)orderByComparator- the comparator to order the results by (optionallynull)useFinderCache- whether to use the finder cache- Returns:
- the ordered range of matching expando columns
-
findByT_N
Returns the expando column where tableId = ? and name = ? or throws aNoSuchColumnExceptionif it could not be found.- Parameters:
tableId- the table IDname- the name- Returns:
- the matching expando column
- Throws:
NoSuchColumnException- if a matching expando column could not be foundNoSuchColumnException
-
fetchByT_N
Returns the expando column where tableId = ? and name = ? or returnsnullif it could not be found. Uses the finder cache.- Parameters:
tableId- the table IDname- the name- Returns:
- the matching expando column, or
nullif a matching expando column could not be found
-
fetchByT_N
Returns the expando column where tableId = ? and name = ? or returnsnullif it could not be found, optionally using the finder cache.- Parameters:
tableId- the table IDname- the nameuseFinderCache- whether to use the finder cache- Returns:
- the matching expando column, or
nullif a matching expando column could not be found
-
removeByT_N
Removes the expando column where tableId = ? and name = ? from the database.- Parameters:
tableId- the table IDname- the name- Returns:
- the expando column that was removed
- Throws:
NoSuchColumnException
-
countByT_N
Returns the number of expando columns where tableId = ? and name = ?.- Parameters:
tableId- the table IDname- the name- Returns:
- the number of matching expando columns
-
countByT_N
Returns the number of expando columns where tableId = ? and name = any ?.- Parameters:
tableId- the table IDnames- the names- Returns:
- the number of matching expando columns
-
filterCountByT_N
Returns the number of expando columns that the user has permission to view where tableId = ? and name = ?.- Parameters:
tableId- the table IDname- the name- Returns:
- the number of matching expando columns that the user has permission to view
-
filterCountByT_N
Returns the number of expando columns that the user has permission to view where tableId = ? and name = any ?.- Parameters:
tableId- the table IDnames- the names- Returns:
- the number of matching expando columns that the user has permission to view
-
cacheResult
Caches the expando column in the entity cache if it is enabled.- Parameters:
expandoColumn- the expando column
-
cacheResult
Caches the expando columns in the entity cache if it is enabled.- Parameters:
expandoColumns- the expando columns
-
create
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
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 foundNoSuchColumnException
-
updateImpl
-
findByPrimaryKey
Returns the expando column with the primary key or throws aNoSuchColumnExceptionif 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 foundNoSuchColumnException
-
fetchByPrimaryKey
Returns the expando column with the primary key or returnsnullif it could not be found.- Parameters:
columnId- the primary key of the expando column- Returns:
- the expando column, or
nullif a expando column with the primary key could not be found
-
findAll
Returns all the expando columns.- Returns:
- the expando columns
-
findAll
Returns a range of all the expando columns.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
start- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)- Returns:
- the range of expando columns
-
findAll
public static List<ExpandoColumn> findAll(int start, int end, OrderByComparator<ExpandoColumn> orderByComparator) Returns an ordered range of all the expando columns.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
start- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)orderByComparator- the comparator to order the results by (optionallynull)- Returns:
- the ordered range of expando columns
-
findAll
public static List<ExpandoColumn> findAll(int start, int end, OrderByComparator<ExpandoColumn> orderByComparator, boolean useFinderCache) Returns an ordered range of all the expando columns.Useful when paginating results. Returns a maximum of
end - startinstances.startandendare not primary keys, they are indexes in the result set. Thus,0refers to the first result in the set. Setting bothstartandendtoQueryUtil#ALL_POSwill return the full result set. IforderByComparatoris specified, then the query will include the given ORDER BY logic. IforderByComparatoris absent, then the query will include the default ORDER BY logic fromExpandoColumnModelImpl.- Parameters:
start- the lower bound of the range of expando columnsend- the upper bound of the range of expando columns (not inclusive)orderByComparator- the comparator to order the results by (optionallynull)useFinderCache- whether to use the finder cache- Returns:
- the ordered range of expando columns
-
removeAll
public static void removeAll()Removes all the expando columns from the database. -
countAll
public static int countAll()Returns the number of expando columns.- Returns:
- the number of expando columns
-
getPersistence
-
setPersistence
-