I have a library that is over 5000 items and cannot be reduced or split up. I've set up an index in SharePoint by Created Date which allows me to view the list without seeing a LVT message. The problem is that I have a button on the form with a rule to query this library.
When the button is clicked I receive the error, "An error has occurred querying a data source. The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator..."
I tried setting an index on the default view, but I receive the same error. Is there any way around this issue? Thank you