Good morning PTC Users.
I am in need of some assistance with a query I am trying to write in Oracle SQL Developer. This query will be used to create a CVS file and can't be done in Report Manager.
I am trying to return all WTDocuments that have been RELEASED in the last X number days for a specific Org. What I have seems to work (somewhat) but doesn't return all documents. From a product within this Org, I created a new document and set the state to release but this query is not picking it up. I have attached the query and any help would be greatly. I am fairly new to Oracle and the Windchill DB schema so forgive my sloppy query!
I did look on the PTC support site and found nothing.
Thank you,
Eric