Smartlist not including extender view for all DB's
Renee asked 4 years ago
We created a new view and verified that it is reflected on all DB’s, we then created a smartlist with the view included. The problem is when we run the smartlist it is excluding one particular DB, we have attempted to add the multi-company option in summary however the only way the data will generate is if we alter the “add SQL table” link with that specific DB but than it excludes the others. If we remove the view than the smartlist populates corrently with all DB’s results.
Renee,
“We created a new view and verified that it is reflected on all DB’s”
I assume you mean “it exists in all company dbs’. i’ll also further assume it only reads data from that specific company which is typical of most views.
“The problem is when we run the smartlist it is excluding one particular DB”
By default, a Smartlist only runs for the company database you are logged into. So I’d say that ALL but the current company would be excluded from the report.
“we have attempted to add the multi-company option in summary”
This would be the only way to get multiple company data displayed at once.
“If we remove the view than the smartlist populates corrently with all DB’s results.”
when troubleshooting smartlists, step #1 is to always enable the dexsql.log in GP so you can see the query and/or sql error.
In the case of a multicompany report, how SLB does it that it runs the report multiple times according to the number of dbs added.
So it’ll run in Company A and display the results. Then again in Company B and displays the results, etc.
If the report is going to display the default 1000 records and Company A has 800 records and Company B has 500 records, only 200 records of Company B would be displayed due to the 1000 record limit that it is set to.
Thank you for the feedback; however the problem occurs when the extender view is added to SLB and the link is associated for company A. The report runs with only company A data. If I change the link to company B than I get results for company B, C, and D. Why/Where would a disconnect be for company A?
because you didn’t mark the “use company database” checkbox for the table/view.
if you don’t, then SLB assumes you ALWAYS want to pull data from that specific database and so it does just that. if you mark the checkbox, it’ll pull the data from the “current company”.
I would normally agree with you but that option is not selected on any of the companies so why the difference in results?
Run a Dexsql.log and review the results.