ejGrid: menu filter preview not working with rest service

3 Replies
3 Participants

Created by
FM Florian Mihalits

Platform
jQuery

Platform
jQuery

Control
ejGrid

Created On
Jun 27, 2016 05:39 AM UTC

Last Activity On
Jun 29, 2016 04:09 AM UTC

Want to subscribe?
SIGN IN

Hello.

I´m using an ejGrid with an asp.net mvc rest service, which works fine.

For filtering I´m using your menu filter. Filtering itself works pretty well, but when you start typing into the filter value box, it displays "no suggestions" although there should be valid suggestions.

Here is a part of my client code (I´m using typescript):

var dataManager = new ej.DataManager({
                url: 'valid-URL',
                adaptor: new ej.UrlAdaptor(),
                crossDomain: true
            });

            self.grid = $("#gridResellers").ejGrid({
                dataSource: dataManager,
                allowPaging: true,
                allowSorting: true,
                allowSelection: true,
                selectionSettings: { selectionMode: ["row"] },
                sortSettings: { sortedColumns: [{ field: "Number", direction: "descending" }] },
                toolbarSettings: {
                    showToolbar: true,
                    toolbarItems: ["add", "edit", "delete"],
                    customToolbarItems: [{ templateID: "#activate" }, { templateID: "#deactivate" }]
                },
                editSettings: { allowEditing: false, allowAdding: true, allowDeleting: false },
                gridLines: ej.Grid.GridLines.None,
                allowFiltering: true,
                filterSettings: { filterType: "menu", enableCaseSensitivity:false, showPredicate: false},
                enableResponsiveRow: true,
                columns: [
                    { field: "Id", isPrimaryKey: true, visible: false },
                    { field: "Locked", headerText: Localization.manager.get("Reseller_Locked"), type: "boolean" },
                    { field: "Number", headerText: Localization.manager.get("Reseller_Number"), type: "string" },
                    { field: "CompanyName", headerText: Localization.manager.get("Partner_Company"), type: "string" },
                    .....
                ],
                toolBarClick(args) {
                    .....
                },
                rowSelected(args) {
                    ....
                },
                actionComplete(args) {
                    ....
                }
            });

And here is a part of my server side code:

public async Task<ActionResult> Resellers(Syncfusion.JavaScript.DataManager dm)
        {
            var resellerService= DependencyResolver.Current.GetService<IResellerService>();
            Syncfusion.JavaScript.DataSources.DataOperations operation = new Syncfusion.JavaScript.DataSources.DataOperations();

            var totalCount = await resellerService.CountTotalAsync();
            var resultList = resellerService.Filter("");
            var totalFiltered = await resellerService.CountFilteredAsync("");

            //Sortierung
            if (dm.Sorted != null && dm.Sorted.Count > 0)
            {
                resultList = (IQueryable<Reseller>)operation.PerformSorting(resultList, dm.Sorted);
            }

            //Filter
            if (dm.Where != null && dm.Where.Count > 0)
            {
                resultList = (IQueryable<Reseller>)operation.PerformWhereFilter(resultList, dm.Where, dm.Where[0].Condition);
                totalCount = resultList.Count();
            }

            //Paging
            if (dm.Skip != 0)
            {
                resultList = (IQueryable<Reseller>)operation.PerformSkip(resultList, dm.Skip);
            }
            if (dm.Take != 0)
            {
                resultList = (IQueryable<Reseller>)operation.PerformTake(resultList, dm.Take);
            }

            var resultListVm = new List<ResellerItemVm>();
            foreach (var item in resultList)
            {
                var itemVm = new ResellerItemVm()
                {
                    Id = item.Id,
                   ...
                };
                resultListVm.Add(itemVm);
            }

return Json(new { result = resultListVm, count = totalCount }, JsonRequestBehavior.AllowGet);
}

Any help is appreciated.

Thanks and all the best,

Florian

3 Replies

MF Mohammed Farook J Syncfusion Team June 28, 2016 12:38 PM UTC

Hi Florian,

Thanks for contacting Syncfusion Support.

We have validated your provide code and reported issue, we have found the issue when return data form controller to Grid. So we suggest to use the following code example in “DataOperation”

[controller]

public async Task<ActionResult> DataSourceAsync(DataManager dm)

{

Task<int> longRunningTask = LongRunningOperationAsync();

int delay = await longRunningTask;

DataResult result = new DataResult();

DataOperations operation = new DataOperations();

var DataSource = from a in new NorthwindDataContext().OrdersViews select a;

result.result = DataSource;

result.count = DataSource.Count();

if (dm.Search != null && dm.Search.Count > 0) //searching

{

result.result = operation.PerformSearching(DataSource, dm.Search);

}

if (dm.Where != null && dm.Where.Count > 0) //Filtering

{

result.result = operation.PerformWhereFilter(DataSource, dm.Where, dm.Where[0].Operator);

}

if (dm.Skip > 0)

result.result = operation.PerformSkip(result.result, dm.Skip);

if (dm.Take > 0)

result.result = operation.PerformTake(result.result, dm.Take);

return Json(dm.RequiresCounts ? (object)result : (object)result.result, JsonRequestBehavior.AllowGet);

}

public async Task<int> LongRunningOperationAsync()

{

await Task.Delay(1000); //1 seconds delay

return 1;

}

In above code example , we have create a simple time delay async task and perform “DataOpeations” like sorting, paging and filtering in Grid . Please find the screen shot.

Filter choice request in client side: