How to search a table content

Owned by Kenichi Abe (Deactivated)
Last updated: Jun 16, 2021
2 min read

This feature cannot search with Confluence native features at this moment.

So, this feature is not recommended for “casual” users.

How to search

The app allows you to search the content of a table with a CQL query.

The following ways are available,

  1. Use 'CQL search' (free app) recommended

    • Recommended for generic use

  2. Use Confluence advanced search screen ( Tricky)

    • Once search the query, then rewrite search?text= to search?cql= in the browser URL field

  3. Use Confluence REST API

    • Recommended for developers

    • Searches for content using the Confluence Query Language (CQL)

       

CQL fields

The following CQL fields are available.

Field

Type

Returns

Examples

Field

Type

Returns

Examples

tableContent

text

Content information; words contained in tables

tableContent~kick

tableContentTruncated

number

1 if content information for searching was truncated, 0 otherwise

tableContentTruncated=1

Limitations and notices

  • The size of content information for searching is limited under a specified size(about 30KB)

    • if it goes over the limitation, it will be truncated

  • For tables created by an old version, you need to save once to become a search target