Drop down filter 'Excel' style in headers

(12 posts) (6 voices)
  1. SteveD, Member

    Would it be possible to add an Excel style filter into headers of tables. It would work similar to the existing search box, but rather than being tied to a whole table it would be linked to individual columns, and rather than the user typing a value into the search box it would be a drop down list (or popup in mydbr terms) that contains all of the unique values in the respective column.

    If you really wanted to push the boat out it could work exactly like Excel, where the user can select multiple entries from the list via check boxes, and the results would filter to only show the selected entries.

  2. myDBR Team, Key Master

    You could try to locate suitable jQuery plugin that would do this.

    myDBR Team

  3. Philip, Member

    This would be a great feature. Could anyone elaborate on how to locate a suitable jQuery plugin please? And how to use it. And what that is. Thanks.

  4. duane, Member

    Hi, Looks like in version 3.9 that this is possible ('Column filter capability' according to release notes) - but I can't find documentation on this. How is this done?

  5. myDBR Team, Key Master

    Documentation is now updated.

    The command is dbr.column.filter. There is a select-filter and text-filter. The command has syntax:

    select 'dbr.column.filter', 'Category', 'select';
    select 'dbr.column.filter', 'Title', 'text';

    myDBR Team

  6. Philip, Member

    This is great, thanks a lot.

  7. adamhaeder, Member

    This is great and works as advertised. The only caveat is that because this is client-side filtering, if you export your result set you don't get the filtered view that you get if you use the 'original' filter field.

  8. duane, Member

    The select 'dbr.column.filter' command can currently only use text and select from what I can tell. Is there any way to specify a greater than/less than value? I'd specifically like to do this with numbers in a column.

  9. myDBR Team, Key Master

    Not at the moment, no. For now the filters work with exact matches.

    myDBR Team

  10. rpark, Member

    Is there anyway to filter the columns by equal to, greater than, less than, etc.?

  11. myDBR Team, Key Master

    with text columnfilter you can do:

    >300 - greater than 300
    <300 - less than 300
    =300 - equal to 300
    >E - greater than 'E' in aphabetical order
    <2020-01-22 - Date less than 2020-01-22

    myDBR Team

  12. rpark, Member

    Oh amazing! This is great to know! Thank you very much!


You must log in to post.