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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

What does "Generate queries" do under "Commerce channel schema"

(0) ShareShare
ReportReport
Posted on by 15

Hi Experts, 

I am just curious to understand what is the function of "Generate queries" under Retail and Commerce > Headquarters setup > Commerce scheduler. 


4263.pastedimage1663119924454v2.png

*This is my first post in community so apology for any mistake in choosing the Forum*

I have the same question (0)
  • Verified answer
    Charlotte X Profile Picture
    on at

    Hi Mr Karan Singh,

    I haven't used this feature before, and I went to try to click on this button:

    pastedimage1663209522050v1.png

    Scheduler jobs are the mechanism for distributing data to and from locations. Jobs are made up of subjobs, which specify the tables and table fields that contain the data to distribute.

    So I think the "Generate queries" is to query the data that be sent to channels.

    Anyone with other ideas can also explain here.

    Best Regards,

    Charlotte

  • Verified answer
    Shafeeque P. Profile Picture
    6,533 Moderator on at

    We used to use this functionality in the legacy version(AX) of Dynamics when there was new distribution job being added. I am not sure if this is relevant, if you are not using (N-1) in D365.

    Based on the data distribution definition (an XML file where you can define relationship between different tables ), the "Generate query" button  will generate the X++ queries that will be used to define what all relevant data needs to be send to the channel DB. For example, even if you have 1000 products in your released products, only products in your assortments gets pushed in channel DB. This is actually taken care by Retail Data distribution definition.

    You can refer my blog below, to understand how you can add additional filters to definition.

    blog.shafeeque.in/.../

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

News and Announcements

Season of Giving Solutions is Here!

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…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 288 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Sumit Singh Profile Picture

Sumit Singh 46

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans