Versions Compared

Old Version 18

changes.mady.by.user Technische Redaktion

Saved on

compared with

New Version Current

changes.mady.by.user Mr. Schmittberger

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The rights granted via a role in the yuuvis® RAD 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.

...

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 ED01B5E5996648088D0A474C37962C93.

longnumber = 123456789LThe 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 orderstable has a row in which the order column has the value order4711. 
This also applies to multi-tagging fields which are technically a table with one column. In this case, any element has to have the value order4711. ← Valid for versions <= 8.16 LTS

ordersset containsrowwithcondition(order = 'order4711')

ordersset containsrowwithcondition(order IN ('order4711','value0815'))

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 ordersset contains an element (chip) with the technical element name  order that has the value order4711 (first example) or the values order4711 or value0815 (second example).

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.