web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / View SQL query behind ...
Microsoft Dynamics GP (Archived)

View SQL query behind Smart List

(0) ShareShare
ReportReport
Posted on by Community Member

Within Business Objects, there is a handy dandy button that allows me to see the "SQL Query" generated when running a report.

Does the equivalent functionality exist for Smartlists inside of GP? What is the easiest way to see the SQL query generated per smartlist?

Of course, I could dig through the table finder and guess which tables are used, but I was hoping for something more convenient

Any suggestions?

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    RE: View SQL query behind Smart List
    Hi Rod, Can you please confirm what you are trying to do, because the table behind smartlist is complex and there is no one place which gives this all information. If you wanted to know all the main module tables the best place is Victoria's website. Please have a look at the same on the following link. victoriayudin.com/gp-tables
  • Community Member Profile Picture
    Community Member on at
    RE: View SQL query behind Smart List

    Thanks for your help. I was looking for a way to determine the SQL tables used for Smart Lists. If it is not possible to see the SQL Query directly, then do you know the steps to find the tables and logic used to build the smart list?

    Thanks

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    RE: View SQL query behind Smart List

    Hi Rod,

    Are you looking for the SQL query for the standard GP smartlist object if so then I think its not possible.  But all other custom object using SQL view you can see the same on SQL server.

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans