We have facilitated the users of our application to send feedback to the development team. However, we have not implemented an option for the team to receive follow-up information about their feedback yet.
There are several possibilities to return follow-up information to the user. The least appealing would be to create a new APEX account for the user so he can look into Team Development himself.
Another option would be to return an e-mail whenever a follow-up is produced.
A third option that we will explain further in this recipe is to build a page using built-in APEX views.
Make sure that the environment created in the previous recipe on 'Using Feedback' is available.
In the first place, we have to create some follow-up.
Now, we have to communicate this new information to the user.
First, we'll build a simple Interactive Report to show all feedback given by the current user.
select feedback_id , feedback_number , feedback , public_response from apex_team_feedback where logging_apex_user = :APP_USER
[1346_12_01.sql]
We now have a page that will show some information about the logged feedback that the application user has added.
Now, we'll create a page to show the follow-ups for this feedback.
select follow_up from apex_team_feedback_followup where feedback_id = :P7_FEEDBACK_ID
[1346_12_02.sql]
Now, we just have to link the two pages together.
As we can see, the feedback we entered in the recipe Using Feedback in this chapter is shown.
Press the link on the Feedback_Id column to see the next page.
And there we have it. This is a very simple page, but it can be expanded much further.
Application Express in general and Team Development in particular offer some built-in views to select information directly from the database. Two of those views have been shown here: apex_team_feedback
and apex_team_feedback_followup
.
Besides the columns that we have used in the example, much more information can be gathered to use to our advantage.
18.188.190.175