Defining a where clause on the first View Table (sorting with order) doesn't work when one of the View Tables has left join set to true.
This behavior of database view is intentional since View Table defines how the two tables are joined. There is no issue with where clause while using inner join (left join = false). This has been recorded in PRB1348874
The workaround for this issue is to create an additional View Table to add the where clause for the first table. See the attached screenshot with an example database view (View Tables) to make the where clause work on the first View Table.