Uses of Class
com.ibm.fhir.database.utils.query.Select

Packages that use Select

Package	Description
com.ibm.fhir.database.utils.query
com.ibm.fhir.database.utils.query.expression
com.ibm.fhir.database.utils.query.node
com.ibm.fhir.persistence.jdbc.dao.api
com.ibm.fhir.persistence.jdbc.dao.impl
com.ibm.fhir.persistence.jdbc.util

Uses of Select in com.ibm.fhir.database.utils.query

Methods in com.ibm.fhir.database.utils.query that return Select

Modifier and Type	Method	Description
Select	FromAdapter.build()	Provide the select statement we've been building
Select	GroupByAdapter.build()
Select	HavingAdapter.build()
Select	OrderByAdapter.build()	Get the select statement we've been building
Select	SelectAdapter.build()	Get the statement we've been constructing
Select	WhereAdapter.build()	Get the select statement wrapped by this adapter
Select	SelectAdapter.getSelect()	Getter for the select statement we are managing

Methods in com.ibm.fhir.database.utils.query with parameters of type Select

Modifier and Type	Method	Description
void	FromClause.addFrom(Select sub, Alias alias)	Add the sub-query as an item in the from list
void	Select.addFrom(Select sub, Alias alias)	Add a sub-select statement with an alias to the from-clause
SelectItemSubQuery	SelectList.addSubQuery(Select subQuery, Alias alias)
T	BaseWhereAdapter.exists(Select correlatedSubSelect)	Add an exists clause using the given correlated sub-select statement
FromAdapter	SelectAdapter.from(Select sub, Alias alias)	Add the sub-query select to the FROM clause
T	BaseWhereAdapter.notExists(Select correlatedSubSelect)	Add a NOT EXISTS clause using the given correlated sub-select statement
static java.sql.PreparedStatement	QueryUtil.prepareSelect(java.sql.Connection connection, Select select, IDatabaseTranslator translator)	Prepares the given Select statement and sets any bind parameters.
void	Select.setUnion(Select union)	Set a select to UNION with this query.
void	Select.setUnionAll(Select unionAll)	Set a select to UNION ALL with this query.
void	SelectAdapter.union(Select unionSelect)	Add a select via UNION
void	SelectAdapter.unionAll(Select unionAllSelect)	Add a select via UNION ALL

Constructors in com.ibm.fhir.database.utils.query with parameters of type Select

Constructor	Description
FromAdapter(Select select)	Model the "from" part of the select statement
FromSubQueryAdapter(Select parentSelect, FromAdapter from)	constructor
GroupByAdapter(Select select, GroupByClause gb, java.lang.String... expressions)	Protected constructor for modeling the GROUP BY part of a SELECT statement.
HavingAdapter(Select select)	Protected constructor.
OrderByAdapter(Select select, OrderByClause ob)	Protected constructor for modeling the GROUP BY part of a SELECT statement.
SelectAdapter(Select select)	Adapter this select statement
SelectItemSubQuery(Select subQuery, Alias alias)
SelectRowSource(Select subQuery)	Protected constructor
WhereAdapter(Select select, WhereClause whereClause)	Public constructor to start the WHERE clause in a select statement
WhereAdapter(Select select, WhereClause whereClause, ExpNode predicate)
WhereAdapter(Select select, WhereClause whereClause, java.lang.String predicate)	Public constructor
WhereAdapter(Select select, WhereClause whereClause, java.lang.String tableAlias, java.lang.String columnName)	Convenience for when the statement is written like .where("lr", "current_resource_id").eq("r", "resource_id")

Uses of Select in com.ibm.fhir.database.utils.query.expression

Methods in com.ibm.fhir.database.utils.query.expression with parameters of type Select

