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