How to add or condition in database view or clause

Obito
Tera Expert

‎12-05-2024 05:38 AM

Obito_0-1733405806377.png

 

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

0 Helpfuls
  • 746 Views
7 REPLIES 7

Dr Atul G- LNG
Tera Patron
Tera Patron

‎12-05-2024 05:46 AM

Hi @Obito 

 

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

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Brad Bowman
Kilo Patron
Kilo Patron

‎12-05-2024 05:47 AM

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
Tera Expert
In response to Brad Bowman

‎12-05-2024 06:04 AM

Yes @Brad Bowman  It is working.

0 Helpfuls

Brad Bowman
Kilo Patron
Kilo Patron
In response to Obito

‎12-05-2024 06:18 AM

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.

0 Helpfuls