Local filtering with remote data

[Celso]

Hi,

Is there a way to load data remotely eg. using WebAdaptor, but use local filtering similar to what happens when data is loaded from an array, so that filtering doesn't have a server roundtrip?

Thanks.

[Vinitha Jeyakumar]

Hi Celso,

On remote data binding, every time invoking executeQuery will send request to the server and the query will be processed on server-side. To avoid post back to server on calling executeQuery, you can set the DataManager to load all the data on initialization time and make the query processing in client-side. To enable this behavior, you can use the offline property of DataManager.

Code snippet:

created () {
      new DataManager({ url: SERVICE_URI, adaptor: new ODataAdaptor, offline: true }).ready.then((e) => {
        this.items = e.result;
    });

Documentation: https://ej2.syncfusion.com/vue/documentation/data/how-to/#work-in-offline-mode

Regards,

Vinitha

[Celso Pinto]

Thank you Vinitha. Wouldn't offline mode then prevent us from updating data when moving cards between columns?

[Vinitha Jeyakumar]

Hi Celso,

Once we enabled the offline property of Data Manager it will load all the data on initialization time and make the query processing in client-side and it won't update data when moving cards between columns in Kanban.

Regards,

Vinitha