This section will explain the different possibilities available for the creation date search values.
* Endpoint: /nuxeo/site/automation/Athento.DocumentResultSet/
* field: dc:created
* allowed operators: >, <, >=, <=, ==, LIKE
* allowed formats: %d-%m-%Y %H:%M:%S
For example, if we want to obtain all documents with a creation date prior to 1-1-2020, the corresponding query would look like this:
"SELECT ecm:uuid, dc:title, dc:created FROM Document WHERE
dc:created < '01-01-2020 00:00:00' "
|
For example, if we want to obtain all documents with a creation date before 1-1-2020 and after 23-12-2018 including that day, the corresponding query would look like this:
"SELECT ecm:uuid, dc:title, dc:created FROM Document WHERE
dc:created < '01-01-2020 00:00:00' AND dc:created >= '23-12-2018 00:00:00' "
|
Finally, for example, if we want to obtain all documents with exactly the same creation date on 23-12-2018 at 11:30, the corresponding query would look like this:
"SELECT ecm:uuid, dc:title, dc:created FROM Document WHERE
dc:created == '23-12-2018 11:30:00' "
|
or it is also possible to do it in this other way:
"SELECT ecm:uuid, dc:title, dc:created FROM Document WHERE
dc:created LIKE '23-12-2018 11:30:00' "
|
Comments
0 comments
Please sign in to leave a comment.