Reference documentation and code samples for the Cloud Firestore V1beta1 Client class StructuredQuery.
A Firestore query.
Generated from protobuf message google.firestore.v1beta1.StructuredQuery
Namespace
Google \ Cloud \ Firestore \ V1beta1Methods
__construct
Constructor.
| Parameters | |
|---|---|
| Name | Description |
data |
array
Optional. Data for populating the Message object. |
↳ select |
StructuredQuery\Projection
The projection to return. |
↳ from |
array<StructuredQuery\CollectionSelector>
The collections to query. |
↳ where |
StructuredQuery\Filter
The filter to apply. |
↳ order_by |
array<StructuredQuery\Order>
The order to apply to the query results. Firestore guarantees a stable ordering through the following rules: * * Any field required to appear in |
↳ start_at |
Cursor
A starting point for the query results. |
↳ end_at |
Cursor
A end point for the query results. |
↳ offset |
int
The number of results to skip. Applies before limit, but after all other constraints. Must be >= 0 if specified. |
↳ limit |
Google\Protobuf\Int32Value
The maximum number of results to return. Applies after all other constraints. Must be >= 0 if specified. |
getSelect
The projection to return.
| Returns | |
|---|---|
| Type | Description |
StructuredQuery\Projection |
|
setSelect
The projection to return.
| Parameter | |
|---|---|
| Name | Description |
var |
StructuredQuery\Projection
|
| Returns | |
|---|---|
| Type | Description |
$this |
|
getFrom
The collections to query.
| Returns | |
|---|---|
| Type | Description |
Google\Protobuf\Internal\RepeatedField |
|
setFrom
The collections to query.
| Parameter | |
|---|---|
| Name | Description |
var |
array<StructuredQuery\CollectionSelector>
|
| Returns | |
|---|---|
| Type | Description |
$this |
|
getWhere
The filter to apply.
| Returns | |
|---|---|
| Type | Description |
StructuredQuery\Filter |
|
setWhere
The filter to apply.
| Parameter | |
|---|---|
| Name | Description |
var |
StructuredQuery\Filter
|
| Returns | |
|---|---|
| Type | Description |
$this |
|
getOrderBy
The order to apply to the query results.
Firestore guarantees a stable ordering through the following rules:
- Any field required to appear in
order_by, that is not already specified inorder_by, is appended to the order in field name order by default. - If an order on
__name__is not specified, it is appended by default. Fields are appended with the same sort direction as the last order specified, or 'ASCENDING' if no order was specified. For example: SELECT * FROM Foo ORDER BY AbecomesSELECT * FROM Foo ORDER BY A, __name__SELECT * FROM Foo ORDER BY A DESCbecomesSELECT * FROM Foo ORDER BY A DESC, __name__ DESCSELECT * FROM Foo WHERE A > 1becomesSELECT * FROM Foo WHERE A > 1 ORDER BY A, __name__
| Returns | |
|---|---|
| Type | Description |
Google\Protobuf\Internal\RepeatedField |
|
setOrderBy
The order to apply to the query results.
Firestore guarantees a stable ordering through the following rules:
- Any field required to appear in
order_by, that is not already specified inorder_by, is appended to the order in field name order by default. - If an order on
__name__is not specified, it is appended by default. Fields are appended with the same sort direction as the last order specified, or 'ASCENDING' if no order was specified. For example: SELECT * FROM Foo ORDER BY AbecomesSELECT * FROM Foo ORDER BY A, __name__SELECT * FROM Foo ORDER BY A DESCbecomesSELECT * FROM Foo ORDER BY A DESC, __name__ DESCSELECT * FROM Foo WHERE A > 1becomesSELECT * FROM Foo WHERE A > 1 ORDER BY A, __name__
| Parameter | |
|---|---|
| Name | Description |
var |
array<StructuredQuery\Order>
|
| Returns | |
|---|---|
| Type | Description |
$this |
|
getStartAt
A starting point for the query results.
| Returns | |
|---|---|
| Type | Description |
Cursor |
|
setStartAt
A starting point for the query results.
| Parameter | |
|---|---|
| Name | Description |
var |
Cursor
|
| Returns | |
|---|---|
| Type | Description |
$this |
|
getEndAt
A end point for the query results.
| Returns | |
|---|---|
| Type | Description |
Cursor |
|
setEndAt
A end point for the query results.
| Parameter | |
|---|---|
| Name | Description |
var |
Cursor
|
| Returns | |
|---|---|
| Type | Description |
$this |
|
getOffset
The number of results to skip.
Applies before limit, but after all other constraints. Must be >= 0 if specified.
| Returns | |
|---|---|
| Type | Description |
int |
|
setOffset
The number of results to skip.
Applies before limit, but after all other constraints. Must be >= 0 if specified.
| Parameter | |
|---|---|
| Name | Description |
var |
int
|
| Returns | |
|---|---|
| Type | Description |
$this |
|
getLimit
The maximum number of results to return.
Applies after all other constraints. Must be >= 0 if specified.
| Returns | |
|---|---|
| Type | Description |
Google\Protobuf\Int32Value |
|
getLimitValue
Returns the unboxed value from getLimit()
The maximum number of results to return. Applies after all other constraints. Must be >= 0 if specified.
| Returns | |
|---|---|
| Type | Description |
int|null |
|
setLimit
The maximum number of results to return.
Applies after all other constraints. Must be >= 0 if specified.
| Parameter | |
|---|---|
| Name | Description |
var |
Google\Protobuf\Int32Value
|
| Returns | |
|---|---|
| Type | Description |
$this |
|
setLimitValue
Sets the field by wrapping a primitive type in a Google\Protobuf\Int32Value object.
The maximum number of results to return. Applies after all other constraints. Must be >= 0 if specified.
| Parameter | |
|---|---|
| Name | Description |
var |
int|null
|
| Returns | |
|---|---|
| Type | Description |
$this |
|