Fsldiscover
Member
HI . I am very new in JDE. I used to be Oracle developer. JDE report design Aid really throw me off and I hope someone can help me.
I have a very simple SQL
select Ne.nenedl01, ab.aban8, ww.wwGnme, ea.eaemal
from F1501B ne
inner join F0101 ab on ab.aban8 = ne.nean8
left outer join F0111 ww on ab.aban8 = ww.wwan8
left outer join F01151 ea on ww.wwan8 = ea.eaan8;
So I translate it into JDE report
a Business view on F1501B + F0101
in the event rule :
F0111.select ( Ab.aban8 = ww.wwan8 )
F0111.fetch next
while file_io_status is equal to CO Success
F01151.select ( wwan8 = ea.eaan8 )
F01151.fetch next
while file_io_status is equal to co success
print "Ne.nenedl01, ab.aban8, ww.wwGnme, ea.eaemal";
end while
end while
But in JDE, if the person do NOT have any email, that row of data will not print. I search around, I really cannot an idea on how JDE handle this kind....
I have a very simple SQL
select Ne.nenedl01, ab.aban8, ww.wwGnme, ea.eaemal
from F1501B ne
inner join F0101 ab on ab.aban8 = ne.nean8
left outer join F0111 ww on ab.aban8 = ww.wwan8
left outer join F01151 ea on ww.wwan8 = ea.eaan8;
So I translate it into JDE report
a Business view on F1501B + F0101
in the event rule :
F0111.select ( Ab.aban8 = ww.wwan8 )
F0111.fetch next
while file_io_status is equal to CO Success
F01151.select ( wwan8 = ea.eaan8 )
F01151.fetch next
while file_io_status is equal to co success
print "Ne.nenedl01, ab.aban8, ww.wwGnme, ea.eaemal";
end while
end while
But in JDE, if the person do NOT have any email, that row of data will not print. I search around, I really cannot an idea on how JDE handle this kind....