Query which delivers user data of current session
in order to generate the mail signature for the mail text and the sender mail address of the logged in user, I need a SQL query for the documents print definition which selects this data. Currently we use the document owner data, but in some cases it does not fit.
have a look at: this Post. It contians somethind simliar.
fine, using [%UserId] parameter in the where condition for selecting the logged in user dataset works in the print definition.
Please sign in to leave a comment.