How to lookup a table on UI as expression

[tsagarrao]

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 ?

[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