Referencing logged-in-user attributes in a sql

0
Hi,

Does anyone know if it is possible to reference logged-in-user attributes in a sql?

Let's say I integrated JS with existing ldap and user entries have custom attributes assigned to them in the ldap tree.
Is there a way to reference them in a sql of a jrxml file?
Something like:

select f1, f2, f3 from table
where f4 = {user.attribute}

Thanks!
zhu001's picture
21
Joined: Jun 27 2008 - 4:20am
Last seen: 12 years 9 months ago

4 Answers:

0
mdahlman's picture
14552
Joined: Mar 13 2007 - 2:43am
Last seen: 6 years 5 months ago
0
Thank you for reply.
It looks like, it is possible reference user id, name, email, ..., but how about custom attributes like region id or company id. Which are defined externally in ldap tree. Looking at User object API (posted in that thread by swood), i don't see a method to call for custom attributes.

Please advice.
zhu001's picture
21
Joined: Jun 27 2008 - 4:20am
Last seen: 12 years 9 months ago
0

You refered a link is not working on your forum, please send text, please.

huw@trimet.org's picture
Joined: Feb 8 2007 - 9:24am
Last seen: 3 years 1 week ago
0

William Hu
Wrote:

You refered a link is not working on your forum, please send text, please.

The updated link is http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=35364

Regards,

Lucian

lucianc's picture
7382
Joined: Jul 17 2006 - 1:10am
Last seen: 3 weeks 7 hours ago
Feedback
randomness