Get the Line number of a task

Discussion created by MuratYanik629839 on Aug 28, 2017
Latest reply on Sep 3, 2018 by Michael_Lowry

Hi,
is it possible to get the running number within a job with script ?
I mean the number of a task within the Workflow and not the RunID.

Outcomes

Wolfgang_Brueckler_1288 Aug 29, 2017 2:32 PM
I personally would not know any script command determining the position of an object within a workflow.

I can provide you with an (T-)SQL determining the Workflow's objects numbers
select JPP_Object as 'workflow object', jpp_lnr as 'position in WF' from JPP where JPP_oh_idnr = (select oh_idnr from Oh where oh_name = 'JOBP.B.4' and oh_client=1);

just change JOBP.B.4 as workflow name and oh_client=1 as client number to your needs.
Like • Show 1 Like1
Actions
MuratYanik629839 Aug 29, 2017 1:24 PM
Hello Wolfgang,
thanks for reply. The stupid is, that i have no access to the database.
Like • Show 0 Likes0
Actions
Wolfgang_Brueckler_1288 Aug 29, 2017 2:33 PM
You could ask your Automic Admin for an SQLI VARA otherwise - hmmm hard luck....
Like • Show 0 Likes0
Actions
Michael_Lowry Sep 3, 2018 2:04 PM
This function will return a task’s sequence number (Lnr):
SYS_ACT_ME_LNR.
3 people found this helpful
Like • Show 0 Likes0
Actions