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
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
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 :
Could you please help me out?
Thanks in advance