Tridion Broker Query and Sorting Syntax

Introduction

Using the Content Broker, it is possible to search for components using a SearchFilter. The SearchFilter offers the possibility to search using a query language. However, this language is not documented anywhere. There are some examples in the Content Delivery Reference Guide, but no complete overview of possibilities. This article helps you a little bit, by giving an overview of query syntax and sorting syntax.

1. Query Syntax

Operator Meaning
& AND
| OR
; (OR) deprecated
= EQUALS
! NOT
!= NOT EQUALS
( Left paranthesis
) Right paranthesis

Note: Never use spaces around operators

Examples:

category=CallOuts&(keyword=Special Offer|keyword=Office Sale)

category!=Aaa&keyword=Bbb

2. Sorting Syntax

Column Alias Column
title TITLE
schema SCHEMA_ID
creationdate CREATION_DATE
modifieddate MODIFICATION_DATE
publishdate LAST_PUBLICATION_DATE
intialpublishdate INITIAL_PUBLICATION_DATE
category CATEGORY
keyword KEYWORD
id ITEM_REFERENCE_ID

 

Directory Alias Direction
asc Ascending
desc Descending



Note: Everything is case sensitive

Examples:

title=asc

publishdate=desc