Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
  • 1,051 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