1. Helpdesk
  2. Community
  3. Coresuite Designer

Query which delivers user data of current session

Avatar
Sommer Johannes
Follow

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

Comments

2 comments
Sort by Date Votes
  • Avatar
    Lothar Hasenkämper

    Hi Johannes,

     

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

    regards

    Lothar

     

    0
    Comment actions Permalink
  • Avatar
    Sommer Johannes

    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
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post