public interface StructuredQueryOrBuilder extends MessageOrBuilder
Implements
MessageOrBuilderMethods
getEndAt()
public abstract Cursor getEndAt()
A potential prefix of a position in the result set to end the query at.
This is similar to START_AT
but with it controlling the end position
rather than the start position.
Requires:
- The number of values cannot be greater than the number of fields
specified in the
ORDER BY
clause.
.google.firestore.v1.Cursor end_at = 8;
Returns | |
---|---|
Type | Description |
Cursor | The endAt. |
getEndAtOrBuilder()
public abstract CursorOrBuilder getEndAtOrBuilder()
A potential prefix of a position in the result set to end the query at.
This is similar to START_AT
but with it controlling the end position
rather than the start position.
Requires:
- The number of values cannot be greater than the number of fields
specified in the
ORDER BY
clause.
.google.firestore.v1.Cursor end_at = 8;
Returns | |
---|---|
Type | Description |
CursorOrBuilder |
getFrom(int index)
public abstract StructuredQuery.CollectionSelector getFrom(int index)
The collections to query.
repeated .google.firestore.v1.StructuredQuery.CollectionSelector from = 2;
Parameter | |
---|---|
Name | Description |
index | int |
Returns | |
---|---|
Type | Description |
StructuredQuery.CollectionSelector |
getFromCount()
public abstract int getFromCount()
The collections to query.
repeated .google.firestore.v1.StructuredQuery.CollectionSelector from = 2;
Returns | |
---|---|
Type | Description |
int |
getFromList()
public abstract List<StructuredQuery.CollectionSelector> getFromList()
The collections to query.
repeated .google.firestore.v1.StructuredQuery.CollectionSelector from = 2;
Returns | |
---|---|
Type | Description |
List<CollectionSelector> |
getFromOrBuilder(int index)
public abstract StructuredQuery.CollectionSelectorOrBuilder getFromOrBuilder(int index)
The collections to query.
repeated .google.firestore.v1.StructuredQuery.CollectionSelector from = 2;
Parameter | |
---|---|
Name | Description |
index | int |
Returns | |
---|---|
Type | Description |
StructuredQuery.CollectionSelectorOrBuilder |
getFromOrBuilderList()
public abstract List<? extends StructuredQuery.CollectionSelectorOrBuilder> getFromOrBuilderList()
The collections to query.
repeated .google.firestore.v1.StructuredQuery.CollectionSelector from = 2;
Returns | |
---|---|
Type | Description |
List<? extends com.google.firestore.v1.StructuredQuery.CollectionSelectorOrBuilder> |
getLimit()
public abstract Int32Value getLimit()
The maximum number of results to return. Applies after all other constraints. Requires:
- The value must be greater than or equal to zero if specified.
.google.protobuf.Int32Value limit = 5;
Returns | |
---|---|
Type | Description |
Int32Value | The limit. |
getLimitOrBuilder()
public abstract Int32ValueOrBuilder getLimitOrBuilder()
The maximum number of results to return. Applies after all other constraints. Requires:
- The value must be greater than or equal to zero if specified.
.google.protobuf.Int32Value limit = 5;
Returns | |
---|---|
Type | Description |
Int32ValueOrBuilder |
getOffset()
public abstract int getOffset()
The number of documents to skip before returning the first result.
This applies after the constraints specified by the WHERE
, START AT
, &
END AT
but before the LIMIT
clause.
Requires:
- The value must be greater than or equal to zero if specified.
int32 offset = 6;
Returns | |
---|---|
Type | Description |
int | The offset. |
getOrderBy(int index)
public abstract StructuredQuery.Order getOrderBy(int index)
The order to apply to the query results. Firestore allows callers to provide a full ordering, a partial ordering, or no ordering at all. In all cases, Firestore guarantees a stable ordering through the following rules:
- The
order_by
is required to reference all fields used with an inequality filter. - All fields that are required to be in the
order_by
but are not already present are appended in lexicographical ordering of the field name. - 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: ORDER BY a
becomesORDER BY a ASC, name ASC
ORDER BY a DESC
becomesORDER BY a DESC, name DESC
WHERE a > 1
becomesWHERE a > 1 ORDER BY a ASC, name ASC
WHERE name > ... AND a > 1
becomesWHERE name > ... AND a > 1 ORDER BY a ASC, name ASC
repeated .google.firestore.v1.StructuredQuery.Order order_by = 4;
Parameter | |
---|---|
Name | Description |
index | int |
Returns | |
---|---|
Type | Description |
StructuredQuery.Order |
getOrderByCount()
public abstract int getOrderByCount()
The order to apply to the query results. Firestore allows callers to provide a full ordering, a partial ordering, or no ordering at all. In all cases, Firestore guarantees a stable ordering through the following rules:
- The
order_by
is required to reference all fields used with an inequality filter. - All fields that are required to be in the
order_by
but are not already present are appended in lexicographical ordering of the field name. - 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: ORDER BY a
becomesORDER BY a ASC, name ASC
ORDER BY a DESC
becomesORDER BY a DESC, name DESC
WHERE a > 1
becomesWHERE a > 1 ORDER BY a ASC, name ASC
WHERE name > ... AND a > 1
becomesWHERE name > ... AND a > 1 ORDER BY a ASC, name ASC
repeated .google.firestore.v1.StructuredQuery.Order order_by = 4;
Returns | |
---|---|
Type | Description |
int |
getOrderByList()
public abstract List<StructuredQuery.Order> getOrderByList()
The order to apply to the query results. Firestore allows callers to provide a full ordering, a partial ordering, or no ordering at all. In all cases, Firestore guarantees a stable ordering through the following rules:
- The
order_by
is required to reference all fields used with an inequality filter. - All fields that are required to be in the
order_by
but are not already present are appended in lexicographical ordering of the field name. - 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: ORDER BY a
becomesORDER BY a ASC, name ASC
ORDER BY a DESC
becomesORDER BY a DESC, name DESC
WHERE a > 1
becomesWHERE a > 1 ORDER BY a ASC, name ASC
WHERE name > ... AND a > 1
becomesWHERE name > ... AND a > 1 ORDER BY a ASC, name ASC
repeated .google.firestore.v1.StructuredQuery.Order order_by = 4;
Returns | |
---|---|
Type | Description |
List<Order> |
getOrderByOrBuilder(int index)
public abstract StructuredQuery.OrderOrBuilder getOrderByOrBuilder(int index)
The order to apply to the query results. Firestore allows callers to provide a full ordering, a partial ordering, or no ordering at all. In all cases, Firestore guarantees a stable ordering through the following rules:
- The
order_by
is required to reference all fields used with an inequality filter. - All fields that are required to be in the
order_by
but are not already present are appended in lexicographical ordering of the field name. - 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: ORDER BY a
becomesORDER BY a ASC, name ASC
ORDER BY a DESC
becomesORDER BY a DESC, name DESC
WHERE a > 1
becomesWHERE a > 1 ORDER BY a ASC, name ASC
WHERE name > ... AND a > 1
becomesWHERE name > ... AND a > 1 ORDER BY a ASC, name ASC
repeated .google.firestore.v1.StructuredQuery.Order order_by = 4;
Parameter | |
---|---|
Name | Description |
index | int |
Returns | |
---|---|
Type | Description |
StructuredQuery.OrderOrBuilder |
getOrderByOrBuilderList()
public abstract List<? extends StructuredQuery.OrderOrBuilder> getOrderByOrBuilderList()
The order to apply to the query results. Firestore allows callers to provide a full ordering, a partial ordering, or no ordering at all. In all cases, Firestore guarantees a stable ordering through the following rules:
- The
order_by
is required to reference all fields used with an inequality filter. - All fields that are required to be in the
order_by
but are not already present are appended in lexicographical ordering of the field name. - 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: ORDER BY a
becomesORDER BY a ASC, name ASC
ORDER BY a DESC
becomesORDER BY a DESC, name DESC
WHERE a > 1
becomesWHERE a > 1 ORDER BY a ASC, name ASC
WHERE name > ... AND a > 1
becomesWHERE name > ... AND a > 1 ORDER BY a ASC, name ASC
repeated .google.firestore.v1.StructuredQuery.Order order_by = 4;
Returns | |
---|---|
Type | Description |
List<? extends com.google.firestore.v1.StructuredQuery.OrderOrBuilder> |
getSelect()
public abstract StructuredQuery.Projection getSelect()
The projection to return.
.google.firestore.v1.StructuredQuery.Projection select = 1;
Returns | |
---|---|
Type | Description |
StructuredQuery.Projection | The select. |
getSelectOrBuilder()
public abstract StructuredQuery.ProjectionOrBuilder getSelectOrBuilder()
The projection to return.
.google.firestore.v1.StructuredQuery.Projection select = 1;
Returns | |
---|---|
Type | Description |
StructuredQuery.ProjectionOrBuilder |
getStartAt()
public abstract Cursor getStartAt()
A potential prefix of a position in the result set to start the query at.
The ordering of the result set is based on the ORDER BY
clause of the
original query.
`
SELECT * FROM k WHERE a = 1 AND b > 2 ORDER BY b ASC, name ASC;
This query's results are ordered by
(b ASC, name ASC).
Cursors can reference either the full ordering or a prefix of the location,
though it cannot reference more fields than what are in the provided
ORDER BY.
Continuing off the example above, attaching the following start cursors
will have varying impact:
: start the query right before
a = 1 AND
b > 2 AND name > /k/123.
START AFTER (10): start the query right after
a = 1 AND b > 10.
Unlike
OFFSET which requires scanning over the first N results to skip,
a start cursor allows the query to begin at a logical position. This
position is not required to match an actual result, it will scan forward
from this position to find the next document.
Requires:
The number of values cannot be greater than the number of fields
specified in the
ORDER BY` clause.
.google.firestore.v1.Cursor start_at = 7;
Returns | |
---|---|
Type | Description |
Cursor | The startAt. |
getStartAtOrBuilder()
public abstract CursorOrBuilder getStartAtOrBuilder()
A potential prefix of a position in the result set to start the query at.
The ordering of the result set is based on the ORDER BY
clause of the
original query.
`
SELECT * FROM k WHERE a = 1 AND b > 2 ORDER BY b ASC, name ASC;
This query's results are ordered by
(b ASC, name ASC).
Cursors can reference either the full ordering or a prefix of the location,
though it cannot reference more fields than what are in the provided
ORDER BY.
Continuing off the example above, attaching the following start cursors
will have varying impact:
: start the query right before
a = 1 AND
b > 2 AND name > /k/123.
START AFTER (10): start the query right after
a = 1 AND b > 10.
Unlike
OFFSET which requires scanning over the first N results to skip,
a start cursor allows the query to begin at a logical position. This
position is not required to match an actual result, it will scan forward
from this position to find the next document.
Requires:
The number of values cannot be greater than the number of fields
specified in the
ORDER BY` clause.
.google.firestore.v1.Cursor start_at = 7;
Returns | |
---|---|
Type | Description |
CursorOrBuilder |
getWhere()
public abstract StructuredQuery.Filter getWhere()
The filter to apply.
.google.firestore.v1.StructuredQuery.Filter where = 3;
Returns | |
---|---|
Type | Description |
StructuredQuery.Filter | The where. |
getWhereOrBuilder()
public abstract StructuredQuery.FilterOrBuilder getWhereOrBuilder()
The filter to apply.
.google.firestore.v1.StructuredQuery.Filter where = 3;
Returns | |
---|---|
Type | Description |
StructuredQuery.FilterOrBuilder |
hasEndAt()
public abstract boolean hasEndAt()
A potential prefix of a position in the result set to end the query at.
This is similar to START_AT
but with it controlling the end position
rather than the start position.
Requires:
- The number of values cannot be greater than the number of fields
specified in the
ORDER BY
clause.
.google.firestore.v1.Cursor end_at = 8;
Returns | |
---|---|
Type | Description |
boolean | Whether the endAt field is set. |
hasLimit()
public abstract boolean hasLimit()
The maximum number of results to return. Applies after all other constraints. Requires:
- The value must be greater than or equal to zero if specified.
.google.protobuf.Int32Value limit = 5;
Returns | |
---|---|
Type | Description |
boolean | Whether the limit field is set. |
hasSelect()
public abstract boolean hasSelect()
The projection to return.
.google.firestore.v1.StructuredQuery.Projection select = 1;
Returns | |
---|---|
Type | Description |
boolean | Whether the select field is set. |
hasStartAt()
public abstract boolean hasStartAt()
A potential prefix of a position in the result set to start the query at.
The ordering of the result set is based on the ORDER BY
clause of the
original query.
`
SELECT * FROM k WHERE a = 1 AND b > 2 ORDER BY b ASC, name ASC;
This query's results are ordered by
(b ASC, name ASC).
Cursors can reference either the full ordering or a prefix of the location,
though it cannot reference more fields than what are in the provided
ORDER BY.
Continuing off the example above, attaching the following start cursors
will have varying impact:
: start the query right before
a = 1 AND
b > 2 AND name > /k/123.
START AFTER (10): start the query right after
a = 1 AND b > 10.
Unlike
OFFSET which requires scanning over the first N results to skip,
a start cursor allows the query to begin at a logical position. This
position is not required to match an actual result, it will scan forward
from this position to find the next document.
Requires:
The number of values cannot be greater than the number of fields
specified in the
ORDER BY` clause.
.google.firestore.v1.Cursor start_at = 7;
Returns | |
---|---|
Type | Description |
boolean | Whether the startAt field is set. |
hasWhere()
public abstract boolean hasWhere()
The filter to apply.
.google.firestore.v1.StructuredQuery.Filter where = 3;
Returns | |
---|---|
Type | Description |
boolean | Whether the where field is set. |