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

[RG_11025060]

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. 

[Marco_Tosin]

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

How to get the SQL statement of the Query Builder Report

[HelesicPetr]

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