topic Re: Problem with infoset/query: Some data are missing in Application Development and Automation Discussions

Problem with infoset/query: Some data are missing

Former Member — Fri, 13 Aug 2010 14:02:50 GMT

hi all,

i created an infoset and a query with tables AGR_AGRS (composite/single roles) and AGR_TCODES (tcodes in roles)with SQ01/02.

Problem is that some roles without tcodes dont appear in the report(no data in AGR_TCODES)

I tried to change properties of joints in SQ02 (external) but it doesnt work..

Any idea? Let me know if you need further info,

julien

Re: Problem with infoset/query: Some data are missing

Former Member — Fri, 13 Aug 2010 14:09:18 GMT

Join you use should be Left outer Join to pick those values in AGR_AGRS. Inner join will only pick only when you have a corresponding entry in the second table.

Cheers

Sujay

Re: Problem with infoset/query: Some data are missing

Former Member — Mon, 16 Aug 2010 07:47:14 GMT

Hi Sujay,

My infoset is built like this:

agr_define_____________agr_agrs___________________agr_texts

.............................................. |_______________________agr_tcodes____________________agr_texts

I tried to change agr_define_____________agr_agrs and agr_agrs_____________agr_tcodes using left inner joing but no result.

I appreciate your help,

Julien

Edited by: JULIEN LEGAL on Aug 16, 2010 9:47 AM