function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Tammy V.ax1583Tammy 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?

paddyb1paddyb1

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.