Customize

Retrieve Records by Providing Conditions in Query

Summary

Retrieve records from the specified app using the provided conditions in the query.

You can reuse the retrieved records in other Actions.

How to use

Parameters

Set App, Search Condition, and Limit.

App

Select an app to retrieve the records.

Search Condition

Enter the search criteria (query) for retrieving records. Please enter the information of the Kintone API query parameters as is.

For the notation of search conditions (queries), please refer to the official Cybozu documentation.

Example:

Text_0 = "test"

It is also possible to embed fields and action result values into queries using the Customine formula. The expression can be written in the format ${expression}. If the result value of ${expression} contains double quotes (") and backslashes (\ ), the escaped result will be returned. If you do not want to use escaping, please use “Retrieve Records by Providing Conditions in Query (No Escaping).” For information on escaping, please refer to the section “Escape processing for double quotes and backslashes” in the above Cybozu official documentation.

Example:

Text_0 = "${Text_1}"

Limit

Limit the number of items obtained. If you omit this parameter, all records that match the search criteria will be retrieved.

If there are many matching records, it takes time to retrieve all of them. In such cases, keeping this parameter at a smaller value can reduce processing time.

Specifying zero or less will result in an error.

Restrictions

  • In the standard “search condition” syntax of Kintone, there is a feature to limit the number of records retrieved by adding limit, such as “limit 10”, but this syntax cannot be used in the “search conditions” of “Retrieve Records by Providing Conditions in Query.” Instead, please use the “Limit” parameter.