Object Type Rights with Conditions

yuuvis® RAD designer 9.x »

Access to the folders and documents of a specific object type can be managed using object type rights. Object type rights are based on the object types set up in the system.

Object type rights can be linked to conditions. Conditions restrict access to individual instances depending on their metadata.

Rights are granted only if the condition is fulfilled. Object type rights are formulated in the database query language eSQL.

Conditions are created in yuuvis® RAD designer via the context menu of an assigned object type right. The object type rights that are possible for certain conditions are marked as such. Object type rights to which a condition has been assigned have additional markings.

Conditions consist of a technical field name, an operator, and a value.

Further information can be found in the developer area.

Examples

String fields:

technicalname = 'Value'
technicalname <> 'Value'
technicalname in ('Value1', 'Value2')
technicalname LIKE 'W%'
technicalname is not null

Number fields:

technicalname = 5
technicalname <= 5

Decimal number fields:

technicalname >= 5.9

Date fields:

technicalname = date'1921-12-18'
technicalname <= date'1921-12-18'

Date/time fields:

The individual components can be omitted starting from the right and then interpreted as the smallest possible value.

technicalname = datetime'2006-11-26 18:52:35'

Boolean fields:

technicalname = true
technicalname = false

Catalog fields

technicalname = 'Catalog value'
technicalname <> 'Catalog value'
technicalname inCodeSystemData ('Catalog value1', 'Catalog value2')

Blank fields:

technicalname is null
technicalname is not null

Linking conditions:

All conditions can be linked with AND, OR, and NOT as required.

technicalname1 = 'Value' AND technicalname2 <= date'1971-12-18'

dateAdd function:

Time spans with date and date/time values can be added using the dateAdd function.

dateadd(day,14,technicalname1) <= technicalname2
dateadd(day,-14,technicalname1) <= technicalname2

The units day, year, month, and week are possible for date fields, while hour, minute, and second are additionally possible for date/time fields. Negative values are also permitted.

If a date is entered in a date field, then the local date is not saved in the database; the time in GMT is stored there. The relevant local time is then shown in yuuvis® RAD client based on the saved GMT time. This could result in a one-day difference between two time zones, particularly along the date line.