Searching for Data

Article Number:040689

Using the search box at the top right of kintone, you can enter keywords to search for app records, comments posted in spaces or on People pages, and other data.
Search results are displayed when you enter a keyword in the search box and click the Search icon (the magnifying glass icon).
Screenshot: The search box on Portal is outlined This article explains the search results screen, the data you can search for, and points to keep in mind when entering a search keyword.

Overview of the search results screen

This section provides an overview of the search results screen.
Screenshot: The search results screen

Item Description
1 Displays titles of apps, spaces, people pages, and so on.
Words that are entered as a keyword are highlighted in bold.
For details on searchable data, refer to the following section:
Searchable Data
2 Displays an app, space, or people icon according to where the data comes from.
App: Image
Space: Image
People: Image
3 You can change the sort order of the search results or further narrow down the search results.
The conditions that can be specified are as follows:
  • Sort by
    By default, the search results are sorted in chronological order of the data creation date and time, with the most recently created one at the top.
  • User who created the data
  • The range of the data creation date
4 Displays apps, spaces, threads, and people pages whose name contains the specified keyword.
  • If an app has an app code set, you can search for the app using the app code. You can also search for a record by searching for "[the app code]-[the record number]".
  • If the Localization settings are configured for an app, you can use its localized name in your display language as well as the default app name to search for that particular app.
  • You can also use the following to search for a user:
    • User's localized name
    • User's phonetic first name and phonetic last name
    • User's login name

Searchable data

Item 1 of the search results screen displays the results of searches performed on the following data in kintone.

Type Searchable Data
Record
  • Record comments
  • Values of the following fields:
    • Text
    • Text area
    • Rich text
    • Link
    • Lookup (If a "Text" field or a "Link" field is specified as the Key Field)
Space
  • Space dashboard
Thread
  • Thread body text
  • Comments posted on threads
People
  • Comments posted on people pages
  • Private messages
Attachment
  • File names
  • File contents

Narrowing the search scope

Besides carrying out a search across the entire kintone, you can limit your search scope to a specific app or space.

Search in app

You can limit your search scope to a specific app.
Navigate to the target app and enter a keyword in the search box on the upper side of the screen.
Screenshot: The "Search in App" search box is outlined

Search in space

You can limit your search scope to a specific space.
Navigate to the target space and enter a keyword in the search box on the upper side of the screen.
Screenshot: The search box on a space portal is outlined

Searching with multiple keywords

When you specify multiple keywords, an AND search is performed.
When you insert a half-width or full-width space between your keywords, kintone searches for the data that contains all the key words you have specified. It is not possible to perform an OR search or a NOT search with multiple keywords.
To search for a keyword that includes a space, enclose the keyword with double quotation marks ("").

Example: When searching for records that contain all the keywords "ABC", "DEF", and "GHI"
Enter "ABC DEF GHI" in the search box and kintone will search for the data that contains all the three keywords.
Screenshot: "ABC DEF GHI" is entered in a search box

Example: When searching for records that contain the keyword "ABC DEF GHI"
Enter "ABC DEF GHI" with double quotation marks in the search box and kintone will search the data using the entered value as a single keyword.
Screenshot: "ABC DEF GHI" is entered with double quotation marks in a search box

Points to note when entering search keywords

Up to 100 characters can be entered in the search box.
Also note the following when using Japanese or Chinese characters, alphanumeric characters, or special characters for search keywords.

When searching with Japanese or Chinese characters

  • Full-width and half-width katakana characters are not distinguished.
  • You can specify up to 10 keywords.
  • To search for a word that consists of two or more characters, you must specify a keyword that consists of two or more characters. A word that consists of a single character can be searched for with a keyword that consists of a single character.
    Example: When searching for fields whose value contains the string "日本語"
    • Searchable keywords: "日本", "本語", or "日本語"
    • Non-searchable keywords: "日," "本," or "語"

When searching with alphanumeric characters

  • Keywords are not case-sensitive, and full-width and half-width alphabetical characters are not distinguished.
  • You can specify up to 10 keywords.
  • A search is performed for each keyword.
    Example: When searching for fields whose value contains the string "cybozu kintone2"
    • Enter "cybozu" or "kintone2" as a keyword. Partial matches (e.g., "cy" or "kintone") will not be searched for.
    • The words "cybozu" and "kintone2" each count as one word. A search for "cybozu kintone2" will result in a two-word search.
  • Underscores (_) and number signs (#) (both full-width and half-width) are considered as part of a word.
    Example: When searching for fields whose value contains the string "cybozu_kintone"
    • Specify "cybozu_kintone" as a keyword. If only "cybozu" or "kintone" is entered as the keyword, kintone will not search for the keyword "cybozu_kintone".

When searching with special characters

  • Full-width and half-width special characters are not distinguished.
  • You can specify up to 10 keywords.
  • The following special characters are excluded from search keywords.
    • Punctuation marks in Japanese and Chinese
    • The following symbols (both full-width and half-width):
      - & | / ! ( ) { } [ ] ^ " ~ * ? : ; \ $ % @ ' ` = < > , .