#Like ilike sql iso
DATE : a date in ISO format yyyy - _MM_ - _dd_, converted internally to a timestamp by adding 00:00:00 to it.Ī is a non empty comma-separated list of.TIMESTAMP : a timestamp in ISO format yyyy - _MM_ - _dd_ _hh_ : _mm_ : _ss_ (the space separator can be replaced by a T).The special \n, \r and \t can also be used. The backslash itself is also escaped by a backslash ( \\ ). To use the string delimiter itself inside the string, it must be escaped by a backslash ( \' or \") (this is contrary to the standard SQL syntax which would double the delimiter). : a string delimited by single quotes ( ') or for Java compatibility double quotes ( ").For instance dc:description '' will never match any document, and dc:description IS NULL will also match for an empty description. ( LIKE| ILIKE) (only between an and a )īe careful with Oracle when comparing a value with an empty string, as in Oracle an empty string is NULL.(or != for Java compatibility and to make it convenient to write XML files).
![like ilike sql like ilike sql](https://i.pinimg.com/originals/c2/89/6b/c2896b611e5f62fa9a99d9dd1a9bbf86.jpg)
The optional is a comma-separated list of, each one being optionally followed by ASC or DESC ( ASC is the default). The is a comma-separated list of document types. The is a comma-separated list of, or since Nuxeo 5.9.2.Ī is a Nuxeo document property name, for instance dc:modified, or a special properties, for instance ecm:uuid (see below).Īn is of the form ( _ ) (available since Nuxeo 5.9.2, see NXP-13708). The general syntax of a NXQL expression is: SELECT (*| ) FROM