SmartHub Query Syntax

SmartHub uses SmartHub Query Language for building search queries.

A SmartHub Query Language query consists of one or more of the following elements:

  • Free text or keywords(words or phrases)

  • Property restrictions

You can combine SmartHub Query Language query elements with one or more of the available operators.

Free text SmartHub Query Language queries are case-insensitive but the operators must be in uppercase.

You can construct SmartHub Query Language queries by using one or more of the following as free-text expressions:

  • A word includes one or more characters

  • A phrase includes two or more words together, separated by spaces enclosed in double quotation marks

To construct complex queries, you can combine multiple free-text expressions with SmartHub Query Language query operators. 

SmartHub Query Language Query Operators

If there are multiple free-text expressions without any operators in between them, the query behavior is the same as using the AND operator.

Operator Description Syntax Unsupported backends
 AND Returns search results that include all of the free text expressions, or property restrictions specified with the AND operator

<Expression1> AND <Expression2> 


Example:

DisplayAuthor:"Tony" AND date>2022-01-01


NOT Returns search results that don't include the specified free text expressions or property restrictions. <Expression1> NOT <Expression2> 
  • Microsoft Search
OR Returns search results that include one or more of the specified free text expressions or property restrictions.

<Expression1> OR <Expression2> 


Example:

DisplayAuthor:"Tony" OR DisplayAuthor="George"


NEAR The NEAR operator matches the results where the specified search terms are within proximity to each other, without preserving the order of the terms.

<Term> NEAR(n=4) <Term> 


Example:

"acquisition" NEAR(n=4) "debt"


Note: Combination with wildcard operators is not supported

  • Kendra
  • Egnyte
  • PubChem
  • Microsoft Search
ONEAR The ONEAR operator matches the results where the specified search terms are within close proximity to each other while preserving the order of the terms. 

<Term> ONEAR(n=4) <Term>


Example:

"acquisition" ONEAR(n=4) "debt"


Note: Combination with wildcard operators is not supported

  • Kendra
  • Egnyte
  • Documentum
  • NetDocs
  • PubChem
  • Microsoft Search
* The wildcard operator enables prefix matching

<Term>*


Example:

Tes*

  • Egnyte
  • RightFind
  • PubChem
  • Microsoft Search
? The wildcard operator enables prefix matching

<?erm>


Example:

?est

  • Kendra
  • Egnyte
  • Documentum
  • SPO
  • PubChem
  • Microsoft Search
  • Disqover
  • Azure
XRANK The XRANK operator boosts the dynamic rank of items based on certain term occurrences within the match expression, without changing which items matches the query.

<match expression> XRANK(cb=100) <rank expression>


Example:

title:Advanced XRANK(cb=1) title:Search

  • Kendra
  • Egnyte
  • RightFind
  • Disqover
  • Documentum
  • PubChem
  • Microsoft Search

SmartHub Query Language Query Property Restrictions

Operator Data Type Description Syntax/Example Unsupported backends
<

  • Number

  • DateTime

 Returns results where the property value is less than the value specified in the property restriction. date<2022-01-01

  • Microsoft Search
:

  • Text

  • Number

  • Boolean

 Returns results where the value specified in the property restriction is equal to the property value, or matches individual terms in the property value that is stored in the full-text index. title:"Andrei"  
<>

  • Text

  • Number

  • Boolean

 Returns search results where the property value does not equal the value specified in the property restriction. size<>10000

  • Microsoft Search
=

  • Text

  • Number

  • Boolean

 Returns search results where the property value is equal to the value specified in the property restriction. title="George"  
>=

  • Number

  • DateTime

 Returns search results where the property value is greater than or equal to the value specified in the property restriction. date<=2022-01-01

  • Microsoft Search
>

  • Number

  • DateTime

 Returns search results where the property value is greater than the value specified in the property restriction. date>2022-01-01

  • Microsoft Search
<=

  • Number

  • DateTime

 Returns search results where the property value is less than or equal to the value specified in the property restriction. date<=2022-01-01

  • Microsoft Search

All date/time values must be specified according to the UTC (Coordinated Universal Time), also known as GMT (Greenwich Mean Time) time zone.

Date values do not support quotes:

Example of invalid property restriction for date:

date<"1900-01-01"

The following ISO 8601-compatible datetime formats are supported in queries:

  • YYYY-MM-DD