Hi all, I want to select a specific record owner in a OQL statement. My statment is as follows: SELECT Object.number AS number, Object.name AS name, Object.dateorder AS Dateorder $System.owner AS Ownername FROM order.orders AS Object However the above does not work but i do not understand why?
asked
R. Somers
2 answers
1
Mm, it looks like System.owner is not available in OQL. As a workaround create an extra attribute and save the owner name in that in a before commit event.
Retrieve the user with condition
[id=$Object/System.owner]
answered
Chris de Gelder
0
Thx... for the help. I tryed your solution but it diden't work for me. If added the record owner as a entity attribute and it does work now.