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.

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

Search by two keywords #15

Open
bot4343 opened this issue May 23, 2018 · 1 comment
Open

Search by two keywords #15

bot4343 opened this issue May 23, 2018 · 1 comment

Comments

@bot4343
Copy link

bot4343 commented May 23, 2018

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?

@chrisbro
Copy link
Owner

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants