HubDB get table rows filter operator 'not_like' works exactly as 'like', not its opposite
There are next to none instructions how the operator 'like' works when getting HubDB table rows through API - at least it doesn't work like the SQL 'like', as it doesn't accept (URL encoded) % wildcards.
However, at the least it seems to work like the 'icontains' operator, but case-sensitively. So, my expectation would be that using the operator 'not_like' it would return all the other rows than with the 'like' operator. But it also returns exactly the same rows. So, I believe this is a bug.
See for yourself. This GET query returns two rows from one of my tables (listing some ebook & video content and such):
It returns two rows, and the url column is the second one, and the results are correct. However, this query returns exactly those two rows, not all the 41 others rows that there are on the table.
Thanks for your patience here. This wasn't a particularly quick fix, but I wanted to follow up and let you know that this issue is now resolved; you should see proper behavior from both the like and not_like filters.