How to add or condition in database view or clause

[Obito]

Hi All, How can we add or condition in where clause so that we can add two tables.

[Dr Atul G- LNG]

Hi @Obito 

We cant any condition in where clause. You can add condition when you create report using DB view.

[Brad Bowman]

You can use the || operator in a where clause to denote OR, but there are limitations.  Is this view working with one table as shown?

[Obito]

Yes @Brad Bowman  It is working.

[Brad Bowman]

As the metric definition is linked to the metric instance which is linked to the cs case table, I don't see how there would be definitions on any other table in this scenario.