cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

The PTC Community email address has changed to community-mailer@ptc.com. Learn more.

Cross domain support for importing Query Builder reports

Cross domain support for importing Query Builder reports

This idea is to update the csvReportTemplate load file handler to correct for domain name differences for soft types and instance based attributes.

If you're providing a customization or setting up a deployment for Windchill, you probably use load files to standardize and automate the steps. You probably define some soft types centered around your business process and maybe some reports based on those soft types. Both of these can be exported into load files and imported back onto the system. All of this is standard Windchill functionality.

Now say you're doing this configuration on a test system that has a different domain. For example, the production server might be at company.com/Windchill and the test system may be at company.test/Windchill. In the scenario stated above, you can easily import the load files defining your soft types. However, you cannot directly import the load file for the reports you defined.

Hence the problem: load files can compensate for a different domain names when importing soft types but when importing reports. You would have to either manually edit the report or recreate the report on the new system. Either way, it's introducing human error that can be avoided.

Here's an example of an exported Query Builder report with the domain highlighted:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE qml SYSTEM "/wt/query/qml/qml.dtd">

<qml>

    <statement>

        <query>

            <select>

                <object alias="New Soft Type"

                    heading="Identity (displayIdentity)" propertyName="displayIdentity">

                    <property name="displayIdentity"/>

                </object>

            </select>

            <from>

                <table alias="New Soft Type">WCTYPE|wt.epm.EPMDocument|com.company.NewSoftType</table>

            </from>

        </query>

    </statement>

</qml>

1 Comment
PTCModerator
Emeritus
Status changed to: Archived