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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Smartlist Builder Matc...
Microsoft Dynamics GP (Archived)

Smartlist Builder Matched Tables no data returned

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I have created a Smartlist using Smartlist Builder. It returns data. If I use the Matched Tables fuction and add a History table I receive no data. The matched table showed a match on all fields.

Is there something I am not doing to make it work?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi James,

    To check whether your Smartlist Matched tables function is returning the values or not, you can SQL profiler from OPEN SSMS --> under menu Click Tools --> SQL Server Profiler

    in SQL Server Profiler explorer

    File --> New Trace --> in Trace Properties window -->  Select event selection tab

    in this tab select mark all check boxes across -- Errors and Warnings , Stored Procedures & TSQL

    and now run your Smartlist query, and the query trace will be recorded in TextData.

    pick that query and execute the query in SSMS Query Browser.

    verify if all the conditions of the query generated is correct.

    Hope this helps,

    Regards,

    Santosh G

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    In case you are not much of a technical person, please provide us with further specific details along with screen shots (which tables, which fields are you matching) I would simply assume that there is something incorrect with the matching criteria you have specified.

    Your feedback is highly appreciated.

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 Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans