Creating a View with a OR in the INNER JOIN
Using the View Builder, is there a way to create a view with an 'OR' in an 'INNER JOIN' including an hardcoded value ?
Select a.1, a.2, a.3, b.4,
Inner JOIN b
on( a.1 = b.1 and (a.2 = b.2 or a.2 = ' XXX ' ) )