Uses of Class
org.opencms.db.CmsSelectQuery.TableAlias
Package
Description
Low-level database connection and access functionality.
Generic (ANSI-SQL) implementation of the OpenCms database connector.
-
Uses of CmsSelectQuery.TableAlias in org.opencms.db
Modifier and TypeMethodDescriptionAdds a table the query's FROM clause. -
Uses of CmsSelectQuery.TableAlias in org.opencms.db.generic
Modifier and TypeMethodDescriptionprotected void
CmsUserQueryBuilder.addAllowedOuCondition
(CmsSelectQuery select, CmsSelectQuery.TableAlias users, List<CmsOrganizationalUnit> allowedOus) Adds OU conditions to an SQL query.protected void
CmsUserQueryBuilder.addEmailCondition
(CmsSelectQuery select, CmsSelectQuery.TableAlias users, String email) Adds an equality test for the email address.protected void
CmsUserQueryBuilder.addFlagCondition
(CmsSelectQuery select, CmsSelectQuery.TableAlias users, int flags, boolean allowCore) Adds flag checking conditions to an SQL query.protected void
CmsUserQueryBuilder.addGroupCondition
(CmsSelectQuery select, CmsSelectQuery.TableAlias users, CmsUserSearchParameters searchParams) Adds group conditions to an SQL query.protected void
CmsUserQueryBuilder.addOrgUnitCondition
(CmsSelectQuery select, CmsSelectQuery.TableAlias users, CmsOrganizationalUnit orgUnit, boolean recursive) Adds a check for an OU to an SQL query.protected void
CmsUserQueryBuilder.addSearchFilterCondition
(CmsSelectQuery select, CmsSelectQuery.TableAlias users, CmsUserSearchParameters searchParams) Adds a search condition to a query.protected void
CmsUserQueryBuilder.addSorting
(CmsSelectQuery select, CmsSelectQuery.TableAlias users, CmsUserSearchParameters searchParams) Adds a sort order to an SQL query.protected void
CmsUserQueryBuilder.addWebuserCondition
(CmsSelectQuery select, CmsOrganizationalUnit orgUnit, CmsSelectQuery.TableAlias users) Adds a check for the web user condition to an SQL query.protected I_CmsQueryFragment
CmsUserQueryBuilder.createCoreCondition
(CmsSelectQuery.TableAlias users) Creates a core user check condition.protected I_CmsQueryFragment
CmsUserQueryBuilder.createFlagCondition
(CmsSelectQuery.TableAlias users, int flags) Creates an SQL flag check condition.protected String
CmsUserQueryBuilder.getSortExpression
(CmsSelectQuery.TableAlias users, CmsUserSearchParameters searchParams) Returns the expression used for sorting the results.protected String
CmsUserQueryBuilder.getUserActivatedExpression
(CmsSelectQuery.TableAlias users) Returns an expression for checking whether a user is activated.protected String
CmsUserQueryBuilder.getUserFlagExpression
(CmsSelectQuery.TableAlias users, int flags) Returns a bitwise AND expression with a fixed second operand.protected String
CmsUserQueryBuilder.getUserFullNameExpression
(CmsSelectQuery.TableAlias users) Returns the SQL expression for generating the user's full name in the format 'firstname lastname (loginname)'.