René's URL Explorer Experiment


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

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@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-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:1c0dd07b-1bb2-2f71-dee1-04d5925eca2e
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idD490:19CA5F:3A73A:4D67D:6AFD39DE
html-safe-noncec1db43a0731607f1a329decd126bd88727e531e7a2c46d4bc4b73246df8f7bea
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJENDkwOjE5Q0E1RjozQTczQTo0RDY3RDo2QUZEMzlERSIsInZpc2l0b3JfaWQiOiIxMDUxMTkxODQzMDM2Njc0NTI2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac9d4e64c2b8945a9be8baddd2679889290b720be47525e133cef1e74c11cf7c8d
hovercard-subject-tagissue:338672404
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1463/issue_layout
twitter:imagehttps://opengraph.githubassets.com/5654f5cc6bca2e423e1234cfe3a09fcfd4a84aed043fb70297b803e3bc0fa6db/sqlitebrowser/sqlitebrowser/issues/1463
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/5654f5cc6bca2e423e1234cfe3a09fcfd4a84aed043fb70297b803e3bc0fa6db/sqlitebrowser/sqlitebrowser/issues/1463
og:image:altDescribe 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:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernametlhackque
hostnamegithub.com
expected-hostnamegithub.com
Nonebdbacc25b921224ff0befcb9e629560a1255be51aec9991d6e3f95b5e9151474
turbo-cache-controlno-preview
go-importgithub.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git
octolytics-dimension-user_id7454271
octolytics-dimension-user_loginsqlitebrowser
octolytics-dimension-repository_id19416551
octolytics-dimension-repository_nwosqlitebrowser/sqlitebrowser
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id19416551
octolytics-dimension-repository_network_root_nwosqlitebrowser/sqlitebrowser
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release556dd37bb0aceffb25724e151b5d858b3265b40b
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1463#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1463
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1463
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlitebrowser%2Fsqlitebrowser
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1463
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1463
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1463
sqlitebrowserhttps://github.com/sqlitebrowser
sqlitebrowserhttps://github.com/sqlitebrowser/sqlitebrowser
Codehttps://github.com/sqlitebrowser/sqlitebrowser
Issues786 (786)https://github.com/sqlitebrowser/sqlitebrowser/issues
Pull requests30 (30)https://github.com/sqlitebrowser/sqlitebrowser/pulls
Discussionshttps://github.com/sqlitebrowser/sqlitebrowser/discussions
Actionshttps://github.com/sqlitebrowser/sqlitebrowser/actions
Projectshttps://github.com/sqlitebrowser/sqlitebrowser/projects
Wikihttps://github.com/sqlitebrowser/sqlitebrowser/wiki
Security and qualityhttps://github.com/sqlitebrowser/sqlitebrowser/security
Insightshttps://github.com/sqlitebrowser/sqlitebrowser/insights
https://github.com/sqlitebrowser/sqlitebrowser
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1463
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1463
More column filter options in browserhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1463#top
https://github.com/mgrojo
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issue-338672404
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-402809259
https://github.com/sqlitebrowser/sqlitebrowser/wiki/Using-the-Filtershttps://github.com/sqlitebrowser/sqlitebrowser/wiki/Using-the-Filters
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-402815162
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-402826477
justinclifthttps://github.com/justinclift
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#event-1718835628
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-402829884
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-402835546
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-402871933
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 5, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-402878867
mgrojohttps://github.com/mgrojo
on Jul 7, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#event-1721653097
mgrojohttps://github.com/mgrojo
on Jul 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#event-1721825370
Issue #1463: give assistance to users in using the filtershttps://github.com/sqlitebrowser/sqlitebrowser/commit/bbe2e33ea4f1f22c85d133bdc8af20ea986eea2f
#1463https://github.com/sqlitebrowser/sqlitebrowser/issues/1463
bbe2e33https://github.com/sqlitebrowser/sqlitebrowser/commit/bbe2e33ea4f1f22c85d133bdc8af20ea986eea2f
https://github.com/n-arakawa
n-arakawahttps://github.com/n-arakawa
on Jul 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-403286457
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jul 8, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-403291544
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jul 9, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-403630330
bbe2e33https://github.com/sqlitebrowser/sqlitebrowser/commit/bbe2e33ea4f1f22c85d133bdc8af20ea986eea2f
mgrojohttps://github.com/mgrojo
on Jul 12, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#event-1731264388
Support for operator filters for stringshttps://github.com/sqlitebrowser/sqlitebrowser/commit/4c9f55660b0ea3bd9b787f03dfd861f6c993e511
4c9f556https://github.com/sqlitebrowser/sqlitebrowser/commit/4c9f55660b0ea3bd9b787f03dfd861f6c993e511
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Aug 23, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-415413308
mgrojohttps://github.com/mgrojo
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
on Sep 2, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#event-1822211182
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Sep 2, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-417924397
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Sep 6, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-419067903
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Sep 6, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-419201072
@tlhackquehttps://github.com/tlhackque
https://github.com/dt192
dt192https://github.com/dt192
on Oct 13, 2024https://github.com/sqlitebrowser/sqlitebrowser/issues/1463#issuecomment-2409137767
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1463
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1463
mgrojohttps://github.com/mgrojo
enhancementFeature requests.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22enhancement%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.