Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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