Query which delivers user data of current session

Sommer Johannes

November 22, 2019 08:58

Hi,

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.

Any ideas?

Best

Johannes

 

0

• 

  Lothar Hasenkämper

  November 22, 2019 13:04

  Hi Johannes,

   

  have a look at: this Post. It contians somethind simliar.

  regards

  Lothar

   

  0
• 

  Sommer Johannes

  November 22, 2019 14:23

  Hi Lothar,

  fine, using [%UserId] parameter in the where condition for selecting the logged in user dataset works in the print definition.

  thank you!

  Johannes 

   

  0

Please sign in to leave a comment.