Parameters for the postFind operation.

interface PostFindParams {
    bookmark?: string;
    conflicts?: boolean;
    db: string;
    executionStats?: boolean;
    fields?: string[];
    headers?: OutgoingHttpHeaders;
    limit?: number;
    r?: number;
    selector: JsonObject;
    skip?: number;
    sort?: JsonObject[];
    stable?: boolean;
    update?: string;
    useIndex?: string[];
}

Properties

bookmark?: string

Opaque bookmark token used when paginating results.

conflicts?: boolean

A boolean value that indicates whether or not to include information about existing conflicts in the document.

db: string

Path parameter to specify the database name.

executionStats?: boolean

Use this option to find information about the query that was run. This information includes total key lookups, total document lookups (when include_docs=true is used), and total quorum document lookups (when each document replica is fetched).

fields?: string[]

JSON array that uses the field syntax. Use this parameter to specify which fields of a document must be returned. If it is omitted or empty, the entire document is returned.

headers?: OutgoingHttpHeaders
limit?: number

Maximum number of results returned. The type: text indexes are limited to 200 results when queried.

r?: number

The read quorum that is needed for the result. The value defaults to 1, in which case the document that was found in the index is returned. If set to a higher value, each document is read from at least that many replicas before it is returned in the results. The request will take more time than using only the document that is stored locally with the index.

selector: JsonObject

JSON object describing criteria used to select documents. The selector specifies fields in the document, and provides an expression to evaluate with the field content or other data.

The selector object must:

  • Be structured as valid JSON.
  • Contain a valid query expression.

Using a selector is significantly more efficient than using a JavaScript filter function, and is the recommended option if filtering on document attributes only.

Elementary selector syntax requires you to specify one or more fields, and the corresponding values required for those fields. You can create more complex selector expressions by combining operators.

Operators are identified by the use of a dollar sign $ prefix in the name field.

There are two core types of operators in the selector syntax:

  • Combination operators: applied at the topmost level of selection. They are used to combine selectors. A combination operator takes a single argument. The argument is either another selector, or an array of selectors.
  • Condition operators: are specific to a field, and are used to evaluate the value stored in that field. For instance, the basic $eq operator matches when the specified field contains a value that is equal to the supplied argument. See the Cloudant Docs for a list of all available combination and conditional operators.
  • Only equality operators such as $eq, $gt, $gte, $lt, and $lte (but not $ne) can be used as the basis of a query. You should include at least one of these in a selector.

For further reference see selector syntax.

skip?: number

Skip the first 'n' results, where 'n' is the value that is specified.

sort?: JsonObject[]

The sort field contains a list of pairs, each mapping a field name to a sort direction (asc or desc). The first field name and direction pair is the topmost level of sort. The second pair, if provided, is the next level of sort. The field can be any field, using dotted notation if desired for sub-document fields.

For example in JSON: [{"fieldName1": "desc"}, {"fieldName2.subFieldName1": "desc"}]

When sorting with multiple fields, ensure that there is an index already defined with all the sort fields in the same order and each object in the sort array has a single key or at least one of the sort fields is included in the selector. All sorting fields must use the same sort direction, either all ascending or all descending.

stable?: boolean

Whether or not the view results should be returned from a "stable" set of shards.

update?: string

Whether to update the index prior to returning the result.

useIndex?: string[]

Use this option to identify a specific index for query to run against, rather than by using the IBM Cloudant Query algorithm to find the best index.

Generated using TypeDoc