yuuvis® RAD Q&A

0 votes
by (140 points)

In esql it works like this but i get errors as term
BerGruppe='China' AND AvailableTill > currentdate()

How can i get the current date in a term or is it not possible?

In esql funktioniert die Abfrage wunderbar mit dem currentdate() aber leider bekomme ich es nicht in die Berechtigung/Klausel. Ist es nicht möglich oder muss ich es anders eingeben?

2 Answers

0 votes
by (2.8k points)

If you use this clause in a select/view right, this will not work, because the search-service is not able to resolve dynamic parts in a condition - like currentdate(). This clause works for Update or Delete rights.
Background: The search services uses access control lists to resolve the user view right. Condtions are not resolved.

by (140 points)
Thx for the answer.
So how can i do it?
The customer wants that the Person can see a Document, until the Date is not in past
0 votes
by (14.7k points)

Solution:
Add a status field. Set status field by job to corresponding value if date is reached.

...