Ticket T973917
Visible to All Users
Duplicate

We have closed this ticket because another page addresses its subject:

Blazor - The Page Size = All option is not removed when DataAccessMode = Server in DxGridListEditor

Blazor - Root List Views select all records in Server mode

created 4 years ago (modified 4 years ago)

[DevExpress Support Team: CLONED FROM T936581: Blazor - Performance - LookupPropertyEditor loads all records from its data source when a DetailView is shown]

Hi Guys,

i just did another blazor test after some time now - you said above "Root List Views have a pager and load only objects from the current page (e.g., top 20 records)."

in fact that does not work - we have server mode enabled - but root listviews also do an select * from table ?

Update:
Just found in DevEx Sourcecode that GridListEditor only Supports Client and Queryable DataAccessModes - so is the above statement wrong?

Answers approved by DevExpress Support

created 4 years ago (modified 4 years ago)

Hello Martin,

Server mode is not supported in Blazor UI. However, starting with v20.2.5 Blazor supports the Queryable mode that works similarly. It selects data partially depending on the current Data Grid page or the lookup editor's scroll position. To enable the Queryable mode in root and lookup List Views, use the Options -> DataAccessMode model property.
Starting with v20.2.5, the Client mode loads all records, as in WinForms and ASP.NET WebForms. Soon we will update our documentation to describe differences between these modes in greater detail.

    Show previous comments (6)
    Anatol (DevExpress) 4 years ago

      Hello Martin,

      We did not implement sorting and grouping by such columns yet. We are going to implement this for the Client mode soon - our developers are already working on this. We will likely be able to implement this in Server (or Queryable) mode later (in v21.2), when a new Blazor Grid is ready.

      M M
      Martin Praxmarer - DevExpress MVP 4 years ago

        thx Anaton - was just a bit confusion since you said initially it should work in client mode :)

        DevExpress Support Team 3 years ago

          Hello,

          In v22.1, DxGridListEditor is the main List Editor. This editor supports Client and Server Data Access modes with the features described above. You can refer to the following article to see how to enable DxGridListEditor in older versions: Enable the DxGridListEditor.

          Thanks,
          Stanislav

          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.