You need to sign in to do that
Don't have an account?
Tammy V.ax1583
Cannot Remove Excel Connector Query Filter
I was able to install the Excel Connector and I have created a query with no filters. When I view the result it appears that a filter is being added "System Modstamp > 12/20/2012". I edit the query and select "Clear all Clauses" which removes it from the window, however, when I run the query again it seems to plug it back in. What am I missing?
I think the intention behind this behaviour is to not have unrestricted queries returning huge datasets.
If you don't add any filters Connector seems to always automatically add this filter to limit the potential data returned.
You can edit the date yourself to expand that data returned (eg move the Year to 10 years previously) or if you add a separate filter this Modstamp one will not be automatically added.