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?
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
Chris de Gelder
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.