A column in Smartview does not always show the data that appear in the same column in Smartlist
Nancy asked 5 years ago
A column on a Smartview is not showing all that data for that analogous column in Smartlist. Not sure how to debug this problem. Any suggestions where to start?
Nancy,
The only way you _can_ start is by verifying the SQL that SV is using.
You would have to run a SQL Profile trace. Then find the SQL statement generated and executed by SmartView.
You could then take that and run it in SSMS and verify the results.
I’m going then to assume that SV and SSMS show the same results (ie missing data) – I don’t know how it wouldn’t.
With that assumption, you’d have to look at the query and take it apart to figure out why you get missing data(ie bad query? Bad join? really ARE missing the data where you think you have some, etc).
patrick
Actually No the smarlist shows the data, the query in SSMS shows the data only smartview doesn’t show the data. So why would Smartview not show data that the smartlist shows?
You would have to do as I suggested to find out.
I would find it unlikely that there is an issue with the data grid control in SmartView that is just “hiding” the data from you.
More likely that the queries from SLB & SV are different for some reason (two different programs that try to run the smartlists the same way but don’t always do).
but you aren’t going to know that until you run the trace.
Is it possible to get some help with this, I can’t understand how they could be different, I took the based smartlist that gets passed thru to smartview and applied the same criteria to narrow down the list of records to see the issue, and it is clear that the column it completely populated in smartlist but not in smartview. I will try with SQL Profile trace but don’t know how to use it very well and could really use some help.