Jump to content
We've recently updated our Privacy Statement, available here ×

Can LoggedInUsername be used to populate a query


NCHASHIM
Go to solution Solved by NCHASHIM,

Recommended Posts

My report has a number of parameters, the last of which is PLANNER_AUIC_LIST to be used in this portion of the query's where clause
    $X{IN, lurn2.auic, PLANNER_AUIC_LIST} 


I am trying to populate the PLANNER_AUIC_LIST collection by this query
select 
UNIT_IDENTIFICATION_CODE
FROM (SELECT *
      FROM (SELECT DISTINCT
              uic AS UNIT_IDENTIFICATION_CODE
            from owsADHOC.adhoc_planner_rpt_uic_list
            where JASPER_ACCOUNT = $P{LoggedInUsername}
            ORDER BY UIC)
            )


I verified that $P{LoggedInUsername} is returning the expected value by temporaily sticking the value in the header.  
The parameter PLANNER_AUIC_LIST is only displaying the final record returned by the query.  (I tried replacing all of the values and noticed that it only display one value--the last--no matter what is in the table.)

What am I missing?   Can LoggedInUsername not be used a a query parameter?

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...