.NET - Collection.Query.Where()

Adds a new where clause to a query, which filters the data returned.

using Nitric.Sdk;
using Nitric.Sdk.Resource;

class Profile {
  public string Name { get; set; }
  public float Age { get; set; }
}

var profiles = Nitric.Collection<Profile>("profiles").With(
  CollectionPermission.Reading, CollectionPermission.Writing, CollectionPermission.Deleting
);

var profilesQuery = profiles.Query().Where("name", "startsWith", "T");

Nitric.Run();

Parameters

  • Name
    field
    Required
    Required
    Type
    string
    Description

    The document field to query.

  • Name
    operation
    Required
    Required
    Type
    string
    Description

    The query operation to perform.
    Valid values are: startsWith | == | != | >= | <= | > | <.

  • Name
    value
    Required
    Required
    Type
    string | double | int | bool
    Description

    The value to compare against.

Notes

Where clauses combined together are always considered AND

Examples

A simple query

using Nitric.Sdk;
using Nitric.Sdk.Resources;

var profiles = Nitric.Collection("profiles").With(CollectionPermission.Reading);

var profileQuery = profiles.Query().Where("firstName", "==", "Drake");

Nitric.Run();

Combining where clauses

using Nitric.Sdk;
using Nitric.Sdk.Resources;

var profiles = Nitric.Collection("profiles").With(CollectionPermission.Reading);

var profileQuery = profiles.Query()
  .Where("firstName", "==", "Drake")
  .Where("age", ">=", 21);

Nitric.Run();

See also