Notifications

44 views

Description

Symptoms

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.

Release

All Versions

Cause

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

Resolution

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.

Article Information

Last Updated:2019-08-02 20:39:54
Published:2019-06-18
View Table.png