I want to migrate date from an existing WC8 to WC10.2.
WC8 contains only documents, that I exported via Export/Import Manager.
Result of the data export is a XML file and the document itself.
However, the information in the XML file is insufficient.
The attributes "Modified by", "Last Modified", "Created by", "Created", "Updated by", "Last updated" are not included.
Can someone help me and tell me how to extract that data?
I think best solution to have a SQL query that outputs the number and the attributes mentioned above in a list.
Unfortunately I do not know the correct query.
Only the newest version of the document is necessary.
Thank you in advance.
--- One update ---
I was also advised by PTC to use the QueryBuilder to the get out the necessary data. But I do not know how to use it. Does someone have experience?
thank you very much.
However, I was able to extract the data I needed via the Query Builder tool
I see you joined Reporting group earlier this year.
May I ask you to share your query builder, with other users, in this document Resource for reporting ?
sorry, but I think it makes no sense to share it. Others could not use it as it is, because we use document subtypes and other customizations in our queries, so that other have to modify it before using it. But if I have others queries, I will definitely share them.