alfred-bear icon indicating copy to clipboard operation
alfred-bear copied to clipboard

Search by two keywords

Open bot4343 opened this issue 6 years ago • 1 comments

Search results is empty when I'm trying to search by more then two keywords.

For example: 00000896

But when I put these keywords into Bear search bar I can find a note: 000008972

Debug info:

0:12:28 search.py:37 DEBUG    Started search workflow
00:12:28 search.py:60 DEBUG    [u'git revert']
00:12:28 search.py:42 DEBUG    Searching notes for git revert
00:12:28 search.py:98 DEBUG    Searching notes
00:12:28 workflow.py:1748 DEBUG    Data `db_path` stored in `cpickle` format
00:12:28 workflow.py:1763 DEBUG    Stored data loaded from : /Users/mac/Library/Application Support/Alfred 3/Workflow Data/com.chrisbro.bear/db_path.cpickle
00:12:28 queries.py:123 DEBUG    /Users/mac/Library/Containers/net.shinyfrog.bear/Data/Documents/Application Data/database.sqlite
00:12:28 queries.py:127 DEBUG    SELECT DISTINCT   ZUNIQUEIDENTIFIER, ZTITLE FROM    ZSFNOTE WHERE    ZARCHIVED=0    AND ZTRASHED=0    AND lower(ZTITLE) LIKE lower('%git revert%')ORDER BY    ZMODIFICATIONDATE DESC
00:12:28 queries.py:130 DEBUG    Found 0 results

Question: is it possible to improve a search?

bot4343 avatar May 23 '18 21:05 bot4343

Gotta be that there's a line break in there - the SQL is just looking for a space. Which isn't to say it's not a problem, of course - I'd like to replicate Bear's search if possible, as your screenshot shows.

chrisbro avatar May 24 '18 11:05 chrisbro