public sealed class StructuredQuery : IMessage<StructuredQuery>, IEquatable<StructuredQuery>, IDeepCloneable<StructuredQuery>, IBufferMessage, IMessage
A Firestore query.
Implements
IMessage<StructuredQuery>, IEquatable<StructuredQuery>, IDeepCloneable<StructuredQuery>, IBufferMessage, IMessageNamespace
Google.Cloud.Firestore.V1Assembly
Google.Cloud.Firestore.V1.dll
Constructors
StructuredQuery()
public StructuredQuery()
StructuredQuery(StructuredQuery)
public StructuredQuery(StructuredQuery other)
Parameter | |
---|---|
Name | Description |
other | StructuredQuery |
Properties
EndAt
public Cursor EndAt { get; set; }
A end point for the query results.
Property Value | |
---|---|
Type | Description |
Cursor |
From
public RepeatedField<StructuredQuery.Types.CollectionSelector> From { get; }
The collections to query.
Property Value | |
---|---|
Type | Description |
RepeatedField<StructuredQuery.Types.CollectionSelector> |
Limit
public int? Limit { get; set; }
The maximum number of results to return.
Applies after all other constraints. Must be >= 0 if specified.
Property Value | |
---|---|
Type | Description |
Nullable<Int32> |
Offset
public int Offset { get; set; }
The number of results to skip.
Applies before limit, but after all other constraints. Must be >= 0 if specified.
Property Value | |
---|---|
Type | Description |
Int32 |
OrderBy
public RepeatedField<StructuredQuery.Types.Order> OrderBy { get; }
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 A
becomesSELECT * FROM Foo ORDER BY A, __name__
SELECT * FROM Foo ORDER BY A DESC
becomesSELECT * FROM Foo ORDER BY A DESC, __name__ DESC
SELECT * FROM Foo WHERE A > 1
becomesSELECT * FROM Foo WHERE A > 1 ORDER BY A, __name__
Property Value | |
---|---|
Type | Description |
RepeatedField<StructuredQuery.Types.Order> |
Select
public StructuredQuery.Types.Projection Select { get; set; }
The projection to return.
Property Value | |
---|---|
Type | Description |
StructuredQuery.Types.Projection |
StartAt
public Cursor StartAt { get; set; }
A starting point for the query results.
Property Value | |
---|---|
Type | Description |
Cursor |
Where
public StructuredQuery.Types.Filter Where { get; set; }
The filter to apply.
Property Value | |
---|---|
Type | Description |
StructuredQuery.Types.Filter |