About Queries and Logical Operations  
 
Glossary  Return to Start  Previous  Next

To make it easier to find the articles in large data files, Personal Knowbase allows you to combine keywords using logical, or boolean, operations. You can build these logical expressions using the Build Query Command (Edit Menu). The results of your query appear in the Titles column of the Index Window. By default, query results are updated automatically when you make changes to your data which affect them.  
 
Logical expressions, or queries, are built by using operators to modify descriptive operands. In this case, operators include AND, OR, and NOT. Operands include keywords, a lack of keywords (NOKEYS), being tagged (TAGGED), or having an attachment (ATTACHMENTS). Parentheses can be used to specify the order in which operators are applied to operands. If no parentheses are used in queries with multiple operators, the NOT operator takes first precedence, followed by AND, and finally by OR. There is no limit to the length of a query.  
 
You can also restrict the results of a query by specifying the earliest or latest dates for the article date.  
 
Saving Queries  
 
When you create a query with the Build Query command, you can save it for future use with the current data file by clicking the Save Query button. Once you have saved a query, you can run it using the Run Saved Query Command (Edit Menu) and make changes to it using the Manage Saved Queries Command (Edit Menu).  
 
Examples  
 
For example, let's say that the keyword "meetings" is assigned to all of your meeting notes and the keyword "Wilson project" to everything related to that project. If you were looking for a note that you know was from a meeting which did not involve that project, you could create a query to list all titles associated with "meetings", but not with "Wilson project": meetings AND NOT "Wilson project".  
 
More Examples:  
 
QueryResults  
 
TAGGEDEquivalent to the Show Tagged Titles Command (Article Menu).  
 
NOKEYSShows all articles with no keywords assigned.  
 
ATTACHMENTSEquivalent to the Show Articles with Attachments Command (Article Menu).  
 
June AND JulyShows only articles associated with both June and July. Equivalent to placing these two keywords into the Selected column of the Index Window and setting the Selected Keyword Mode to AND.  
 
June OR JulyShows all articles associated with either June or July. Equivalent to placing these two keywords into the Selected column of the Index Window and setting the Selected Keyword Mode to OR.  
 
Report AND NOT JulyShows articles associated with Report, but not associated with July.  
 
June AND TAGGEDShows only tagged articles which are associated with the keyword June.  
 
June AND NOKEYSHas no results. If an article is associated with the keyword June, it can't have no keywords.  
 
June OR NOKEYSShows articles associated with June and also any articles with no keywords.  
 
June AND ATTACHMENTSShows articles associated with June which also have attachments.  
 
NOKEYS AND NOT TAGGEDShows articles which have no keywords and are not tagged. A good way to fetch articles that you forgot to assign keywords to.  
 
(June OR July) AND ReportShows articles associated with Report and also with either June or July.  
 
June OR (July AND Report)Shows all articles associated with June, and also articles associated with both July and Report.  
 
(June AND Iowa) OR (July AND Ohio)Shows articles which are either associated with June in Iowa, or associated with July in Ohio.  
 
 
For more information, see the Procedure:  
Performing Logical Operations on Keywords