AnsweredAssumed Answered

NSQL: current date and tasks

Question asked by cris.perezcoll on Apr 30, 2012
Latest reply on May 15, 2012 by cris.perezcoll
Hi,
I want create a nsql with delayed task for one project. My nsql is this

SELECT @select:dim:user_def:implied:task:t.prid:task_int_id@,
@select:dim_prop:user_def:implied:task:t.prexternalid:task_id@,
@select:dim_prop:user_def:implied:task:t.prwbssequence:wbs_sequence@,
@select:dim_prop:user_def:implied:task:t.prname:task_name@,
@select:dim_prop:user_def:implied:task:t.prprojectid:proj_int_id@,
@select:dim_prop:user_def:implied:task:t.prstart:start_date@,
@select:dim_prop:user_def:implied:task:t.prfinish:finish_date@,
@select:dim_prop:user_def:implied:task:t.priscritical:critical@,
@select:dim_prop:user_def:implied:task:t.prismilestone:milestone@,
@select:dim_prop:user_def:implied:task:t.priskey:iskey@,
@select:dim_prop:user_def:implied:task:t.prpctcomplete:complete@,
@select:metric:user_def:implied:task:sysdate-t.prfinish:dayslate@:agg@,
@select:dim:user_def:implied:odf:o.id:odf_id@,
@select:dim_prop:user_def:implied:odf:o.sm_dep_afectado:dep@,
@select:dim_prop:user_def:implied:odf:o.sm_dept_gestor:gestor@,
@select:dim_prop:user_def:implied:odf:o.sm_restask:resource@
FROM prtask t, odf_ca_task o
WHERE o.id=t.prid
AND t.pristask <> 0
AND t.prstatus <> 2
AND (sysdate - t.prfinish) > 0
AND t.prprojectid = @WHERE:PARAM:XML:INTEGER:/data/id/@value@
AND @WHERE:SECURITY:PROJECT:t.prprojectid@
AND @FILTER@

This field sm_dep_afectado:dep, sm_dept_gestor:gestor, and sm_restask:resource are fields of the table odf_ca_task

But i get this error:

ORA-00923: FROM keyword not found where expected SQL

Do you know the error? is correct?
Thanks for our help

Outcomes