We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

FilterType.Excel: "Select All" does not clear filter

Thread ID:

Created:

Updated:

Platform:

Replies:

118958 Apr 28,2015 08:25 AM UTC Apr 30,2015 11:43 AM UTC ASP.NET MVC 3
loading
Tags: Grid
microc
Asked On April 28, 2015 08:25 AM UTC

Hi,
1. Filter some items in a grid column
2. Apply the filter
2. After which on the same column click on "Select All"
3. In my project the previous last filter has passed to the controller (i.e. in dm.Where).
4. Using "Clear Filter" it works

I'm using Essential Studio Version 13.1.0.21.

Thanks for your helps.

Rocco






Balaji Marimuthu [Syncfusion]
Replied On April 29, 2015 01:17 PM UTC

Hi Rocco,

Thanks for using Syncfusion Products.

We have tested the reported issue with the provided steps and we are able to reproduce the issue. Could you please check the below description and let us know whether you are facing the same issue or not?

If we apply filter for the second time to already filtered column using “Select All” it’s not returned the all records. It returns only the first two value of filter check box instead of all records.

If the scenario is wrong or if you are facing any other issue other than this, please share us your controller and view file . Also share us your browser details to reproduce the issue that will be helpful to provide better solution ASAP.

Please let us know if you have any queries.

Regards,
Balaji Marimuthu

microc
Replied On April 29, 2015 02:39 PM UTC

Hi Balaji,
yes, you are right, same problem faced.
But I have also been seen that the filters from the third element onward are ignored, they work up to the second element.
In a column that contains only five unique values, if you deselect only last two values, the grid filters only first two values.
I use Internet Explorer 11 and Firefox 37.0.2, the issue is the same on both.

Thanks for your helps.

Rocco

My Controller:
  //....
        public enum FinderSubAction { RowsTotal, RowsIn, RowsOut, TableTotal, TableIn, TableOut }
  /....
        [HttpPost]
        public ActionResult DataSource(Syncfusion.JavaScript.DataManager dataManager, FinderSubAction? finderSubAction, string messageIdentifier)
        {
            var messages = new MessageListTable();
            var msgIdName = string.Empty;
            if (messageIdentifier != null)
            {
                msgIdName = messageIdentifier;
            }
            IQueryable<MessageListRow> dataRows = null;
            switch (finderSubAction)
            {
                case FinderSubAction.RowsIn:
                    dataRows = messages.RowsIn.Where(x => x.MessageIdentifierName.EndsWith(msgIdName));
                    break;
                case FinderSubAction.RowsOut:
                    dataRows = messages.RowsOut.Where(x => x.MessageIdentifierName.EndsWith(msgIdName));
                    break;
                case FinderSubAction.RowsTotal:
                    dataRows = messages.RowsAll.Where(x => x.MessageIdentifierName.EndsWith(msgIdName));
                    break;
                case FinderSubAction.TableIn:
                    dataRows = messages.RowsIn;
                    break;
                case FinderSubAction.TableOut:
                    dataRows = messages.RowsOut;
                    break;
                case FinderSubAction.TableTotal:
                default:
                    dataRows = messages.RowsAll;
                    break;
            }
            IEnumerable data = dataRows.Select(s => new MessageListRowModels
                                                    {
                                                        TransactionId = s.TrxId,
                                                        MessageIdentifier = s.MessageIdentifierName,
                                                        Sender = s.Trx.Sender,
                                                        Receiver = s.Trx.Receiver
                                                    }).ToList();
            var count = dataRows.Count();
           
            DataOperations operation = new DataOperations();
            if (dataManager.Where != null && dataManager.Where.Count > 0) //Filtering
            {
                data = operation.PerformWhereFilter(data, dataManager.Where, "and");
                var filtered = (IEnumerable<object>)data;
                count = filtered.Count();
            }
            if (dataManager.Sorted != null && dataManager.Sorted.Count > 0) //Sorting
            {
                data = operation.PerformSorting(data, dataManager.Sorted);
            }
            if (dataManager.Search != null && dataManager.Search.Count > 0) //Searching
            {
                data = operation.PerformSearching(data, dataManager.Search);
                var filtered = (IEnumerable<object>)data;
                count = filtered.Count();
            }
           
            if (dataManager.Skip != 0)
            {
                data = operation.PerformSkip(data, dataManager.Skip);
            }
            if (dataManager.Take != 0)
            {
                data = operation.PerformTake(data, dataManager.Take);
            }
 
            DataResult result = new DataResult();
            result.result = data;
            result.count = count;
            return Json(result, JsonRequestBehavior.AllowGet);
        }



Balaji Marimuthu [Syncfusion]
Replied On April 30, 2015 11:43 AM UTC

Hi Rocco,

We considered this requirement “Sever side filtering is not working properly in the excel filter” as bug and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates.

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents

Please let us know any queries.

Regards,

Balaji Marimuthu


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;