The rights granted in a role of the yuuvis® rights management can be accompanied by a clause that further refines them. The clause represents the "where ..." part of an eSQL statement. So any clause will be constructed as follows: "select * from dms:typename where <clause>". This page gives you examples of the possible clauses that can be used in this context.
It is important to know that the rights controlling the visibility of an object - 'Available' and 'Display' - will be precompiled and written to the Elasticsearch database. Thus, statements with dynamic parts such as currentuserid() or dateadd() will not work for these rights!
...
- The field sysitemcreationdate selects the creation date of the entire object (item). syscreationdate selects the creation date of the active version.
- The datetime identifier takes input of the form "yyyy-mmMM-dd hh:mm:ss". The only required part is "yyyy" but all left out parts will be autocompleted with 00
- Object type names and element (field) names are accessed by their technical name
Clause | Description |
|---|---|
| sysitemcreationdate <= datetime'2018-01-23 13:14:15' | The right will be granted to all objects (of the corresponding object type) that were created before or exactly on January 23, 2018, 13:14:15. |
syscreationdate < datetime'2018-07' | The right will be granted to all objects (of the corresponding object type) that were created and last modified before July 1, 2018, 00:00:00. |
| customfield1 = 'acknowledged' and customfield2 < datetime'2018-02-01' | The right will be granted to all objects (of the corresponding object type) where customfield1 has the value 'acknowledged' and customfield2 contains a date that is January 31, 2018, 23:59:59.999 or earlier |
| sysitemcreationdate <= dateadd(day, -7, currentdatetime()) | The right will be granted to all objects (of the corresponding object type) that were created a week ago from now (including the time) or earlier. WARNING: This is a dynamic statement. Do not use this for the 'Available' or 'Display' right. |
...
Statement | Description |
|---|---|
| sysitemid = id'ED01B5E5996648088D0A474C37962C93' | The right will be granted to the object (of the corresponding object type) that has the item ID "ED01B5E5996648088D0A474C37962C93" |
| longnumber = 123456789L | The right will be granted to all objects (of the corresponding object type) where the field "longnumber" has the value 123456789. |
| string1 = 'ipsum' | The right will be granted to all objects (of the corresponding object type) where the field "string1" has the value "ipsum". |
| catalogfield = 'english' | The right will be granted to all objects (of the corresponding object type) where the field "catalogfield" has the catalog entry with data value "english". |
| orderstable containsrowwithcondition(orderstablerecord.order = 'order4711') | The right will be granted to all objects (of the corresponding object type) where the table "orderstable" has a row where the column order has the value "order4711". |
...