Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Can't filter with numbers #2212

Open
fzakaria opened this issue Dec 4, 2023 · 0 comments
Open

Can't filter with numbers #2212

fzakaria opened this issue Dec 4, 2023 · 0 comments

Comments

@fzakaria
Copy link

fzakaria commented Dec 4, 2023

I have a schema that uses numbers for a column (actually it's a boolean 1 or 0 but SQLite doesn't have Boolean).
I can't seem to get the facet to work or even filtering on this column.

My guess is that Datasette is "stringifying" the number and it's not matching?
Example: https://debian-sqlelf.fly.dev/debian/elf_symbols?_sort_desc=name&_facet=exported&exported=0
tylermckenz1 added a commit to TimothyOLeary/datasette that referenced this issue May 1, 2024
@tylermckenz1
Individual Issue simonw#2212
86eeac3 
Similarly to Group Issue 3 (1910) the issue was there was no type checking for booleans. I added another elif to check if the values are booleans.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@fzakaria