Hello,
I want to have a recursive baq for JobProd.
we have Make to Job. it is 3 level. ex as below
Job Parent Job
000033 00032-1-1
000034 000033
000035 000034
so, if by giving a jobnum, we need find the root job in JobProd.
anyone can give some ideas how to do it in BAQ. also, it must not hit the performance. we found with join with multiple subqueries, baq hit the performance issue.
thanks,
Eddy