How to find a released model with missing PDF

[ptc-4872065]

Hi,

I have a question from a customer that has problems with generating PDF-files when releasing a model/drawing.

How can one make a search in ModelManager DB to show all released models without (or with) a generated PDF within a certain timespan.

Regards

Eje Hjelmquist

This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

[MaxR.Kublin]

This can be done by SQL.

You need to know which tables need to be joined.

For a standard schema, the following tables need to joined:

WM_ELEMENTS (state, e.g. released)

DRAWING_2D

WM_FILES - the drawing file

WM_RELATED_FILES - the PDF related to the drawing

- Max

[MaxR.Kublin]

Hi Eje,

Question still open?

Max