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.

Database view of Business App is returning the all install status event after querying for status=1

KiranK2
Tera Contributor

I am creating Database view with CMDB Business App as my base table and wants to create view with Group by using common reference as assignment group. 

Now further I want to make sure that I am only doing this for Business App where install status is "in Production ", "Implementing "or "pending retirement "

 

I am adding below query on my base table which Business App however I am still getting the All status type records

(app_install_status=0 ||app_install_status =31 || app_install_status=1)

KiranK2_0-1710149454428.png

 

@Ankur Bawiskar @sabell2012 @JamesEcoStratus Kindly advise

0 REPLIES 0