Intended Audience for this Feature

All Users

What is Logical Search?

Logical search is a search technique that narrows down the information you want by expressing multiple keywords using logical operators or labels in a specific syntax.

Types of Searches

Fuzzy Search

Fuzzy Search calculates the closeness between the keyword and the target word, and returns results in order of closeness. Keywords are broken down and matched, so even if words do not exactly match the keyword, those with minor differences in case, spelling, or notation may be considered similar and included in the search results.

Phrase Matching Search

Phrase Matching Search treats the keyword as a single phrase and returns results where the word order and combination match.

Starting a Logical Search

To perform a logical search, enter a single quotation mark (') in the search bar followed by the search expression.

The following search expression performs a phrase matching search for the keyword "給与マスタ".

'"給与マスタ"

The following search expression performs a fuzzy search for the keyword "給与マスタ".

'給与マスタ

Search Syntax

In logical search, enter a search expression in the search bar composed of the following elements:

• Value
• Label
• Logical operator

Specifying Values

For Phrase Matching

To match a value as a phrase, enclose the value in double quotation marks (").

Case Study
Suppose there is an asset in the catalog with the logical name 給与グレードマスタ.

The following search expression performs a phrase matching search for the keyword 給与マスタ. Since the asset 給与グレードマスタ does not match the value, it will not be included in the results.

'"給与マスタ"

For Fuzzy Matching

To perform a fuzzy match, enter the value as is.

Case Study
Suppose there is an asset in the catalog with the logical name 給与グレードマスタ.

The following search expression performs a fuzzy search for the keyword 給与マスタ. Since 給与グレードマスタ is decomposed and considered semantically similar, it will be included in the results.

'給与マスタ

Notes

Depending on the label, some only support phrase matching. In such cases, even if you enter the value without quotes, a fuzzy search will not be performed.

Case Study
The asset_group label is designed to perform only phrase matching searches using the specified value.

For example, suppose there is an asset group HR-Master in your tenant.
The following search expression searches for assets in asset groups that exactly match HR-Master as a phrase. The asset_group label is set to perform only phrase matching searches, even if the value is not enclosed in double quotes. Therefore, the HR-Master asset group will be included in the results.

'asset_group:HR-Master

The following search expression searches for assets in asset groups that exactly match HR as a phrase. The asset_group label performs only phrase matching searches, even if the value is not enclosed in double quotes, and does not perform fuzzy searches. Therefore, the HR-Master asset group will not be included in the results.

'asset_group:HR

Labels

To explicitly indicate that the value in the search expression is specific metadata, use the following format with a label:

• Connect the label and value with a colon (:). The label and colon should be written consecutively (do not insert a space between the label and the colon).

label:value

• All labels must be written in lowercase. (Uppercase or mixed case will not work.)
• The types of labels are as follows:

asset_group

A label that indicates the value is an asset group.

Format
asset_group:value

• Asset groups that exactly match the phrase in value are targeted. (Fuzzy search is not performed.)
• If the asset group name contains spaces, enclose the entire value in double quotes.

Example
The following search expression searches for assets in asset groups that exactly match 人事データ as a phrase.

'asset_group:人事データ

category

A label that indicates the value is a custom category name.

Format
category:value

• Custom category names that exactly match the phrase in value are targeted. (Fuzzy search is not performed.)
• If the custom category name contains spaces, enclose the entire value in double quotes.

Example
The following search expression searches for assets in custom categories that exactly match マーケティング as a phrase.

'category:マーケティング

parent_tag

A label that indicates the value is a parent tag name.

Format
parent_tag:value

• Parent tag names that exactly match the phrase in value are targeted. (Fuzzy search is not performed.)
• If the parent tag name contains spaces, enclose the entire value in double quotes.

Example
The following search expression searches for assets with parent tag names that exactly match 情報区分 as a phrase.

'parent_tag:情報区分

tag

A label that indicates the value is a child tag name.

Format
tag:value

• Child tag names that exactly match the phrase in value are targeted. (Fuzzy search is not performed.)
• If the child tag name contains spaces, enclose the entire value in double quotes.

Example
The following search expression searches for assets with child tag names that exactly match 個人情報あり as a phrase.

'parent_tag:個人情報あり

prop

The prop label indicates that the value is a custom property name. Two types of syntax can be used in the search expression.

Format 1 - Match by custom property name
prop:value

• Targets custom property names that match value. Both phrase match and fuzzy search can be specified.
• To perform a phrase match search with value, enclose value in double quotes. For fuzzy search, specify value without double quotes.
• Note that if value is specified without double quotes, a fuzzy search will be performed.

Example
The following search expression performs a fuzzy search for custom property names similar to データ由来.

'prop:データ由来

Format 2 - Match by custom property name and its value (custom property value)
prop:name:value

• About name
  • Targets custom property names that exactly match the phrase in name. (Fuzzy search is not performed.)
  • If the custom property name contains spaces, enclose the entire name in double quotes.
• About value
  • Targets custom property values that match value. Both phrase match and fuzzy search can be specified.
  • To perform a phrase match search with value, enclose value in double quotes. For fuzzy search, specify value without double quotes.
  • Note that if value is specified without double quotes, a fuzzy search will be performed.

Example
The following search expression searches for assets with a custom property that exactly matches データ由来 as a phrase, and whose property value exactly matches 旧人事システム as a phrase.

'prop:データ由来:"旧人事システム"

prop_value

A label that indicates the value is a custom property value.

Format
prop_value:value

• Targets custom property values that match value. Both phrase match and fuzzy search can be specified.
• To perform a phrase match search with value, enclose value in double quotes. For fuzzy search, specify value without double quotes.
• Note that if value is specified without double quotes, a fuzzy search will be performed.

Example
The following search expression performs a fuzzy search for assets with custom property values similar to 2026年.

'prop_value:2026年

asset_type

A label that indicates the value is an asset type.

Format
asset_type:value

• Asset types that exactly match the phrase in value are targeted. (Fuzzy search is not performed.)

Types of Values
Specify one of the following as the value. Note that values are case insensitive.

• schema
  Schema of DB data
• table
  Table of DB data
• column
  Column of DB data
• bigroup
  BI group of BI data
• dashboard
  Dashboard of BI data
• sheet
  Sheet of BI data
• etl
  ETL data asset (type is ETL only)

Example
The following search expression searches for assets with the asset type table (table).

'asset_type:table

data_source

A label that indicates the value is a data source name.

Format
data_source:value

• Data source names that exactly match the phrase in value are targeted. (Fuzzy search is not performed.)
• If value is in the alphabet, case is distinguished.
• If the data source name contains spaces, enclose the entire value in double quotes.

Example
The following search expression searches for assets in data sources that exactly match new-hr-system as a phrase.

'data_source:new-hr-system

data_source_type

A label that indicates the value is a data source type.

Format
data_source_type:value

• Data source types that exactly match the phrase in value are targeted. (Fuzzy search is not performed.)

Types of Values
Specify one of the following as the value. Note that values are case insensitive.

• agent
  Data source is an agent data source
• csv
  Data source is a csv data source

Example
The following search expression searches for assets in csv data sources.

'data_source_type:csv

desc

A label that indicates the value is an asset description.

Format
desc:value

• Targets asset descriptions that match value. Both phrase match and fuzzy search can be specified.
• To perform a phrase match search with value, enclose value in double quotes. For fuzzy search, specify value without double quotes.
• Note that if value is specified without double quotes, a fuzzy search will be performed.

Example
The following search expression searches for assets with a description that exactly matches 新人事システム移行前の暫定情報 as a phrase.

'desc:"新人事システム移行前の暫定情報"

logical

A label that indicates the value is a logical name of an asset.

Format
logical:value

• Targets logical names that match value. Both phrase match and fuzzy search can be specified.
• To perform a phrase match search with value, enclose value in double quotes. For fuzzy search, specify value without double quotes.
• Note that if value is specified without double quotes, a fuzzy search will be performed.

Example
The following search expression performs a fuzzy search for assets with logical names similar to 給与マスタ.

'logical:給与マスタ

physical

A label that indicates the value is a physical name of an asset.

Format
physical:value

• Targets physical names that match value. Both phrase match and fuzzy search can be specified.
• To perform a phrase match search with value, enclose value in double quotes. For fuzzy search, specify value without double quotes.
• Note that if value is specified without double quotes, a fuzzy search will be performed.

Example
The following search expression searches for assets with physical names that exactly match EMP as a phrase.

'physical:"EMP"

service

A label that indicates the value is a service name.

Format
service:value

• Targets service names that exactly match the phrase in value. (Fuzzy search is not performed.)

Types of Values
Specify one of the following as the value. Note that values are case insensitive.

• alteryx
• athena
• azure_sql
• azure_synapse
• bigquery
• databricks
• denodo
• impala
• ms_fabric
• mysql
• oracle
• postgres or postgresql
• powerbi
• redshift
• snowflake
• sql_server
• tableau
• teradata
• treasure_data
• other
   

Example
The following search expression searches for assets with the service name Snowflake. (Case is not distinguished, so mixed case is allowed.)

'service:Snowflake

Logical Operators

Logical search uses the concept of "sets" in mathematics. Use the following logical operators to narrow down the information to be searched.

In the following diagrams, A and B are search expressions (expr) or keywords. Expressions can be written using labels.

AND Operator

Targets items that contain all keywords of both A and B. The AND operator can be omitted.

• Operators must be written in uppercase. (Lowercase will not work.)
• The AND operator is processed before the OR operator. (If the search expression for OR is not grouped.)

Format Example
expr-A AND expr-B or expr-A expr-B

keyword-A AND expr-B or keyword-A expr-B

Example
The following is an example of expr-A AND expr-B. Assets with a data source type of csv and a logical name that exactly matches 従業員 as a phrase are included in the results.

'data_source_type:csv AND logical:"従業員"

The following is an example of keyword-A expr-B (AND operator omitted). Assets similar to the keyword 営業 (with a high fuzzy search score) and with the child tag 個人情報あり attached are included in the results.

'営業 tag:個人情報あり

OR Operator

Targets items that containeither keyword of A or B.

• Operators must be written in uppercase. (Lowercase will not work.)

Format Example
expr-A OR expr-B

keyword-A OR expr-B

Example
The following is an example of expr-A OR expr-B. Assets with a data source type of csv or with a logical name that exactly matches 従業員 as a phrase are included in the results.

'data_source_type:csv OR logical:"従業員"

The following is an example of keyword-A OR expr-B. Assets similar to the keyword 営業 (with a high fuzzy search score) or with the child tag 個人情報あり attached are included in the results.

'営業 OR tag:個人情報あり

- Operator (NOT Operator)

Items that do not contain the keyword Bare excluded from the results.

• In QDIC,the NOT logical operator isrepresented by a minus sign (-). (NOT is not used.)
• The operator (-) and the expression or keyword must be written consecutively (do not insert a space between the operator and the expression or keyword).

Format Example

-expr-B

keyword-A AND -expr-B

Example
The following is an example of -expr-B. Assets whose logical name does not exactly match 従業員 as a phrase are included in the results.

'-logical:"従業員"

The following is an example of keyword-A -expr-B. Assets similar to the keyword 営業 (with a high fuzzy search score) but without the child tag 個人情報あり attached are included in the results. (The AND operator is omitted.)

'営業 -tag:個人情報あり

Grouping Expressions

To group search expressions, enclose the expressions in parentheses (half-width characters).

Examples of Grouping

• A OR (B AND C)
  This means either B and C, or A.
  Note that this is the same as A OR B AND C because the AND operator is processed before the OR operator.
• (A OR B) AND C
  This means either A or B, and also C.
• (A AND -B) AND (C OR D)
  This means A but not B, and either C or D. You can also specify the NOT operator (represented as -) within grouped search expressions (B in this example).

Notes

In logical search, the search is not executed until you press the Enter key in the search bar. In other words, suggestions will not be displayed while you are entering the search expression. After entering a search expression and pressing the Enter key in the search bar, the search results will be displayed in the Asset List panel.