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