cancel
Showing results for 
Search instead for 
Did you mean: 

Removing the 5000+ restriction on views

Author Name: ERIK AARSLEW-JENSEN

I know that there is a way to remove the 5000+ restriction on views, through an unsupported modification of the DeploymentProperties table, and you probably have some reasons a to why it was introduced, but from the clients point of view, it makes no sense.

In MS CRM 4.0 clients we're complaining of the lack of a counters on view, they got it, but now they are basically all complaining about the 5000+ counter.

It should be possible to achieve a decent performance on even large tables, if not, you could consider employing a two-phase counting scheme, first rendering the 5000+ count one the view to increase response times and then update the actual count through ajax or something similar, asynchronously.

Status: Planned

Thank you for your feedback. We are re-categorizing this feedback to get it in front of the right team.

 

Sincerely,

Narinder Singh

PM, Microsoft

Comments
Level: Powered On
Status changed to: Planned

Thank you for your feedback. We are re-categorizing this feedback to get it in front of the right team.

 

Sincerely,

Narinder Singh

PM, Microsoft

Level: Powered On
Level: Powered On
I'm not taking about removing fetch xml throttling, which makes a lot of sense. I'm looking for a more "native" support for count, utilizing the power of the sql database, which doesn't retrieve all records from the database in order to count them.
Level: Powered On
Sharepoint can throttle views - go have a look how they do it
Level: Powered On
It's not possible to explain the sense to the customer - he knows the SQL statement "select count(*) ...". Additional, in CRM online it's not possible to move the value, because you don't have access to the SQL server.
Level: Powered On
Agree. Ppl may notice about KB: http://support.microsoft.com/kb/911510 Perhaps, it is no longer works after UR10 - you will get erro "Invalid Argument" though.
Level: Powered On
Thank you for your suggestion. We are considering this functionality for a future release of CRM. Mike Carter This posting is provided "as is" with no warranties, and confers no rights.
Level: Powered On

Is this still being looked into? We recently upgraded from CRM2011 (which has a counter) to Dynamics 365 (which only displaces 5000+).

Level: Powered On

We really need this to be able to quickly look into the total count. Exporting the data is more and more being restricted due to privacy regulations and this way analists can still produce the correct numbers without extracting the data.

Level: Powered On

Agree, really annoying having to export all the records just to get a figure.  Hopefully MS can come up with a way that doesn't compromise performance.