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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (