We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

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