how to export job monitor table in a file

[gbalestrieri]

We need a report of the current pubblications. The best option would be an export of the Job Monitor table:

As the export in a file is not a provided function, waiting this function will be added, I ask if someone can help me to write a query that join the QUEUEENTRY table to obtain the same info of the Job Monitor.

I haven't idea on the other table and which are the keys to join tables.

Tanks a lot.

[Marco_Tosin]

Giovanni,

mi verrebbe voglia di scriverti in italiano, ma gli atri non capirebbero.

Take a look at this article from TS https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS23768&lang=en

Also you can read this document I wrote, with a lots of query builder already done Resource for reporting

Marco.

[gbalestrieri]

Thank you Marco.

I start to look to QueryBuilder and try to create a new report but I don't understand how relate EPMDocuments with their publication queue.

I open a new report and first I add the class EPM Document after I don't see any class to match the object in the Job Monitor; there are some classes of wt.Queue but I don't find the right one.

Do anyone knows the class I need or have a documents that explane all the classes listed in the query builder?

Tank you all.

Giovanni

[Marco_Tosin]

Giovanni,

take a look at this Getting query to return even with null (empty) valued attributes

I post a comment on how to search join between windchill types.

Happy Easter / Buona Pasqua

Marco