SQL View Smartlist Builder not populating all data in Smartlist
I have deleted the Smartlist Builder Object and created again with another name, same results.
I have full SA rights.
I have Refresh the Cache.
What could be wrong?
Look for errors (you probably won’t have any in your case but in general look for them). Then take that statement from the dexsql.log and execute in SSMS and compare.
I had a restriction in SQL on the Invoice Date, only the Credit Memos were showing not the invoices, once I removed the restriction that it worked fine in Smartlist. (I just created the restriction within Smartlist Builder instead)
Not sure why this would be correct in SQL and not flow into Smartlist Builder???
If you would like to submit an answer or comment, please sign in to the eOne portal.