How do I Set Ad-Hoc View, to filter acording to loged in language ?

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Ok so When a user creates a Ad-Hoc report, it will bring back data from All languages (Yes I know the user can manually filter by language)

I need to change the jasper code so that the Ad-Hoc view will automatically only show data according to logged in language

So if you are logged in, in English and create a Ad-Hoc view, it will only bring back English data

Note: The database is setup so that I can just use

Where language_id = 3
-- 3 = English (this will change depending on logged in language)

and it will show the correct data for that language

So what I am asking is, how can I change the Jasper-server code so that it automatically filters all Ad-Hoc reports by

Where language_id = logedInLanguageID

andre.erasmus's picture
Joined: Mar 19 2013 - 2:33am
Last seen: 6 years 2 months ago

0 Answers:

No answers yet
Feedback