search

simonw / datasette

An open source multi-tool for exploring and publishing data
https://datasette.io
Apache License 2.0
9.59k stars 691 forks source link

Add notlike table filter #750

Closed simonw closed 4 years ago

simonw commented 4 years ago

I found myself wanting that for applying the opposite of this: https://github-to-sqlite.dogsheep.net/github/dependent_repos?dependent__like=%25simonw%2F%25&_sort_desc=dependent_stars

simonw commented 4 years ago

So that I can do this: https://github-to-sqlite.dogsheep.net/github/dependent_repos?_where=dependent%20not%20like%20%27%simonw/%%27

simonw commented 4 years ago
data__names__5_rows_where_where_name_not_like__Sim___sorted_by_rowid
simonw commented 4 years ago

Demo: https://latest.datasette.io/fixtures/roadside_attractions?name__notlike=%25museum%25

Docs: https://datasette.readthedocs.io/en/latest/json_api.html#column-filter-arguments