Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
I followed PTC Article CS135952 on finding all available Preferences in Windchill PLM, but the report shows many duplicates across multiple pages. How can I generate a QML report in Windchill 12.0 that lists all Preference Management report sheets without duplication?
Solved! Go to Solution.
I believe you are seeing duplicate preferences because the two tables selected in the report are not linked to each other, and therefore the results are multiplied.
Try joining them in this way, and you should see only unique values.
Keep in mind that the Category Name column may have some preferences with sub-values that have a different category name.
See this example.
On the left are the preferences set in Windchill and on the right are the results of the report.
try to filter by context , some preferences exist on Site /org and application contexts .
Hello Fadel,
Thank you for the response.
Could you please guide me on how and where to apply the context filter? I’m not sure what exactly needs to be filtered (Site, Org, or Application context)
I believe you are seeing duplicate preferences because the two tables selected in the report are not linked to each other, and therefore the results are multiplied.
Try joining them in this way, and you should see only unique values.
Keep in mind that the Category Name column may have some preferences with sub-values that have a different category name.
See this example.
On the left are the preferences set in Windchill and on the right are the results of the report.
