How to get the Template Information used while creation of ECN from QML Report

[JA_11399780]

Hi Team,

I want the template information of the ECN in the QML report. Can you anyone help to get that? I am not sure which table and join the template information will be stored and how to get that.  Can anyone kindly help

[Marco_Tosin]

Take a look at this article

QML report to fetch all Change Notice and their associated Team template in Windchill PDMLink

[JA_11399780]

Hi, thanks for your support! I think it's for Team Template information. But my requirement is to fetch the Template Name of ECN which was used while creating ECN. 

[joe_morton]

Normally for documents, you could see this info from the "Save-as History" ref: https://www.ptc.com/en/support/article/CS214070?source=search

I tried doing similar for ECNs, and it didn't work. Also, I don't see any "Save-as History" at all for ECNs, so it might be that the info isn't written to the database. I'm not sure.

[JA_11399780]

Thanks for your kind response! Even I thought in the same way that's why I am looking for any other way to get the template information