Modifier and Type	Method	Description
java.util.Set<java.lang.String>	ColumnExpNodeVisitor.select(Select select)
java.lang.String	DebugExpNodeVisitor.select(Select select)
T	StatementRenderer.select(boolean distinct, SelectList selectList, FromClause fromClause, WhereClause whereClause, GroupByClause groupByClause, HavingClause havingClause, OrderByClause orderByClause, PaginationClause paginationClause, boolean unionAll, Select union)	Render the select statement using each of the components, some of which may be optional (null)
java.lang.String	StringExpNodeVisitor.select(Select select)
java.lang.String	StringStatementRenderer.select(boolean distinct, SelectList selectList, FromClause fromClause, WhereClause whereClause, GroupByClause groupByClause, HavingClause havingClause, OrderByClause orderByClause, PaginationClause paginationClause, boolean unionAll, Select union)

Uses of Select in com.ibm.fhir.database.utils.query.node

Methods in com.ibm.fhir.database.utils.query.node with parameters of type Select

Modifier and Type	Method	Description
T	ExpNodeVisitor.select(Select select)	Process a sub-select statement

Constructors in com.ibm.fhir.database.utils.query.node with parameters of type Select

Constructor	Description
SelectExpNode(Select select)	Public constructor

Uses of Select in com.ibm.fhir.persistence.jdbc.dao.api

Methods in com.ibm.fhir.persistence.jdbc.dao.api with parameters of type Select

Modifier and Type	Method	Description
java.util.List<Resource>	ResourceDAO.search(Select select)	Executes the search contained in the passed Select, using its encapsulated search string and bind variables.
int	ResourceDAO.searchCount(Select countQuery)	Executes a count query based on the data contained in the passed Select statement, using its encapsulated search string and bind variables.
java.util.List<java.lang.Long>	ResourceDAO.searchForIds(Select dataQuery)	This method supports the execution of a specialized query designed to return Resource ids, based on the contents of the passed select statement.
java.util.Map<java.lang.Integer,java.util.List<java.lang.Long>>	ResourceDAO.searchWholeSystem(Select select)	Executes the whole-system filter search contained in the passed Select, using its encapsulated search string and bind variables.

Uses of Select in com.ibm.fhir.persistence.jdbc.dao.impl

Methods in com.ibm.fhir.persistence.jdbc.dao.impl with parameters of type Select

Modifier and Type	Method	Description
protected int	FHIRDbDAOImpl.runCountQuery(Select countQuery)	Creates and executes a PreparedStatement for the passed sql containing a 'SELECT COUNT...'.
protected java.util.List<Resource>	FHIRDbDAOImpl.runQuery(Select select)	Retrieve the FHIR objects by executing the given Select statement
java.util.List<Resource>	ResourceDAOImpl.search(Select select)
int	ResourceDAOImpl.searchCount(Select countQuery)
java.util.List<java.lang.Long>	ResourceDAOImpl.searchForIds(Select dataQuery)
java.util.Map<java.lang.Integer,java.util.List<java.lang.Long>>	ResourceDAOImpl.searchWholeSystem(Select wholeSystemQuery)

Uses of Select in com.ibm.fhir.persistence.jdbc.util

Methods in com.ibm.fhir.persistence.jdbc.util that return Select

Modifier and Type	Method	Description
Select	NewQueryBuilder.buildCountQuery(java.lang.Class<?> resourceType, FHIRSearchContext searchContext)	Builds a query that returns the count of the search results that would be found by applying the search parameters contained within the passed search context.
Select	NewQueryBuilder.buildIncludeQuery(java.lang.Class<?> resourceType, FHIRSearchContext searchContext, InclusionParameter inclusionParm, java.util.List<java.lang.Long> logicalResourceIds, java.lang.String inclusionType)	Builds a query that returns included resources.
Select	NewQueryBuilder.buildQuery(java.lang.Class<?> resourceType, FHIRSearchContext searchContext)	Construct a FHIR search query
Select	NewQueryBuilder.buildWholeSystemDataQuery(FHIRSearchContext searchContext, java.util.Map<java.lang.Integer,java.util.List<java.lang.Long>> resourceTypeIdToLogicalResourceIdMap)	Builds a query that returns resource data for the specified whole-system search.