FlexGrid add row for quick text filter like TrueDbGrid? Combobox vs Checked?

FlexGrid add row for quick text filter like TrueDbGrid? Combobox vs Checked?

Posted by: lbd34778 on 16 January 2020, 11:39 am EST

• 

  lbd34778

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 January 2020, 11:39 am EST

  Most of our grids are flexgrids and trying to be more uniform by converting some truedbgrids to flexgrids. Is it possible to add a row that acts as a text filter, similar to how TrueDbGrids work?

  Also, we have a custom combobox that has a checkedlist inside of it. I’m trying to go a little deeper but when I add it to a normal windows form it has the drop down arrow. When I add it to a flexgrid it loses the drop down arrow. It will drop down but you have to double click in the cell.

  The code below has the custom drop down (checkedcbSampleGroups ), the other ones always show the arrow but this one does not.

  
  FlexGrid.Cols(NameOf(ProductInfo.DosageUnits)).Editor = cboDosageUnits
  
  FlexGrid.Cols(NameOf(ProductInfo.AutoSpikes)).Editor = autospikedropdown
  
  FlexGrid.Cols(NameOf(ProductInfo.EUCriteria)).Editor = EUCriteriadropdown
  
  FlexGrid.Cols(NameOf(ProductInfo.UserGroupNames)).Editor = checkedcbSampleGroups          
  
  
  FlexGrid.Cols(NameOf(ProductInfo.UserGroupNames)).ShowButtons = C1.Win.C1FlexGrid.ShowButtonsEnum.Always
  
  FlexGrid.Cols(NameOf(ProductInfo.UserGroupNames)).ShowButtons = C1.Win.C1FlexGrid.ShowButtonsEnum.Always
  
  FlexGrid.Cols(NameOf(ProductInfo.DosageUnits)).ShowButtons = C1.Win.C1FlexGrid.ShowButtonsEnum.Always
              
  FlexGrid.Cols(NameOf(ProductInfo.AutoSpikes)).ShowButtons = C1.Win.C1FlexGrid.ShowButtonsEnum.Always
              
  FlexGrid.Cols(NameOf(ProductInfo.EUCriteria)).ShowButtons = C1.Win.C1FlexGrid.ShowButtonsEnum.Always
  

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 17 January 2020, 9:04 am EST

  Hello,

  1. From what I understand, you want to have a FilterRow implemented in C1FlexGrid that filters column data by the text entered in it, correct?
     
     For this, I would like to inform that directly FlexGrid does not have a specific row for filtering as in the case for TrueDbGrid. However, there is still one way through which you can implement the same. For this, please refer attached sample application.
     
     *The application supports filtering for both the simple text and logical expressions, for details please refer the readme attached with the application.
     
     FilterRow.zip
  2. I am not sure how you’re creating the custom combobox, but it should definitely show the dropdown arrow. Would it be possible for you to share your approach or some guide that you followed for showing checkedlist in the dropdown? This will help me in assisting you better on this.

  Thanks & Best wishes,
  
  Ruchir

• 

  lbd34778

  • Post Options:
  • Link
    Copy

  Posted 17 January 2020, 9:27 am EST

  I’ll have to ask other devs about sharing custom one. The attached project is a great launch point to be able to add a filter row, thank you for sharing!

  Will it be possible to have this and the drop down filters from flexgrid?

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 20 January 2020, 2:05 am EST

  Hello,

  We’re glad that it helped and you can start that.

  I’ll have to ask other devs about sharing custom one
  
  Sure, take your time.

  Will it be possible to have this and the drop down filters from flexgrid?
  
  Apologies, but FilterRow does not work in conjunction with default FlexGrid column filters.

  Thanks,
  
  Ruchir

• 

  lbd34778

  • Post Options:
  • Link
    Copy

  Posted 21 January 2020, 9:54 am EST

  Thanks so much, in this case this can be resolved as I’ve got a pretty good prototype to show rest of team and go from there.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 22 January 2020, 1:36 am EST

  Glad that you’re able to proceed further.
  
  Should you need any assistance further, let me know.

  ~Ruchir