Bug Report T293920
Visible to All Users

In Server Mode PivotGrid requests all fields' unique values when Prefilter is initially shown

created 9 years ago

Hi

I have a pivot grid operating in server mode on a datasource which has in excess of 100 available fields.

When I go to show the Prefilter dialog the application just appears to hang.  Looking at the output from the EF logger I can see that it's submitting loads of queries to get all the distinct values for the fields,

Surely it would make more sense to only grab the values when you select the field to filter by?

Is there a setting that I've missed that will invoke that more efficient behaviour?

Many Thanks

Pete

Show previous comments (1)

    John
    We're up against time a bit on this so a sample to get us started would be much appreciated.
    Many Thanks
    Pete

    DevExpress Support Team 9 years ago

      Ok Pete,
      Give me some additional time to prepare such a sample.

      DevExpress Support Team 9 years ago

        Hi Pete,
        Attached is a small sample project that illustrates the previously described approach. Try it and let me know whether or not it meet your requirements.

        Answers approved by DevExpress Support

        created 9 years ago

        We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

        Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.