Query by a Field with Java

There are a number of fields that you can query by. Here are examples of how to query by Number, Key Text, Document Link, and Select fields.

Number field

The following example shows how to query all the products with the "price" field (Number) less than 100.

Copy
Response response = api.query(
        Predicates.lt("my.product.price", 100)
    ).submit();
List<Document> documents = response.getResults();

You can find more query predicates for Number fields on the Query Predicate Reference page.

Key Text field

The following example shows how to query all the "employee" custom type documents with the "job_title" field (Key Text) equal to either "Developer" or "Designer".

Copy
Response response = api.query(
        Predicates.any("my.employee.job_title",  Arrays.asList("Developer", "Designer"))
    ).submit();
List<Document> documents = response.getResults();

To query by a particular document link value, you must use the ID of the document you are looking for.

The following example queries all the "blog_post" custom type documents with the "category_link" field (a Document Link) equal to the category with a document ID of "WNje3SUAAEGBu8bc".

Copy
Response response = api.query(
        Predicates.at("document.type", "blog_post"),
        Predicates.at("my.blog_post.category_link", "WNje3SUAAEGBu8bc")
    ).submit();
List<Document> documents

Select field

The following demonstrates how to query all the "book" custom type documents with the "author" field (Select) equal to "John Doe". It also sorts the results by their titles.

Copy
Response response = api.query(
        Predicates.at("my.book.author", "John Doe")
    ).orderings("my.book.title")
    .submit();
List<Document> documents = response.getResults();

A field within a Group

It is also possible to query by a field inside of a group.

The following queries all the "book" custom type documents with the "name" field equal to "John Doe". In this case the "name" field is in a group field named "author_info".

Copy
Response response = api.query(
        Predicates.at("my.book.author_info.name", "John Doe")
    ).orderings("my.book.title")
    .submit();
List<Document> documents = response.getResults();