Smartlist Builder Matched Tables no data returned

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (0)

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Smartlist Builder Matched Tables no data returned

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.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Smartlist Builder Matched Tables no data returned

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