1. Home
  2. Forum
  3. ASP.NET MVC
  4. Datamanager is not filtering all columns

Datamanager is not filtering all columns

Hi,

I used the autocomplete control with 5 columns, but if I search through the items only the first two columns will be used. It looks like the DataOperations Execute Method do not recognize all predicates in the where property. I also tested the Perform-methods. Same result.

I attached my whole code as a zip file.

Kind regards,
Carsten


Attachment: SyncfusionMvcApplication2_7bd885bf.zip

5 Replies
BM Balaji M Syncfusion Team August 20, 2018 11:23 AM UTC

Hi Carsten, 

Thanks for using Syncfusion products. 

We have checked your shared project. But, unfortunately we are unable to reproduce your reported issue.  In autocomplete multiple column search is based on ‘searchColumnIndices’ property.  In below sample, searching based on first three columns using searchColumnIndices property.  If you enter ‘t’ text in autocomplete, it will search first three columns with the text ‘t’ and filter that four data’s and shown a suggestion list with four data’s.  Please find the below screenshot. 

 

    
We have used your shared code and prepared a below sample.   

In a post back, I get where query predicates properly based on searchColumnIndices property after search any text in autocomplete.  In this below attached sample, the you have used first 4 column indexes, So searching based on first four columns and where predicates are passed correctly.  Please find the below video for your reference.   

If still face issue, please provide more exact details of your issue or please share video with your issue.  So, that we can check and provide solution at earliest. 

Let us know If you have any queries. 

Regards, 
M. Balaji 


CB Carsten Buchmann August 20, 2018 02:57 PM UTC

Ok, sorry I forgot to extend selectColumnIndices to the "city" column. But as you can see in my attached video the filter doesn't work. Only if I filter for a character which exists in more than one column the filter works. If it only exists in one column it doesn't.

Attachment: ScreenCapture_20.08.2018_16.48.17.wmv_79a8b18d.zip

BM Balaji M Syncfusion Team August 21, 2018 03:30 PM UTC

Hi Carsten 

We have checked your reported issue and able to reproduce it.  This issue is, because of where predicates are not properly get on post back.  In server side, ‘where’ predicates data are get inside the multiple data.  We need two days time to validate it, so we will update further details by 24th August 2018.  

Let us know if you have any queries. 

Regards, 
M. Balaji 


CB Carsten Buchmann August 27, 2018 12:44 PM UTC

Do you got any news for me?

BM Balaji M Syncfusion Team August 27, 2018 12:58 PM UTC

Hi Carsten  

We confirmed that the issue with Searched Column Indices where predicates are not generated properly on post back is a defect and we have logged a defect report. The fix for this issue is estimated to be available in our Volume 3, 2018 release which is scheduled at 9/17/2018 


Let us know if you have any queries. 

Regards, 
M. Balaji  


Loader.
Up arrow icon