Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
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.
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
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