C1 combo - how to filter list

C1 combo - how to filter list

Posted by: luis_carlosh on 6 March 2023, 9:45 am EST

• 

  luis_carlosh

  • Post Options:
  • Link
    Copy

  Posted 6 March 2023, 9:45 am EST - Updated 6 March 2023, 10:51 am EST

  I have a c1Combo box with data bounded to a table -tblproviders- which normally shows all the records. ID-PROVIDER-VERIFIEDBut I want to filter the list at will by the VERIFIED boolean field and that the C1 Combo shows only some of that data and not all. How is it done? How Filter and Unfilter the list?

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 6 March 2023, 3:57 pm EST

  Hi,

  To filter the rows of the C1Combo, you will need to filter its DataSource. Since you are using a DataTable, you can use the DataView.RowFilter property for the same. Please see the attached sample showing a simple implementation.

  attachment: ComboFiltering.zip

  Best Regards,

  Kartik

• 

  luis_carlosh

  • Post Options:
  • Link
    Copy

  Posted 7 March 2023, 9:26 am EST

  I get result on filtering dt but get error when I try to hide ID column
  
  https://prnt.sc/JSvLvtNnvboI

  This is the design of control
  
  https://prnt.sc/QpBf-kjMpJ3a

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 8 March 2023, 6:11 pm EST

  Hi,

  We tried to reproduce the issue by hiding the “Id” column using code similar to your screenshot, but we could not reproduce the issue on our end. Please see the updated sample showing the behavior on our end.

  If you are doing something different, please provide a small sample or update the attached sample to replicate the issue, so we can investigate further and assist you better. Also, let us know the exact version of C1 controls you are using. We are using the latest 2022v3 (588) version on our end.

  Attachment: ComboFiltering_updated.zip

  Kind Regards,

  Kartik