#1 2013-10-07 08:17:28

rijopius
Member
Registered: 2013-09-30

User Parameter in Dynamic List Report

Hi,

How to use user_id environment variable in the Dynamic List report to restrict  the SQL output as per user.
Please guide.

Thanks,
Rijo Pius

Offline

#2 2013-10-07 09:04:40

Marcel Berger
InfoFabrik
Registered: 2012-03-14
Website

Re: User Parameter in Dynamic List Report

Hi Rijo,

try this parameter  ${_RS_USER.xx}  to access the user properties and replace xx with: getFirstname(), getLastname(), getTitle(), getUsername(), getEmail() or getId().


If you are using the $P or $P! parameter use the following parameters:
    _RS_USER_FIRSTNAME
    _RS_USER_LASTNAME
    _RS_USER_TITLE
    _RS_USER_USERNAME
    _RS_USER_EMAIL
    _RS_USER_ID

kind regards
Marcel

Offline

#3 2013-10-07 11:10:48

rijopius
Member
Registered: 2013-09-30

Re: User Parameter in Dynamic List Report

Hi Marcel,

Thanks for your reply.
It's working fine now.

Thanks,
Rijo

Offline

#4 2014-12-12 09:35:46

cedispin
Member
Registered: 2014-12-12

Re: User Parameter in Dynamic List Report

Hi

Sorry, I understood where I could use this parameters. Do I use these parameters in Where clause?

I saw in User management the option User variable management, but I can't create or search a variable. Could I use it?

Do you have a example or sample about this configuration?

Regards

Cadu

Offline

Board footer

Powered by FluxBB