How to fetch custom IBA on Change Request using SQL Query?

I have a custom IBA on a change request. I need to write a SQL query to fetch all ChangeRequests which have a non-null value for that attribute.

21-Topaz I

Have you tried creating a report query builder first and then using it to generate the SQL query?

Marco

22-Sapphire II

Hi @Marco_Tosin

Good idea. Just create a report for ChangeRequests add a IBA attribute to the select table and then just check the resulted SQL

PetrH

Sign up