Item Value not used

Customer id

Customer Id	Cust First Name	Cust Last Name	Cust Street Address1	Cust Street Address2	Cust City	Cust State	Cust Postal Code	Cust Email	Phone Number1	Phone Number2	Url	Credit Limit	Tags
1	John	Dulles	45020 Aviation Drive		Sterling	VA	20166	john.dulles@email.com	703-555-2143	703-555-8967	http://www.johndulles.com	1000
2	William	Hartsfield	6000 North Terminal Parkway		Atlanta	GA	30320		404-555-3285			1000	REPEAT CUSTOMER
3	Edward	Logan	1 Harborside Drive		East Boston	MA	02128		617-555-3295			1000	REPEAT CUSTOMER
4	Frank	OHare	10000 West OHare		Chicago	IL	60666		773-555-7693			1000
5	Fiorello	LaGuardia	Hangar Center	Third Floor	Flushing	NY	11371		212-555-3923			1000
6	Albert	Lambert	10701 Lambert International Blvd.		St. Louis	MO	63145		314-555-4022			1000
7	Eugene	Bradley	Schoephoester Road		Windsor Locks	CT	06096		860-555-1835			1001	REPEAT CUSTOMER

1 - 7

SQL Query:

SELECT *
  FROM DEMO_CUSTOMERS
 WHERE :P4_CUSTOMER_ID IS NULL
    OR CUSTOMER_ID = :P4_CUSTOMER_ID

When choosing a Customer Id from the Select List and clicking the Search Button, the Report will be refreshed through a Dynamic Action.

BUT: The chosen Customer Id is not used as Filter, although it is used in the SQL Query.

Switching on DEBUG and clicking the Search Button shows, that the Report is actually refreshed and it also shows the executed SQL Query, where we can see a reference of P4_CUSTOMER_ID.

What the Debug Output doesn't show, is a value for P4_CUSTOMER_ID, because it is NULL.

Checking the Session State of P4_CUSTOMER_ID through click on "Session" in the Developer Toolbar confirms that the value isn't set.

The Solution to this problem is specifying P4_CUSTOMER_ID in "Page Items to Submit" in the Report.

After doing that, you can see the session state is changed when clicking the search button.

Item Value not used

Notes