Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Better Filter Feature For Data Tab

forums forums SQLyog SQLyog: Bugs / Feature Requests Better Filter Feature For Data Tab

Tagged: , ,

This topic contains 3 replies, has 3 voices, and was last updated by  Sibin A S 2 months ago.

  • Author
    Posts
  • #13411

    rguillemette
    Member

    Hello,

     

    In Table Data tab, when I’m browsing some data, I can add a filter.

     

    Could you consider adding the following features :

     

    1- Clicking on the filter icon should give me the possiblity to edit my filter, not always deleting it. Maybe right click to edit and left click to delete…

     

    2- Adding an option to persist the filter per table. When browsing data, I often jump between 2 tables and the filter is always deleted. Very annoying.

     

     

    Thank you

  • #35484

    Sibin A S
    Moderator
    Hello rguillemette,

     

    We are not sure how this post was missed, please find the solution to your queries,

     

          1. The “Filter” icon in the Result window refreshes the existing filter and provides an option to create new filter.

     

    In your case, once a filter is created, you can use the existing filter to add/modify it by  selecting the corresponding cell in the table data and right click on it and select the “Custom Filter” option from the option-list (“Filter -> Custom Filter”) to retain/use the filter. Please refer the below screenshot for the same

     

    S3aV4b8.png

     

     

     

          2. Filter is table specific. Same filter cannot be applied to different tables, Consider the case when the same filter is applied on another table that do not have any common columns, this would result in an error.

     

    Regards,

    Sibin

  • #35971

    John Rix
    Participant

    I think the second request was misinterpreted here – the customer is asking that filters applied to a particular table are remembered for THAT TABLE so that when you return to that table after visiting another, the filter is restored automatically. They were not suggesting that one filter should travel between tables.

    For what it is worth, I think the suggestion is a very good one and I would like to see it implemented myself. This would save me some hassle!

    From a general standpoint, remembering the state of a table when switching between tables would really help with a lot of tasks. Specifically:

    A) What filters are applied, as per above suggestion
    B) Current sort column and direction
    C) Current page of results being viewed (ie. first 1000 rows or latter)
    D) Scroll position or selected row

    Regards,
    John

  • #35988

    Sibin A S
    Moderator

    Hi John,

    We have added your request to our feature/issue tracker, here. But the priority is yet to be assigned.

    Regards,
    Sibin

You must be logged in to reply to this topic.