Shinydocs Pro

Catalog - Advanced Search

Advanced search lets you write a query in the Catalog that combines fields, dates, sizes and operators. It is always available; there is no feature flag to turn on.

Write a query

In Control Center (https://localhost:9701 or https://<custom-control-center-url>), select Catalog, then select the </> icon at the start of the search box. The box switches to a query editor. Type your query and select Run.

cc-advsearch-26-5-01-query-box.png

The query shows above the results as an Advanced Query filter. It works together with any column filters. Select × on the filter, or Clear filters, to remove it.

cc-advsearch-26-5-03-results.png

Field suggestions

As you type a field name, a list of matching fields appears. Select one to add it to your query, or keep typing.

cc-advsearch-26-5-02-suggestions.png

If you use a field name the Catalog doesn’t recognize, it is underlined in red.

Search Term Formatting

Below is a list of the different fields types and examples of how they are formatted.

Field Type

Description

Example

String

A standard text field; like name, path, extension, etc.

name:shinydocs or
extension:pdf

Date

A date field (like creationTimeUtc and lastWriteTimeUtc) where the query term has to follow a specific format; like YYYY-MM-DD or now-#d/w/M/y

creationTimeUtc: >=2025-12-31 or
lastWriteTimeUtc: <now-1y

Number

A number field (like length) where the query term has to be a number value.

length: >1073741824 (1 GB)

Boolean

A boolean field (like meta-protected) will be a value of true or false.

meta-protected:true

Search Term Operators

Below is a list of the primary operators you can use to narrow and broaden your search.

Operator

Usage

Example

AND

Tells the system that all connected search terms must appear in your results.

name:shinydocs AND extension:docx

OR

Tells the system to find any of the connected search terms.

extension:docx OR extension:pdf

NOT

Tells the system to exclude specific search terms, removing unwanted concepts.

name:shinydocs NOT extension:log

Additional Search Term Operators for Number and Date Fields

Below is a list of additional operators used for date and number fields specifically.

Operator

Usage

Example

>

Greater than

creationTimeUtc: >2025-12-31

>=

Greater than or equal to

length: >=1073741824 (1 GB)

<

Less than

meta-pageCount: <10

<=

Less than or equal to

lastWriteTimeUtc: <=now-100d

[date TO date]

Value is between two date values

datetime: [2026-01-01 TO now-7d]

[# TO #]

Value is between two number values

length:[1048576 TO 10485760] (1MB to 10MB)

Search Term Modifiers

Below is a list of modifiers that provide further options for your search terms.

Modifier

Usage

Example

( )

Parentheses: Groups concepts together to control the order of operations.

name:shinydocs AND (extension:docx OR extension:pdf)

" "

Quotation marks: Searches for an exact phrase in a search term.

name:"shinydocs template"

*

Truncation/Wildcard: Finds variations of a search term.

name:temp* would return results with temp, temporary, template, etc.

rot_obsolete:* would return results with any value in that field; “log”, “old draft”, “unused”, etc.

Unique and Hidden Fields

Below is a list of fields that have unique naming or don’t appear in the field suggestions.

Field Name

Usage

Example

creationTimeUtc

The field behind the Created column in the Catalog. Use “creationTimeUtc” in a query, not “Created”.

creationTimeUtc: >2025-12-31

lastWriteTimeUtc

The field behind the Modified date. It doesn’t appear in the field suggestions, so type it in full.

lastWriteTimeUtc: >2025-12-31

_index

Limits a query to one source. Use the source’s index Name or Alias, shown under Index information on the source page. The query editor underlines _index in red, but the query works.

cc-advsearch-26-5-04-index-info.png

To filter by source without a query, use the Source column filter instead.

_index: a88c07a7-b189-4012-b479-8467703fc969 or

_index: city-of-oakhaven-0

<string field>.keyword

All string (text) fields also have an accompanying .keyword field. So the “name” field also has a “name.keyword” field.

The .keyword field is helpful if you want to find a value of a field that is an exact match of your search term. These fields don’t appear in the field suggestions.

If the value contains spaces you need to use quotation marks.

You can use a Truncation/Wildcard (*) but not combined with quotations.

name.keyword: "shinydocs copy.docx" or

name.keyword: *copy.docx or

name.keyword: shinydocs*

Find files whose name starts with something

A wildcard on name matches any word in the name, so name:junk* also finds Old junk.txt and Copy of junk.docx. To find only names that start with something, put the wildcard on name.keyword, which holds the whole name as one value.

Query

Finds

name.keyword:junk*

Names that start with “junk”, like junk.txt and junk_2024.zip. Not Junk.txt.

name.keyword:Junk*

Names that start with “Junk”, with a capital J.

name.normalized:junk*

Names that start with “junk” in any case: junk.txt, Junk.txt and JUNK.TXT.

name.keyword:old\ junk*

Names that start with “old junk”. Put a backslash (\) before each space. Quotation marks don’t work with a wildcard.

name.keyword is case-sensitive: name.keyword:junk* doesn’t find Junk.txt. To ignore case, use name.normalized, which stores every name in lowercase. The query editor underlines name.normalized in red, but the query works.

Words without a field

A word without a field, like budget, is looked for in the Catalog’s search fields: name, path, owner, extension, hash, email senders and recipients, document properties such as title and author, and the people and places found in the text. To change the list, go to Settings > Search, and under Where searches look, select Catalog.

Every word must match: budget minutes finds files with both words. To find files with either word, use OR: budget OR minutes. Because hash and email addresses are in the list, you can paste a file’s full hash or an email address on its own.

By default, the Catalog doesn’t search file contents, so fullText:budget finds nothing. To search contents in the Catalog, add fullText to the Catalog list under Settings > Search. Shinydocs Search always searches file contents.

Special characters in file names

These characters have a meaning in a query: ( ) [ ] { } : " \ / + - ! ^ ~ * ? and the space. To search for one in a name, put a backslash (\) before it.

For example, name.keyword:*\(1\)* finds names that contain “(1)”, like Report (1).docx. Without the backslashes, the parentheses group the query instead, and it finds very different files.

More search tips

To find

Example

Notes

Files where a field is empty

NOT _exists_:owner

Finds files with no owner. _exists_:owner finds files that have one. Works with any field.

Everything in a folder and its subfolders

path.keyword:*\\Finance\\Invoices\\*

Type each backslash in the path as two (\\). path.keyword matches case; path.normalized ignores it, as in path.normalized:*\\finance\\invoices\\*. The query editor underlines path.normalized in red, but the query works.

Names with one unknown character

name.keyword:HR-???\ *

? stands for exactly one character, and * for any number of characters. This finds names like HR-BEN - Policy.docx and HR-PAY Rates.xlsx.

Words with a typo

name:budgte~

~ also finds words spelled almost the same, like budget.

Several values in one field

extension:(pdf OR docx)

The same as extension:pdf OR extension:docx.

Values with no upper or lower limit

length:[10485760 TO *]

* at either end of a range leaves that end open. This is the same as length:>=10485760 (10 MB or larger).

Whole years, months or days

lastWriteTimeUtc:[now-1y/y TO now/y]

/y rounds to the start or end of a year, so this finds files modified last year or this year. Use /M for months and /d for days.