Create, update, delete and query searches from your Evernote account.
Table Specific Information
Select all searches:
SELECT * FROM Searches
Retrieve a specific search:
SELECT * FROM Searches WHERE Guid='c916ef68-60a0-4fa4-8ab1-265debe133dc'
To create a search, you will need to specify at least the Name and Query column.
INSERT INTO Searches(Name,Query,IncludeAccount) VALUES ('JAVA','object-oriented language',true)
Searches may be modified by providing the GUID of the search and issuing an UPDATE statement.
UPDATE Searches SET Name='C++', Query='Procedural programming language', IncludePersonalLinkedNotebooks=true WHERE Guid='d7b2be4d-a2ca-448b-82a7-ce8723db95a0'
Searches may be deleted by providing the GUID of the search and issuing a DELETE statement.
DELETE FROM Searches WHERE Guid='d7b2be4d-a2ca-448b-82a7-ce8723db95a0'
The unique identifier of this search. Will be set by the service, so may be omitted by the client when creating.
The name of the saved search to display in the GUI. The account may only contain one search with a given name (case-insensitive compare). Can't begin or end with a space.
A string expressing the search to be performed.
The format of the query string, to determine how to parse and process it.
A number identifying the last transaction to modify the state of this object.
The search should include notes from the account that contains the SavedSearch.
The search should include notes within those shared notebooks that the user has joined that are NOT business notebooks.
The search should include notes within those shared notebooks that the user has joined that are business notebooks in the business that the user is currently a member of.