Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

How can one select user() and other session information

Recommended Posts

  • 1 month later...
  • 10 months later...

There are functions in /lib that can get e.g the current username and domain - you'd probably have to make them custom functions in order to use them the way you're looking to do.




TDV supports NOW() and other similar time functions out of the box, check the Reference Guide for the full SQL support information.

Link to comment
Share on other sites

  • 3 weeks later...

%CURRENT_USER%  is for Spotfire Current Log in user, for TDV, you need to define a procedurePROCEDURE sp_current_user(OUT CURRENT_LOGIN_USER VARCHAR(30))


   CALL /lib/util/getProperty('CURRENT_USER_NAME', CURRENT_LOGIN_USER);ENDcreate a view on top of it, publish to each VDB for easy access. 

Link to comment
Share on other sites

  • Create New...