search cancel

What is the Built in User Jaspersoft LoggedInUser paramater

book

Article ID: 244143

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

How can logged in user can be obtained from built-in parameters to qualify the available selection values on query-based input controls for report unit deployment in JasperReports Server.

Environment

Release : 16.0.2

Component :CLARITY

Resolution

The information can be found in TIBCO JasperReports® Server Administrator Guide Software Release 7.8 document, section "Built-in Parameters for Query-based Input Controls".

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v780/query-based-input-controls

For example:

select * from table where user_login_id = $P{LoggedInUserEmailAddress}