DataManager Search

[Sidnei V Lavandoski]

I´m using Entity Framework 6 and I have a table with 2000 > rows.

The Grid component doesn´t have OnDemand option yet, then looking for in this forum I found the solution using DataManager (post http://www.syncfusion.com/forums/118301/grid-performance-in-ie)

Meanwhile, I would like to use search instead filtering, then I change the code like this:

//Provide grid datasource

        public ActionResult GetOrderData(DataManager dm)

        {

            RuasModel ruas = new RuasModel();

            IEnumerable data = ruas.ListaRuas();

            int count = ruas.ListaRuas().Count;

            DataOperations operation = new DataOperations();

            //Performing filtering operation

            if (dm.Where != null)

            {

                data = operation.PerformWhereFilter(data, dm.Where, "and");

                var filtered = (IEnumerable<object>)data;

                count = filtered.Count();

            }

            if (dm.Search != null)

            {

                data = operation.PerformSearching(data, dm.Search);

            }

            //Performing sorting operation

            if (dm.Sorted != null)

                data = operation.PerformSorting(data, dm.Sorted);

            //Performing paging operations

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

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

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

        }

but when make a search the data object always returns null. Using the Visual Studio debug, the dm.Search is not null.

Is there a option to do this?

Thank you

[Prasanna Kumar Viswanathan]

Hi Sidnei,

Sorry about the inconvenience caused.

We created a sample using IEnumerable data and performing Datamanager operations. We afraid that we were unable to reproduce the issue at run time. Did the object returns null only for string values or all values? Because the searching is case sensitive for string values.

Are you facing that case sensitive issue or any other issues?

Please download the sample from the below link:

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/118425/RemoteServerAdaptorSample_129241-818803486.zip

If we misunderstood your query, please provide a simple sample for us or make this one as issue reproducible sample, we are happy to assist you.

Please let me know if you have any concerns.

With Regards,

Prasanna Kumar N.S.V

[Sidnei V Lavandoski]

Hi Prasanna, thank you by your quick assistance!

In fact, the problem was case sensitive, you are correct.

Is there a way to ignore the case sensitive in the search?

Thank you again.

[Prasanna Kumar Viswanathan]

Hi Sidnei,

We considered this requirement “Searching is case sensitive using DataManager Operations” as a 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

Regards,

Prasanna Kumar N.S.V