1 Reply Latest reply: Oct 11, 2017 8:59 AM by Marcus Sommer RSS

    How to lookup a table on UI as expression

    Sagar Rao

      Hi,

       

      I have users table with Domain\UserName, Role loaded in memorry, When a user access the application through access point, the application should display his role on UI using his username who access the application on fly without using section access. Is it possible ?

        • Re: How to lookup a table on UI as expression
          Marcus Sommer

          You could use osuser() which will return the NTNAME of the user to identify them. To this you will need a mapping respectively a linked table to Role (and Domain\UserName if they are different to NTNAME). And Role could you display with an expression like:

           

          only({< [Domain\UserName] = {"$(=osuser())"}>} Role)

           

          - Marcus