Databases Reference
In-Depth Information
END "Status"
, page name "Page"
, public response "Response"
FROM apex team feedback
WHERE application id = :APP ID
ORDER BY updated on DESC
Figure 4-30 shows what the report page you're trying to achieve will look like.
Figure 4-30.
Feedback response report
To get that result, you have to make some minor changes. First, the column Follow Up in Figure 4-
30 is used as a Link Column. Set the Link Text to the image of your liking and set the URL target to
javascript:FollowUp( '#Follow up#');
. The Javascript function is defined in the Function and Global
Variable Declaration section of the page as
function FollowUp( pId ){
$s('P103 FEEDBACK ID', pId);
$('#FollowUp').show();
}
Within the same page, create a new HTML Region named FollowUp with two items:
P103 FEEDBACK ID
and
P103 FOLLOW UP
. Set the Static ID of the region to FollowUp, and set the Region
Attributes to
style="display:none; width:540px"
. So, the region will be hidden by default and shown
when a user clicks the little edit image in the report. Also create a Region Button there to submit the
page.
Next, create an On Submit Page Process to save the follow up on the feedback using the
apex util.submit feedback followup
procedure, as shown in Figure 4-31.
