Getting PR ,CR, CN details where part number is input through SQL query

[ptc-5413127]

Getting PR ,CR, CN details where part number is input through SQL query.

Can somebody help me on this?

[JarrettOberg]

Hi Aravind,

Are you looking for a SQL Query to return details of the PR/CR/CN?

OR

Are you looking to input some SQL in the windchill UI or advanced search?

Could you clarify this a bit perhaps?

Thanks,

Jarrett

[ptc-5413127]

Hi jarrett,

I am looking for a SQL Query to return details of the PR/CR/CN from Part Number .

[MikeLockwood]

Can do this thru a query builder report - with all needed flexibility