All you got to do is explain the requirement fully. You did not tell us which row to pick and how. Did you do research? There are plenty of similar stuff available on this forum.
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
For each group within "App" you want the earliest start-date, the latest end-date, and staus will be Complete if all are Complete, Errror if at least one is in error, otherwise In-Progress.
Talk to your Scheduler people. They can probably report this.
If you have to continue with this yourself, bear in mind that your task is not as easy as your sample-data makes out. It doesn't have to be the last job in the group which finishes last - or, if it sorted that way, unless the first job in each App is a "trigger" job (it will always start first and end first) you won't be able to pick the earliest easily.
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
mrdinesh,
The requirement is pretty much well explained in your example. Good job.
What if all the entries for an application are 'WAITING'? What status do you want to see for that application in that case?
Will that still be 'In-Progress' with start/end times as blanks?
Ideally if all the jobs within an application are waiting, I would have expected the Appln status to be 'Waiting' instead of 'In-Progress'.
This can be slightly tweaked if that is what you want to show in the output.
EDIT : My bad, again kept the page open and missed Bill's response.
The requirement is pretty much well explained in your example. Good job.
What if all the entries for an application are 'WAITING'? What status do you want to see for that application in that case?
Will that still be 'In-Progress' with start/end times as blanks?
Ideally if all the jobs within an application are waiting, I would have expected the Appln status to be 'Waiting' instead of 'In-Progress'.
This can be slightly tweaked if that is what you want to show in the output.
EDIT : My bad, again kept the page open and missed Bill's response.
Thanks Arun Raj, the sort card worked well for us.
For each group within "App" you want the earliest start-date, the latest end-date, and staus will be Complete if all are Complete, Errror if at least one is in error, otherwise In-Progress.
Talk to your Scheduler people. They can probably report this.
If you have to continue with this yourself, bear in mind that your task is not as easy as your sample-data makes out. It doesn't have to be the last job in the group which finishes last - or, if it sorted that way, unless the first job in each App is a "trigger" job (it will always start first and end first) you won't be able to pick the earliest easily.
Thanks Bill. In the Long term we are going to get a file from our scheduler people. For now we are going with a temporary solution.