Title: More column filter options in browser · Issue #1463 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: More column filter options in browser · Issue #1463 · sqlitebrowser/sqlitebrowser
X Title: More column filter options in browser · Issue #1463 · sqlitebrowser/sqlitebrowser
Description: Describe the new feature It would be nice to have some options besides 'like' when filtering in the browser. Similar to Excel's "blanks", "non-blanks" in Autofiltered columns. (I'm not a big fan of "top 10") I'd add "NULL" & "not NULL" a...
Open Graph Description: Describe the new feature It would be nice to have some options besides 'like' when filtering in the browser. Similar to Excel's "blanks", "non-blanks" in Autofiltered columns. (I'm not a big fan of...
X Description: Describe the new feature It would be nice to have some options besides 'like' when filtering in the browser. Similar to Excel's "blanks", "non-blanks" in Autofiltere...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1463
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"More column filter options in browser","articleBody":"\u003c!-- Thanks for coming here to suggest a new feature. :) -->\r\n\r\nDescribe the new feature\r\n--------------------------\r\nIt would be nice to have some options besides 'like' when filtering in the browser.\r\n\r\nSimilar to Excel's \"blanks\", \"non-blanks\" in Autofiltered columns. (I'm not a big fan of \"top 10\")\r\n\r\nI'd add \"NULL\" & \"not NULL\" as you can't type anything to represent them, and perhaps \"Blob\" and \"not Blob\" for the same reason. These are helpful when looking for anomalies.\r\n\r\nIt's possible to get at NULL values for a single column by sorting & scanning visually, but that doesn't scale.\r\n\r\nIt's possible to drop into SQL to do this, but that result table can't be filtered (except by writing more SQL). Hmmm - would it be possible to have the browser take the results of my query and load them into the filterable window? e.g. create a temporary table from the results of a select in the \"execute SQL' tab, and put that into your nice filterable table. Seems like that would be straightforward for viewing (my primary use case), but harder to send modifications back to the real tables.\r\n\r\nIt also would be useful to add a simple JOIN column (e.g. viewing orders, would be nice to add 'join order.customerid = customers.id')\r\n\r\nAdditional info\r\n---------------\r\nPlease answer these questions before submitting your feature request.\r\n\r\n#### Is your feature request related to an issue? Please include the issue number.\r\nNo\r\n\r\n#### Does this feature exist in another product or project? Please provide a link.\r\nExcel.\r\n\r\n#### Do you have a screenshot? Please add screenshots to help explain your idea.\r\nNope. Just run excel autofilter on any spreadsheet and look at the dropdowns. [All] [Blanks] [Non-Blanks] [Custom]\r\n","author":{"url":"https://github.com/tlhackque","@type":"Person","name":"tlhackque"},"datePublished":"2018-07-05T18:01:14Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1463"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:1c0dd07b-1bb2-2f71-dee1-04d5925eca2e |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | D490:19CA5F:3A73A:4D67D:6AFD39DE |
| html-safe-nonce | c1db43a0731607f1a329decd126bd88727e531e7a2c46d4bc4b73246df8f7bea |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJENDkwOjE5Q0E1RjozQTczQTo0RDY3RDo2QUZEMzlERSIsInZpc2l0b3JfaWQiOiIxMDUxMTkxODQzMDM2Njc0NTI2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | 9d4e64c2b8945a9be8baddd2679889290b720be47525e133cef1e74c11cf7c8d |
| hovercard-subject-tag | issue:338672404 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1463/issue_layout |
| twitter:image | https://opengraph.githubassets.com/5654f5cc6bca2e423e1234cfe3a09fcfd4a84aed043fb70297b803e3bc0fa6db/sqlitebrowser/sqlitebrowser/issues/1463 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/5654f5cc6bca2e423e1234cfe3a09fcfd4a84aed043fb70297b803e3bc0fa6db/sqlitebrowser/sqlitebrowser/issues/1463 |
| og:image:alt | Describe the new feature It would be nice to have some options besides 'like' when filtering in the browser. Similar to Excel's "blanks", "non-blanks" in Autofiltered columns. (I'm not a big fan of... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | tlhackque |
| hostname | github.com |
| expected-hostname | github.com |
| None | bdbacc25b921224ff0befcb9e629560a1255be51aec9991d6e3f95b5e9151474 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 556dd37bb0aceffb25724e151b5d858b3265b40b |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width