Left Outer Join Business View Issue

[AnkurSanghi]

The scenario is:
Left outer join business view joins table F4311 and table F4311T (custom tag table with same key as F4311). Objective is that the F4311 data shows even if there is no corresponding records in the tag table F4311T.
I use this on a Form grid and the data shows correctly except when I do a QBE on a fields that belongs to the F4311T. When doing so the desired data set is records that match the QBE value but instead I get all the data that matches the QBE value along with all the records that do not exist in the F4311T.
Any thoughts on how to work around this?

Thanks

 

[BOster]

Turn on Debug Log, look at the SQL and you will have your answer. JDE does you a "favor" and automatically adds "...OR NULL" in the WHERE clause for fields with query criteria on the right side of a left outer join. Try changing to a SQL-92 join.

 

[Remo Williams]

Brian is right. If you wanna read more on it:

SOLUTION ID: 200821061: E1: TDA: Null addition with a left outer join business view.