Get record owner in OQL

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

answered