KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: Power your ORDA queries with query options
PRODUCT: 4D | VERSION: 17 R | PLATFORM: Mac & Win
Published On: December 28, 2018
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

Queries in ORDA are executed in dataclass.query() method. The query() method uses query string as its search criteria. The query string mainly contains three required parameters: attribute path, comparator, value and an optional logical Operator for joint queries. By utilizing these four parameters, developers can build queries with deep path and complex logic using dot notation. The syntax of query string is fairly new to many 4D developers and is different from query in 4D language. This tech note is aimed to provide best practices of building query strings and insights to some useful but lesser known query options.

Download Complete Tech Note: Tech Note Document

Commented by Toshiyuki Yamada on July 3, 2019 at 9:43 PM
Japanese version is available. (日本語版もあります。) https://4d-jp.github.io/tech_notes/19-06-11-ORDAPowefulQueries/