One area which I feel APEX shows some potential, but isn't there yet, is the Team Development section. Of course, it's not the APEX team's focus, so it's not really fair to expect it to be on the same level as the various issue tracking tools out there (bugzilla is probably the most well known, but there are plenty of others), but there's a fair amount of potential for it to include features that are focused directly on APEX. The most obvious, of course, are the current abilities to automatically create a feedback/bug reporting page in your application and the ability to track which application and page the user is on when they open the feedback form. But there are other areas where it just falls flat.
My biggest complaint is the lack of e-mail support. When a user uses the feedback form, their feedback is recorded in the database, and if your developers are in the habit of looking at the team development dashboard regularly, there's a decent chance that the right developer will (eventually) see the user's comment. For a feature request, this may be acceptable (probably not), but for a bug report, this sort of delay can be disastrous. Much better would be for the feedback form to send an e-mail to the appropriate developer when a user uses the form. Luckily, this is easy to patch in.
Go to the feedback page in your application (typically, page 102), and you'll see the Submit Feedback process. It's a PL/SQL process that calls apex_util.submit_feedback(…). You can create a new process, or just add on to that one, and add in code to send an e-mail to the appropriate person. This can be as simple as the code I use for WriteTrack (where I'm the only developer):
procedure ack_feedback( i_application_id in number, i_page_id in number, i_type_id in number, i_email in varchar2, i_comment in varchar2) is l_type_name varchar2(50); crlf varchar2(2) := chr(13)||chr(10); begin select the_name into l_type_name from APEX_FEEDBACK_TYPES where id = i_type_id; apex_mail.send( p_to => '...', -- Redacted to reduce spam. p_from => i_email, p_body => 'Feedback Type: '||l_type_name||crlf||i_comment, p_body_html => 'Feedback Type: '||l_type_name||'
'||i_comment||'', p_subj => 'WriteTrack Feedback' ); apex_mail.push_queue(); end ack_feedback;
Or you can get more complex and triage the feedback based on application ID, page number, feedback type, time of day, etc. (Note that you can also add extra fields to the feedback page as needed!)
This only solves half of the problem, of course; the other half, which I haven't found a solution for yet, would be to e-mail the user when their issue is updated (and also to give them the ability to control which sorts of e-mails they receive, of course…some people like to see every step along the way, while others only want to see the final resolution…) If you know of an option I haven't found, please let me know!