AnsweredAssumed Answered

A view of the planned processes with their names

Question asked by EricPerrin on Mar 11, 2015
Latest reply on Mar 11, 2015 by EricPerrin

Hello,

 

I wish I had a view of the planned processes with their names.

I use the following query NSQL

 

SELECT   @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:JB.ID||RS.LAST_NAME||' '||RS.FIRST_NAME:RESSNAME@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:RS.LAST_NAME||' '||RS.FIRST_NAME:NOM_Utilisateur@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:Rs.ID:Ressource_ID@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:JB.name:JOB_NAME@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:JB.start_date:Date_Debut@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:JB.end_date:date_Fin@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:JB.schedule_date:Date_Planif@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:JB.hours:Heures@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:JB.minutes:Minutes@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:JB.months:Mois@,

         @select:dim_prop:user_def:IMPLIED:RESOURCE:JB.days_of_month:Jour_du_mois@

from CMN_SCH_JOBS JB

INNER JOIN CMN_SEC_USERS RS ON RS.ID=JB.created_by

where status_code like 'SCHEDULED'

      AND @FILTER@

 

But I lack the means to retrieve the name of the process. Can anyone help me?

 

Thanks

Outcomes