Databases Reference
In-Depth Information
where P.PRODUCT ID = R.PRODUCT ID) NBR REVIEWS,
lower(CREATED BY) CREATED BY,
CREATED ON CREATED,
CREATED ON,
lower(UPDATED BY) UPDATED BY,
UPDATED ON UPDATED,
UPDATED ON
from AB PRODUCTS P
After adding this to my query, I need to visit the Report Attributes page and change the display type
of the column to Standard Report Column because each column is set as 'Display as Text (escape special
characters)' by default. Without the change, I would get the actual html displayed on the report (useful
when debugging) rather than a link. When I run the report, I again need to use Actions > Select Columns
to make the newly added Action column displayed, as shown in Figure 13-10.
Figure 13-10.
Report with dynamic link
Notice that this is the first time there has been null data within the report. If you do not like the
default display of “-”, you can access Report Attributes and, within the pagination region, remove the
Show Null Values as
value or add in something that works for you. Remember that this is used for all
null values within the entire report, so if you need a different value for different data (null for the Action
but “n/a” for something else), you would handle that within the SQL itself by using an
nvl
:
nvl(CATEGORY,'n/a') CATEGORY
So far, I added a column, but for this action to work, the page would need a
P7 PRODUCT ID
item and
a before header process to perform the update and then clear out the value that was passed.
update AB PRODUCTS
set AVAILABLE YN = 'Y'
where PRODUCT ID = :P7 PRODUCT ID;
:P7 PRODUCT ID := null;
