Hi all,
I have two documents representing the start and end jobs of a batch respectively.
Here the field p_job_name
represents the parent job and the field job_name
represents the names of the sub jobs of the respective parent job. The fields start
and end
represent the start and end times of each job.
I want to calculate the complete batch time which would be (End job).end - (Start job).start
.
When I use the script: doc['end'].value - doc['start'].value
, I get the timings of the individual jobs (in minutes) which is shown in the job_time
field.
I am unable to extract the end time of End job
and the start time of Start job
as part of a single query.
My aim is to obtain the overall batch time which would be : 596.683 mins
Could you please help me out?
Thanks in advance