Start a new topic

Provide "count" based on current filter

When displaying the grid for a table TBL using a filter WHERE_FILTER, very often I find myself opening a SQL Cmdr window for the sole purpose of executing:

     select count from <TBL> <WHERE_FILTER>;


I would like to have a button or functionality that would execute this for me and then display the result in either a dialog window, "toast" message, or special area of the Filter section.


It would double as a "verify filter" action, checking the syntax of the WHERE clause and performing the count without necessarily updating the grid contents (this could be an option, since some people might prefer always updating the grid, but I would definitely prefer not updating it until I click the checkmark).


Here are two possible implementations:

1 Comment

Thanks Charles,


I will open a feature request ticket and we will discuss it here.


Regards


Roger

Login or Signup to post a comment