gamya

Query Required not to get duplicate timeperiod

Discussion created by gamya on Sep 21, 2013
Latest reply on Sep 23, 2013 by Chris_Hackett
Hi ,
1. When i am executing the following script in Oracle-SQL its giving proper o/p but i am not making the mistake when i used it as lookup to New Reporting attribue in my Status Report table.
can you please help me to overcome my mistake that is i need procedure to be followed not to get Duplicate in New Reporting Period Column.

SELECT @SELECT:a.PRSTART || ' - ' || (a.PRFINISH-1):timeperiod@
FROM PRTIMEPERIOD a
WHERE PRID Not IN
(SELECT GS_NEW_REPRT_WEEK FROM ODF_CA_GS_STATUS_REPORT
WHERE ODF_PARENT_ID=@WHERE:PARAM:USER_DEF:INTEGER:Prj_id@)
AND @FILTER@

2. What are the fields required to be added in NSQL in order to get all missing status reports of all projects in clarity.Because presently i am able to display only those projects that are created by login user.

Outcomes