First table's where clause ignored in database view with left joinIssue Defining a 'where' clause on the first View Tables (sorting with order) doesn't work when one of the View Tables has 'Left join' set to true.ReleaseAllCauseDatabase view behavior is intentional, as View Table defines 'join'. No issue with 'where' clause for inner join ('left join'=false); recorded in PRB1348874.ResolutionAdd a View Table to enable the where clause for the first table. See screenshot below (View Tables).