Jump to content
Due to limited holiday staffing, chat will be unavailable from Thursday, July 2 at 5:30 PM (CDT) to Monday, July 13 at 8 AM (CDT). This will allow us to reply to your email requests as quickly as possible. Thank you for understanding. ×
河马啊

How to advanced search with AND/OR logic at the same time?

Recommended Posts

Basically, I want search for notebook:"Cabinet" -tag:Trash* and ( (tag:Diary and tag:Fiction and -tag:Unfinished) or (tag:Notes and tag:Books) )

and save it as a saved search for everyday use. However, the last version of Evernote that BitQwik is compatible with is only 4.6.4.8136 or earlier.

So any possible maybe that I can do this kind of search in Evernote Windows v6.x?

Any user-made script or third-party-made tool outside evernote is also acceptable as long as helpful. Thanks.

  • Like 1

Share this post


Link to post
50 minutes ago, 河马啊 said:

Basically, I want search for notebook:"Cabinet" -tag:Trash* and ( (tag:Diary and tag:Fiction and -tag:Unfinished) or (tag:Notes and tag:Books) )

Evernote has never supported this type of search (combined Boolean And/Or search)

I have a work-around scripted on my Mac, but it’s a manual process on my iPad.  
My work-around is to do seperate searches, assigning tag:temp  
The amalgamated results is a simple search on tag:temp

  • Like 3

Share this post


Link to post

Just to amplify DTLow's answer, which is correct, you can do an AND search (which is the default) or you can do a OR search by putting the term "any:" at the start of your search (unless there's a "notebook:". term, in which case, the "any:" comes immediately after the "notebook:" term). In some constrained cases, you can simulate mixed AND/OR searches by using wildcarded search terms (for text search and tag names, mainly) or by using a "stack:" term, which does an OR selection on the set of notebooks in the named stack. But there are no general purpose AND/OR search facilities in Evernote.

Further reading: the Evernote Search Grammar

  • Like 1
  • Thanks 1

Share this post


Link to post

In Windows you could maybe use PhraseExpress to streamline the process - it will execute and pause for user input and execute again...

This webinar from a forum contributor may help explain what's possible,  though it's about Workflowy rather than searching Evernote...

  • Like 1

Share this post


Link to post
52 minutes ago, 河马啊 said:

Basically, I want search for notebook:"Cabinet" -tag:Trash* and ( (tag:Diary and tag:Fiction and -tag:Unfinished) or (tag:Notes and tag:Books) )

and save it as a saved search for everyday use. However, the last version of Evernote that BitQwik is compatible with is 4.6.4.8136 or earlier.

So any possible maybe that I can do this kind of search in Evernote Windows v6.x? A separate tool is acceptable. Thanks.

As others have explained, this isn't currently possible. Please upvote here if you would like to see full boolean search implemented: 

 

  • Like 3

Share this post


Link to post
34 分鐘前, DTLow說:

Evernote has never supported this type of search (combined Boolean And/Or search)

I have a work-around scripted on my Mac, but it’s a manual process on my iPad.  
My work-around is to do seperate searches, assigning tag:temp  
The amalgamated results is a simple search on tag:temp

I'm doing almost the same thing as you, split it into two seperate searches which evernote already support.

However, is there any external/seperate tool to achieve this demand more ideally?

I can use navicat to open the local .exb database file directly, which is just a SQLite database, all notes can be queried by building SQL SELECT statemen, which is read-only operation and safe enough. Is there any tools available that try to query the database directly to support the advanced search with AND/OR of evernote? I think it's useful.

Share this post


Link to post
3 hours ago, 河马啊 said:

I can use navicat to open the local .exb database file directly, which is just a SQLite database, all notes can be queried by building SQL SELECT statemen, which is read-only operation and safe enough. Is there any tools available that try to query the database directly to support the advanced search with AND/OR of evernote? I think it's useful.

I’m also accessing the database directly on my Mac.  I can work with the metadata, but I haven’t been able to return the list of notes to Evernote

Share this post


Link to post
9 hours ago, tavor said:

As others have explained, this isn't currently possible. Please upvote here if you would like to see full boolean search implemented: 

Unfortunately, you can't upvote in this forum. I suggest you do a search to find a post that discusses this where you can upvote it, and put a hyperlink in your post. It's been requested for years!

Share this post


Link to post
13 minutes ago, FactMan said:

Unfortunately, you can't upvote in this forum. I suggest you do a search to find a post that discusses this where you can upvote it, and put a hyperlink in your post. It's been requested for years!

 

  • Like 1

Share this post


Link to post

How do i search exact phrases?  i am trying to find all notes with the date 2014 in them and it seems to be returning anything with 201.

I tried using "2014" to no avail... please advise

Share this post


Link to post
On 27/08/2017 at 3:31 PM, Dychemj said:

How do i search exact phrases?  i am trying to find all notes with the date 2014 in them and it seems to be returning anything with 201.

I tried using "2014" to no avail... please advise

Hi.  How are your dates expressed in your notes?  is 2014 a string on its own?  Do you date as 1/1/2017,  or 1-1-2017?  Both of those work for me...

Characters are only found by search grammar if they are at the start of a string - except that 'punctuation' like "/" is read as a space - so the '2017' above is effectvely a stand-alone string.

 

Share this post


Link to post
On 8/27/2017 at 9:31 AM, Dychemj said:

How do i search exact phrases?  i am trying to find all notes with the date 2014 in them and it seems to be returning anything with 201.

I tried using "2014" to no avail... please advise

Are you saying a search for 2014 returns notes that contain 201. ?  

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...