Anyway to find the successors for a job in CA UC4 version 11.2?
Here's a query you could use to identify them:
select oh_name as workflow, jpp1.jpp_object as task, jpp2.jpp_object as successor_task, jppa_when as successor_dependencyfrom oh,jpp as jpp1, jpp as jpp2, jppawhere oh_idnr=jpp1.jpp_oh_idnrand oh_idnr=jpp2.jpp_oh_idnrand oh_idnr=jppa_oh_idnrand jpp2.jpp_lnr=jppa_jpp_lnrand jpp1.jpp_lnr=jppa_prelnrand jpp1.jpp_object='[[ task you want to find the successors for ]]'and oh_name='[[ workflow where this task is found ]]'and oh_client=[[ client # where this workflow exists ]];
You could bury that in a SEC_SQLI var, for example.
Again, how are you intending to use this info about successors? Just wondering if there might be another way to approach the problem...
So are you looking for a SQL query that can tell you what tasks follow a given job within a workflow? Or would you need this info accessible in some other way?
What is it you're trying to do here, exactly?
Thanks for the reply.
As we have predecessors list in the dependencies tab for a job task properties. I just want to know any possible way to get the Successors for a particular job
Did Daryl suggestion help in resolving your question? If it did, please help us by using the "Mark Correct" button on his comment.But as Daryl also mention, how are you intending to use the info about the successors as there may be other way to approach it.
Yes there may be a way but if the job has multiple successors then its difficult to find all the jobs, hence asked for this query now i am very to get the results fraction of seconds.
Retrieving data ...