JasperSoft Server - get atrributes user

[Kamikaz0r]

0

 

i have the installed Jasper Server , where i have create the follow attributes for the user joeuser , the attributes that i create its called/value .

name :company1 value : 1

name :company2 value : 2

how could i retrieve this on my parameters ? when i use

$P{LoggedInUserAttributeValues}.iterator().next() , i get only the values: 1 , but how could i get the value of company2 ?

i tried do something like '$P{LoggedInUserAttributeValues}.iterator().next().next()' , but dont return nothing.

what i wanna it's receive the values and use inside my query Builder IN Clause.

[yama818]

It may be good to write as follows

LoggedInUserAttribute_<attribute name>

ex)

LoggedInUserAttribute_company1

LoggedInUserAttribute_company2
 

Reference URL

https://community.jaspersoft.com/questions/538920/profile-attributes-within-main-query

[yama818]

.

[Kamikaz0r]

Hello , i tried put on my Database query 

 

SELECT * FROM viewTest
WHERE $X{IN,COMPANY,LoggedInUserAttribute_company}

 

but return me a error on JasperServer

 

"

Error message There was an error on the server. Try again or contact the site administrators. (Error UID: d8b35d11-ee82-4c61-aae6-f1746b5e95ca)" 

the same error occured when i try this database query

"SELECT * FROM viewTest
WHERE COMPANY LIKE LoggedInUserAttribute_company1"

 

[yama818]

As shown in the linked post.
'$X' can only be used for multiple return parameters.
So you need to use '$P'.

ex1)
SELECT * FROM viewTest
WHERE COMPANY = $P{LoggedInUserAttribute_company}

ex2)
SELECT * FROM viewTest
WHERE COMPANY = $P{LoggedInUserAttribute_company1}
   OR COMPANY = $P{LoggedInUserAttribute_company2}