Modifier and Type | Method and Description |
---|---|
QueryOperation<QueryCountResponse> |
count(QueryCountRequest queryCountRequest)
Creates an operation to count the records qualified by the given
queryCountRequest . |
String |
escape(String value)
Deprecated.
This method only escapes single quotes and backslashes and does not provide a way to escape other
special characters. As of 21R3.4, the preferred escape utility is
escapeValue(String, QueryEscapeOverride...) which escapes all VQL special characters by default and
supports overriding the default escape strategy. |
String |
escapeValue(String value,
QueryEscapeOverride... escapeOverrides)
Escapes all VQL special characters in a string for use in a VQL statement.
|
Query.Builder |
newQueryBuilder()
Retrieves a
Query.Builder . |
Query.Builder |
newQueryBuilderFromQuery(Query query)
Creates a
Query.Builder based on a Query . |
QueryCountRequest.Builder |
newQueryCountRequestBuilder()
Retrieves a
QueryCountRequest.Builder . |
QueryExecutionRequest.Builder |
newQueryExecutionRequestBuilder()
Retrieves a
QueryExecutionRequest.Builder . |
QueryValidationRequest.Builder |
newQueryValidationRequestBuilder()
Retrieves a
QueryValidationRequest.Builder . |
QueryOperation<QueryExecutionResponse> |
query(QueryExecutionRequest queryExecutionRequest)
Creates an operation to execute the given
queryExecutionRequest . |
QueryResponse |
query(String vqlQuery)
Deprecated.
as of 21R3.4, replaced by
query(QueryExecutionRequest) |
QueryOperation<QueryValidationResponse> |
validate(QueryValidationRequest queryValidationRequest)
Creates an operation to validate the given
queryValidationRequest . |
@Deprecated QueryResponse query(String vqlQuery)
query(QueryExecutionRequest)
vqlQuery
.vqlQuery
- VQL query to executeQueryOperation<QueryExecutionResponse> query(QueryExecutionRequest queryExecutionRequest)
queryExecutionRequest
.
You can specify the ways success and error responses are handled
on the returned QueryOperation
. Once success-handling and
error-handling are specified, you can call QueryOperation.execute()
to execute the query request. For example:
queryService.query(queryExecutionRequest)
.onSuccess(queryExecutionResponse -> {
queryExecutionResponse.streamResults().forEach( ... )
})
.execute()
The stream returned by QueryExecutionResponse.streamResults()
includes all results qualified
by the query. Therefore, this method does not support the VQL pagination clauses
PAGESIZE
and PAGEOFFSET
.
queryExecutionRequest
- query request to executeQueryOperation<QueryCountResponse> count(QueryCountRequest queryCountRequest)
queryCountRequest
.
You can specify the ways success and error are handled
on the returned QueryOperation
. Once success-handling and
error-handling is specified, you can call QueryOperation.execute()
to execute the query request. For example:
queryService.count(queryCountRequest)
.onSuccess(queryCountResponse -> {
queryCountResponse.getCount()
...
})
.execute()
queryCountRequest
- query count request to executeQueryOperation<QueryValidationResponse> validate(QueryValidationRequest queryValidationRequest)
queryValidationRequest
.
You can specify the ways success and error are handled
on the returned QueryOperation
. Once success-handling and
error-handling is specified, you can call QueryOperation.execute()
to execute the query request. For example:
queryService.validate(queryValidationRequest)
.onSuccess(queryValidationResponse -> {
queryValidationResponse.getQuery()
...
})
.execute()
queryValidationRequest
- query validation request to executeQueryExecutionRequest.Builder newQueryExecutionRequestBuilder()
QueryExecutionRequest.Builder
.QueryCountRequest.Builder newQueryCountRequestBuilder()
QueryCountRequest.Builder
.QueryValidationRequest.Builder newQueryValidationRequestBuilder()
QueryValidationRequest.Builder
.Query.Builder newQueryBuilder()
Query.Builder
.Query.Builder newQueryBuilderFromQuery(Query query)
Query.Builder
based on a Query
.query
- Query with which to populate the returned builderquery
@Deprecated String escape(String value)
escapeValue(String, QueryEscapeOverride...)
which escapes all VQL special characters by default and
supports overriding the default escape strategy.Escaped characters include single quotes and backslashes. This method does not escape reserved keywords, such as SELECT or WHERE.
All user-provided values should be escaped to ensure your queries execute as expected. For example, in the following VQL statement:
SELECT id FROM user__sys WHERE name__v='O'Brien'The
name
value is a user-entered value which, if not escaped, could cause the VQL parser to fail because of the special character.
Note that improperly escaped VQL will not bypass configured security.
value
- the value to escapeString escapeValue(String value, QueryEscapeOverride... escapeOverrides)
VQL special characters are:
\ " ' ( ) * %
Optionally, any number of QueryEscapeOverride
can be used to exempt certain
special characters from being escaped.
value
- the value to escapeescapeOverrides
- overrides(s) indicating which characters not to escapeCopyright © Veeva Systems 2017–2023. All rights reserved.