how to display logged user name in .qvw file

[Anonymous]

Hi

We would like to filter the data based on logged in user. We are planning to use logged in user id in all queries.

1. is there any other approach to filter based on logged in user?

2. or how to get user id and use it in queries?

Thanks.

[er_mohit · Accepted solution]

write

=osuser()  in text object

[amit_saini]

Prakash,

Please follow this:

Re: How can I see the names of the users?

Thanks,

AS

[aveeeeeee7en]

Hi Prakash

You can use OSUSER() OR QVUSER() Function.

In order to filter the data based on Logged in User you can implement Section Access in the Application based on individual Users.

Regards

Aviral Nag

[sudeepkm]

Section Access is your solution.

Section Access table will make sure the filter of data when the user logins.

ACCESS NTNAME REGION

USER      USER1    EAST

USER      USER2    NORTH

So when user 1 login then he/she will only see Eastern region data and when User 2 login he/she should see Northern region data.

Attached document talks more about section access.