web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Data migration: querie...
Supply chain | Supply Chain Management, Commerce
Answered

Data migration: queries on work templates and location directives

(0) ShareShare
ReportReport
Posted on by raff 1,236

hi

we are moving wax configurations from one test environment to another (d365 on premise).but one area we keep having issues around is Work templates and location directives, specifically the queries built on top of the templates

the general template header and detail information migrates fine via entities, but is there a specific entity that deals with the Query data? or how do we move this data? 

thanks

mal

I have the same question (0)
  • Verified answer
    Alina Lica Profile Picture
    Alina Lica on at

    Hello Raff,

    There are no special data entities for Queries, the queries are exported together with main data from Work templates/Location directives.

    So, the data entity for Work templates should export also the query.

    It is recommended to use Package as export option.

    Thanks,

    Alina

  • Suggested answer
    AliceBarendregt Profile Picture
    AliceBarendregt 1,470 on at

    Hi Raff, 

    In case you would like to import/export the associated queries you need to ensure that you are using XML as file format during your export. This will ensure that the query is being included as part of your export. Once the XML message has been exported/updated ensure that this is also being updated via a data package. After this proceed with the import of your package. This approach will ensure that your work templates/location directives and associated queries will be imported successfully. 

    Any questions, let me know. 

    Thanks, 

    Alice

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,032 on at

    sharing a link which is similar , hoping it is helpful

    ax.docentric.com/.../

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,030 Super User 2025 Season 2 on at

    Hi Raff,

    A small additional message related to the reply from Alice. The query will be exported as hexadecimal value. If you are trying to use Excel as file format, the query value might be too large and some Excel versions can truncate the query which will cause 'bad container' errors on runtime. So, like Alice mentioned, please use XML to ensure the full query will be imported in the target environment.

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,032 on at

    XMl is the way as suggested

    pls suggest if our responses helped

  • Suggested answer
    raff Profile Picture
    raff 1,236 on at

    thanks so much Alina, thats working now!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 298 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 179 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 121 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans