SQL : Matching JPP to AH when objects appear multiple times

Discussion created by Simon_B_9159 on Apr 28, 2017
Latest reply on May 2, 2017 by Wolfgang_Brueckler_1288
One of the objects (JOBP) in my workflow has the the same child object 24 times over.
Seems that it is there once for every hour of the day, each one with a different Earliest/Last time.

My problem comes to when I am looking at activities in AH.
I can see activities for that child by Name, but I have no idea which of the 24 lines of the jobplan it belongs to !?

Yes, in this specific case, I could do a look up by time of day; but the next time I come across a case of a child appearing multiple times, it might be on some different condition - and I am really looking for a global solution.

I can see 'clues', for example in the UI, the name of each child is displayed as an alias , e.g. theJob(1), theJob(2)..... theJob(24)
However, as yet I've been unable to find that in AH for me to join to.

Any hints, pointers or solutions welcome !!

Many Thanks