The Target Resolution Dates report is a calendar that displays issues that have not yet

closed along with the assigned person on the day that corresponds to the issue target

resolution date.

Create a Calendar

333. Выберите Application home page, выберите Create Page, выберите Calendar и Next, выберите SQL Calendar и Next,   в поле Page Number введите 11, в поле Page Name введите Target Resolution Dates,  в списке Region Template выберите No Templates, в поле Region Name введите Target Resolution Dates, в списке Breadcrumb выберитеt Breadcrumb, в поле Parent Entry выберите Reports ссылку, и Next.

334. В списке Tab Options выберите Use an existing tab set and reuse an existing tab within that tab set,  в списке Tab Set выберите Issue Tracker (Home, Dashboard, Projects...), и Next,  в списке Use Tab выберите T_REPORTS и b.

335. В SQL Query введите код:

SELECT I.TARGET_RESOLUTION_DATE,

I.ISSUE_SUMMARY ||' ('||nvl(P.PERSON_NAME,'Unassigned') ||') ' disp,

I.ISSUE_ID

FROM IT_ISSUES I, IT_PEOPLE P

WHERE I.ASSIGNED_TO_PERSON_ID = P.PERSON_ID (+)

AND (I.RELATED_PROJECT_ID = :P11_PROJECT OR :P11_PROJECT = '-1')

AND I.STATUS != 'Closed'

336. Нажмите Next.

– The target_resolution_date is the date on which the issue displays

– The issue_summary is concatenated with the person assigned

– The issue_id does not display, but is used to create a link to enable the user to view and edit the issue

337. В списке Date Column  выберите TARGET_RESOLUTION_DATE,  в списке Display Column  выберите DISP  и Next.

338. Смотрим и Finish, потом Run