cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Translate the entire conversation x

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

RG_11025060
8-Gravel

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. 

2 REPLIES 2

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

 

 

Marco
HelesicPetr
22-Sapphire II
(To:Marco_Tosin)

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

Announcements

Top Tags