The single rights granted in via a role of in the yuuvis® RAD rights management can be accompanied by a clause that further refines itthem. The clause represents the "where ..." 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 - object – 'Available' and 'Display' - – will be precompiled and written to the elasticsearch Elasticsearch database. Thus, statements with dynamic parts such as currentuserid() or dateadd() will not work for these rights!.
...
Selecting Objects by
...
Date/Time Criteria
| Info | ||
|---|---|---|
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
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 at 23rd on January 23, 2018, 13:14:15 o'clock. |
| The right will be granted to all objects (of the corresponding object - type) that were created and last modified before 1st July 1, 2018, 00:00:00 o'clock. |
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 31st 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 or earlier ( from now (including the time) or earlier. WARNING: This is a dynamic statement. Do not use this for the 'Available' or 'Display' right. |
...
Selecting Objects by Creator Criteria
Statement | Description |
|---|---|
exists (select 1 from sysversionedcreationtraceOwner2user syscreationtraceOwner2user r join org:sysuser u where r.sysid1=sysid and ru.sysid2sysname='user4711') | The right will be granted to all objects (of the corresponding object - type) where the creator of the currently active version was |
exists (select 1 from sysversionedcreationtraceOwner2user syscreationtraceOwner2user r where r.sysid1=sysid and r.sysid2=currentuserid()) | The right will be granted to all objects (of the corresponding object - type) where the creator of the currently active version was the currently logged-in user. WARNING: This is a dynamic statement. Do not use this for the 'Available' or 'Display' right. |
exists (select 1 from sysversionedcreationtraceOwner2user r where r.sysid1=sysid and r.sysid2='user4711' and sysversionumber=1) | The right will be granted to all objects (of the corresponding object - type) where the creator of the first version was user4711was user4711. This means user4711 created means user4711 created the (the first version of the) item. |
...
Selecting Objects by Index Data/ID
Statement | Description |
|---|---|
sysitemid = id'ED01B5E5996648088D0A474C37962C93' | The right will be granted to the object (of the corresponding object |
type) |
with the item |
ID |
. | |
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 |
| a 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 |
|
has a row |
in which the |
has the value |
|
. |
element has to have the value | |
| Valid for versions >= 9.0 The right will be granted to all objects (of the corresponding object type) where the field of type SET[string] (multi-tagging) with the technical name |
technical element name | |
field1='value1' and exists (select 1 from folder f where f isParentOf doctype and f.folderfield = 'value2') | The right will be granted to all objects of type doctype where the field field1 has the value value1 and where its parent object (folder type with technical name folder) has the value value2 in the field folderfield on the folder type.Pay attention that the right side of the isParentOf operator is the technical name of the document type that you are editing this clause for. |