Advanced Searching Techniques
Help Tools:  | small font | medium font | large font | Print this topic | Return to searching  
 
OvidSP's Advanced Search Techniques
Command Line Syntax
Truncation and Wild Cards
Boolean Operators
Postqualification of Results Sets

OvidSP's Advanced Search Techniques

OvidSP's advanced searching techniques let you enter special commands instead of having to type or retype long statements to gain the results you want. These searching shortcuts let you bypass longer means of entering a search. Experiment with the following techniques and learn to facilitate the ease with which you search and further enhance the focus of your results.
Use the advanced searching techniques from the Advanced Ovid Search tab.

Command Line Syntax

Command line syntax lets you enter shortcut commands into the command line, bypassing the use of the icon bar.

<term>.xy. Runs a search for the word or phrase (term) through the field indicated by the two-letter short code (xy). For example, the command line syntax: heart.ab. runs a search for the term heart through the abstract (ab) field of the database. For a complete list of fields and short codes for any database, refer to the database field guide.
<term>.xy,yz. Runs a search for the word or phrase (term) through the fields indicated by the two-letter short code (xy,yz). For example, the command line syntax: heart.ab,ti. runs a search for the term heart through the abstract (ab) and title (ti) fields of the database. For a complete list of fields and short codes for any database, refer to the database field guide.
..c/<dbshortcode>
or
use <dbshortcode>
Switches your current search session from one database to another (the one indicated by the database short code in the command). For example, the command line syntax: ..c/psyc reopens your current session in the PsycINFO database. Also, the command line syntax: use psyc reopens your current session in the PsycINFO database.

To find the short code of any database, refer to the database field guide.

If you want to use the word use as part of your search term, you must enclose the entire term in quotation marks. For example, to search for the term tobacco use, you must type: "tobacco use". Otherwise, OvidSP displays a syntax error message.
..l/<n> yr=x Limits the results of set number (n) to a specific publication year or range of publication years. For example, the command line syntax: ..l/5 yr=2004 restricts the results in set five to only those results from 2004. To restrict results to a range of publication years, separate the years you want to cover (inclusively) with a hyphen, as in the command line syntax: ..l/5 yr=2000-2004 which restricts results from set five to the range of publication years from 2000 to 2004.
limit n to <dblimit> Limits the results of set number (n) to the database-specific limit indicated. For example, the command line syntax: limit 5 to latest update restricts results from set five to only those results from the most recent update of the database. For a list of database-specific, command-line limits, refer to the database field guide.
<term>/ In databases with a controlled vocabulary this command searches a known subject heading directly, bypassing mapping. For example, eye/ retrieves records with the known subject heading eye without taking you to the Mapping Display Page. Results appear immediately in your search history.
<subject heading>/<subheading two-letter code> In databases with a controlled vocabulary this command limits a subject heading search to records that include a known subheading. For example, cartilage/su limits the subject heading search for cartilage to records that include the known subheading surgery.
To apply multiple subheadings, separate the two-letter subheading qualifier with a comma. For example, the command cartilage/su,tr limits the subject heading search for cartilage to records that include the known subheadings surgery and transplantation.
..map <term> or
map <term>
Maps your term to a list of related terms (called subject headings) on the Mapping Display Page. For example, the command line syntax: map cartilage automatically opens the Mapping Display Page to a list of subject headings for the term cartilage. Subject headings are derived from the controlled vocabulary of the database. They can help you broaden your search by suggesting other terms to consider.
exp <term> In databases with a controlled vocabulary this command explodes the term entered onto the command line. For example, ..exp neoplasms retrieves records that contain the term neoplasms and any of its narrower, more specific terms.
*<term> In databases with a controlled vocabulary this command focuses the term entered on the command line. For example, *neoplasms retrieves records in which neoplasms is the main topic.
..root <term>.xy. or
root <term>.xy.

..root x.yy,zz. or
root x.yy,zz.

Roots into the field index (xy) and displays at the position within that index of the term indicated. For example, the command line syntax: ..root cartilage.ab. roots into the Abstract Field Index and displays at the point of the term cartilage.

To root into the combined index of more than one field, use the command line syntax: ..root cartilage.ab,ti. which roots into the combined Abstract and Title Fields Index and displays at the point of the term cartilage

.
If you want to use the word root as part of your search term, you must enclose the entire term in quotation marks. For example, to search for the term root caries, you must type: "root caries". Otherwise, OvidSP roots into the database Fields Index Display at the point of the term root caries.
scope <subject heading> In databases that feature OvidSP's Scope Note Tool, this command opens the Scope Note Display of the term indicated. For example, scope cartilage opens the Scope Note Display for the term cartilage. In this display, you can read database-specific information about the term, such as subject headings, scope, special notes, date of entry, used-for terms, and so on.
If you want to use the word scope as part of your search term, you must enclose the entire term in quotation marks. For example, to search for the term scope of nursing practice, you must type: "scope of nursing practice". Otherwise, OvidSP opens the scope note display of the term nursing practice.
ptx <subject heading> In databases that feature OvidSP's Permuted Index Tool, this command opens the Permuted Index Display for the subject heading indicated. For example, ptx <asthma> opens a Permuted Index Display for the term asthma.
tree <subject heading> In databases that feature OvidSP's Tree Tool, this command opens the Tree Display for the subject heading indicated. Use the keyword command line syntax tree <subject heading> to open a Tree Display for a known subject heading. For example, the command tree asthma opens the database tree at the point of the subject heading asthma.
thes <subject heading> In databases that feature OvidSP's Thesaurus Tool, this command opens the Thesaurus Display for the subject heading indicated. Use the keyword command line syntax thes <term> to open a Thesaurus Display for a known subject heading. For example, the command thes work ethic opens the database thesaurus at the point of the subject heading work ethic.
sh <subject heading> In databases that include subheadings as part of a controlled vocabulary, this command opens the Subheading Display for the subject heading indicated. For example, the command sh coma opens the Subheadings Display for the term coma.
<classification code>.cc In databases that feature a Classification Codes Tool, this command retrieves records associated with the term indicated by the code entered. For example in the AGRICOLA database, j700 is the classification code for the term soil cultivation. The command j700.cc retrieves all records associated with the term soil cultivation.
..e <savedsearchname> Executes the temporary or permanent saved search strategy indicated by the search name in the command. For example, the command line syntax: ..e melatonin executes the saved search melatonin directly from the command line.
..o Ends your search session, frees up an OvidSP user license, and returns to the Welcome to OvidSP Page.
..pg n Deletes the indicated results set (n) from your current search history.�For example, the command line syntax: ..pg 5 deletes results set 5 from your current search history.

Delete multiple results sets from your current search history by using hyphens and commas, as in the command line syntax: ..pg 5-8 (which deletes results sets five through eight) or ..pg 2,3,5 (which deletes results sets two, three, and five).

Clear all results sets from your current search history by using the command line syntax: ..pg all.

Do not try to recover deleted search sets by using your web browser's Back button! Doing so yields unpredictable results.
..ps Opens a display of your current search history from which you can use your web browser's print function to attain a hard copy.
..sv <searchname> Saves your current search history temporarily (for 24 hours) under the name indicated. For example, the command line syntax: ..sv melatonin saves your current search history for 24 hours under the name melatonin. At any point within the next 24 hours, you can access this saved search for further development.
..sv ps(searchname) Saves your current search history permanently under the name indicated. For example, the command line syntax: ..sv ps (melatonin) saves your current search history permanently under the name melatonin. At any point, you can access this saved search for further development.
To save a search history permanently from the command line, you must enclose the search name in parentheses. Otherwise, OvidSP only saves the search temporarily.
If the ..sv command is used to save a search with a name that is already in use for a search, it will overwrite the first search without warning.
..dedup n Removes duplicate records from multifile search results. For example, ..dedup 5 removes duplicate records from the multifile results set numbered 5.

When using OvidSP commands, be sure to place periods, commas, and forward-slash characters correctly.

Truncation and Wild Cards

Truncation and wild cards let you utilize root words to find variations of terms that might be valuable to your overall search. Use the following techniques to find variations of terms that you might not have considered.
In OvidSP, database mapping must be turned off for truncation and wild cards to operate properly. If you do not turn off mapping, OvidSP attempts to map truncated terms to subject headings, and must issue an error message.
<rootword$>
or
<rootword:>
Unlimited truncation retrieves all possible suffix variations of the root word indicated. To apply unlimited truncation to a term, type the root word or phrase followed by either of the truncation characters: $ (dollar sign) or : (colon). For example, in the truncated search disease$, OvidSP retrieves the word disease as well as the words diseases, diseased, and more.

Use unlimited truncation with care; you can retrieve results with unrelated words. For example, when we enter the truncated search rat$ to retrieve comprehensive results about the animal, OvidSP does retrieve results with the words rat and rats. But it also retrieves results with the words rate, rationalize, ratify, and so forth that have nothing to do with our intended term.

<rootword$n> Limited truncation specifies a maximum number of characters that may follow the root word or phrase. For example, the truncated search dog$1 retrieves results with the words dog and dogs; but it does not retrieve results with the word dogma.
<rootword#> The mandated wild card character # (pound sign) is useful for retrieving specialized plural forms of a word. For example, the search wom#n retrieves results that contain both woman and women. You may use multiple wild cards in a single query word.

The mandated wild card requires that a character be present. Therefore, you could use it at the end of a term to limit results to only those that contain the word plus the one, mandated character. For example, the search dog# retrieves results that contain the word dogs, but not those that contain the word dog effectively limiting results to only those that contain the plural form of the word.

You cannot use the mandated wild card if there is only one letter in front of the position where you want to place it. Therefore, searching d#g results in an error message.
<rootword?> The optional wild card character ? (question mark) can be used within or at the end of a search term to substitute for one or no characters. This wild card is useful for retrieving documents with British and American word variants since it specifies that you want retrieval whether or not the extra character is present. For example, the optional wild card search colo?r retrieves results that contain the words color or colour. You can use multiple wild cards in a single query word.
You cannot use the optional wild card if there is only one letter in front of the position where you want to place it. For example, the optional wild card search f?etal results in an error message.

Boolean Operators

Boolean operators are reserved words that OvidSP interprets as commands when you enter them in combination with a query or results set numbers onto the Main Search Page keyword command line. Use these operators to define a search:

OR NOT FREQ AND ADJn

OvidSP applies command operators to a query and searches through the default fields of the database(s). For example, with the following Boolean search query, OvidSP looks for the terms cats and dogs in the default fields of the database(s) being searched.

cats <operator> dogs.ti

In CINAHL, OvidSP runs this search through these default fields.

In PsycINFO, OvidSP runs this search through these default fields.

Default fields for unqualified searches differ from database to database. Check the field guide(s) of the database(s) in which you are searching to see the database's definitive list of default fields for unqualified searches.

Or, you can qualify (field) a Boolean search statement, and OvidSP searches through the field(s) to which you have qualified the search. In the following example, we enter a search for the terms cats and dogs through the title (TI) field of the database(s) in which you are searching.

cats <operator> dogs.ti

Finally, applying Boolean operators with results sets numbers lets you create sets of records that you desire most.

OvidSP processes query and set operators from left to right. To specify precedence, enclose search terms and operators in parentheses within your search statement. OvidSP processes the most deeply nested parenthetical statement first.

For best results, try these Boolean operators.

OR Operator

      

The OR operator lets you retrieve records that contain any of your search terms. For example, the search heart attack or myocardial infarction retrieves records that contain heart attack, myocardial infarction or both terms. Results are all inclusive.

Combine terms using the OR operator in a qualified (fielded) search to retrieve records in which either of the terms appear in the field indicated. For example, the search (pregnancy or birth).ti. retrieves results in which either pregnancy or birth or both terms appear in the titles of the records.

Use the OR operator to combine results sets into a single set inclusive of all records from the results sets indicated. For example, the search 1 or 2 or 3 combines results from the first, second, and third sets into a single set.

AND Operator

The AND operator lets you retrieve only those records that include all of your search terms. For example, the search blood pressure and stroke retrieves only those records that contain both terms blood pressure and stroke together in the same record. Results exclude records that do not contain both terms.

Combine terms using the AND operator in a qualified (or fielded) search to retrieve records in which the terms are found in the field indicated. For example, the search (pregnancy and birth).ab. retrieves results in which both pregnancy and birth appear in the abstracts of the records.

Use the AND operator to combine two or more results sets into a single set that contains only those records that the original sets had in common. For example, the search 1 and 2 and 3 creates a set of only those records that sets one, two, and three have in common.

NOT Operator

The NOT operator lets you retrieve records that contain your first term but exclude the second term. In this way, you can restrict the scope of your results. For example, the search health reform not health maintenance organizations retrieves only those records that contain the term health reform but exclude the term health maintenance organizations.

You can also use the NOT operator to cull records from a fielded search. For example, the search (education not patient education).ti. retrieves records for which the title contains only the term education and not the term patient education.

When you use the NOT operator to combine two results sets, OvidSP removes from the first indicated results set any records that contain the term(s) indicated in the search that yielded the second results set. For example, results set 1 contains records from a search for cats. Results set 2 contains records from a search for dogs. The search 1 not 2 eliminates records from results set 1 that have any mention of dogs.

You must use parentheses to execute this last search example. Without parentheses, this search may yield results you do not want or had not intended. OvidSP may interpret this search

education not patient education.ti

as either of the following.

education.mp not patient education.ti

Searches for the term education in the default (MP) fields of the database that do not have the term patient education in the Title (TI) field.

education not patient education.mp

Searches for education not patient education in the default (MP) fields of the database.

When you use the NOT operator between the numbers of two results sets, OvidSP removes records from the first set that contain the term(s) that yielded the records of the second set. For example, if OvidSP compiled your first results set from a search for cats and your second set from a search for dogs, you can run the search 1 not 2 to create a new set that eliminates records with any mention of dogs from the records of the first set.
Use the NOT set and query operator carefully or you might eliminate relevant articles. For example, in the search health reform not health maintenance organizations records containing information about health maintenance organizations have been eliminated; but also, you may have eliminated records that discuss both health reform and health maintenance organizations.

ADJn Operator

ADJn is a positional operator that lets you retrieve records that contain your terms (in any order) within a specified number (n) of words of each other. To apply adjacency, separate your search terms with the ADJ operator and a number from 1 to 99.
The ADJ and ADJ1 operators perform the same function in a search statement: finding two terms next to each other in either order. The ADJ2 operator finds terms in any order and with one word (or none) between them. The ADJ3 operator finds terms in any order with two words (or fewer) between them. The ADJ4 operator finds terms in any order and with three words (or fewer) between them, and so on.

When applying adjacency between terms, it is helpful to know if the database in which you are searching has stop words (a list of words that OvidSP will ignore when searching for your terms). If it does, OvidSP does not count those stop words as part of the number of words that can appear between the desired terms. For example, the search physician adj5 patient would not count stop words such as a, the, or is in finding the desired result.

If the database does not use stop words, OvidSP counts those words as part of the number that can appear between the desired terms. The inclusion of stop words in an adjacency threshold can reduce the number of records retrieved. In this case, you can gain best results by increasing the adjacency threshold by two or three to account for stop words.

For databases that do use stop words, database field guides provides a complete list.

For example, the search physician adj5 relationship retrieves records that contain the words physician and relationship within five words of each other in either direction. This particular search retrieves records containing such phrases as physician patient relationship, patient physician relationship, relationship of the physician to the patient, and so on.

You can combine this positional operator with a fielded search. For example, the search (information adj3 retrieval).tw. retrieves records from the Text Word (TW) field that contain any phrases in which the terms information and retrieval are within 3 words of each other.

When using the ADJn operator as part of a fielded search, it is best to combine it with word-indexed fields. To learn what fields are word-indexed, refer to the field guide of the database in which you are searching.
Add a frequency requirement to the positional operator within a fielded search. For example, (information adj3 retrieval).tw./freq=5 retrieves records from the Text Word (TW) field that contain any phrases in which the terms information and retrieval are within 3 words of each other and occur at least five times in the record.
Use the ADJn operator when you are not sure of the exactly phraseology used in the literature. In general, requiring two or more query terms to be near each other usually retrieves records in which your search terms are closely related, yielding more relevant results.
Word order only matters when the ADJ operator is applied without a variable. When you separate terms with a space on the command line, OvidSP presumes them to be adjacent to one another in the order specified at the command line. Nor do you need to separate search terms manually by inserting ADJ between them. For example, the search blood pressure yields the same results as the search blood adj pressure. In either case, OvidSP retrieves records containing the terms in the order specified at the command line

FREQ Operator

Using the frequency operator (FREQ) lets you specify a term's threshold of occurrence in the records retrieved. Records containing the term are retrieved only if that term occurs at least the number of times specified in your search statement. In general, records that contain many instances of your search term are more relevant to your search than records that contain fewer instances. The frequency operator is particularly useful when searching a database’s full text field for a common word or phrase.

Syntax that applies a frequency operator requires that you qualify your term to a field, then apply the frequency you want, as in: <term>.xy./freq=n. In this syntax, xy is the two-letter field code and n represents the minimum number of times that you want your term to appear in records retrieved. Do not use spaces in this search statement. For example, the search blood pressure.tx./freq=10 retrieves only records in which the phrase blood pressure appears ten or more times in the Full Text (TX) field of the database.

The frequency operator cannot be used with multiple fields or with fields that consist of a combination of other fields (such as the Source SO field.) The following searches result in error messages.

science.ti,ab./freq=3
Too many fields specified.

blood.so./freq=5
The Source (SO) field consists of multiple fields.

Postqualification of Results Sets

Postqualification is a shorthand command language for quick changes to existing results sets. OvidSP translates the shorthand commands, re-executes the previous search statement, and posts a new results set. Use postqualification to save time by not having to retype long or complex search statements that already exist in your search history.

Postqualifying Index Searches

When results post from a search through specific index(es), you can use postqualification to change the field(s) from which the search term was retrieved.
YOU TYPE SEARCH HISTORY DISPLAYS OVIDSP's INTERPRETATION OF THE SEARCH STATEMENT
liver.ti,ab. 1. liver.ti,ab. OvidSP runs a search for the term liver only through the Title (TI) and Abstract (AB) fields of the database.
1.ti. 2. liver.ti. OvidSP uses the term from the first set (liver) and runs a search for it through only the Title (TI) field.
(liver or lung).ti,ab. 3. (liver or lung).ti,ab. OvidSP runs a search through the Title (TI) and Abstract (AB) fields of the database and combines into a single results set only those records that include either or both of the terms liver and lung.
3.ti. 4. (liver or lung).ti. OvidSP uses the terms from the third set (liver and lung) and runs a search for them through only the Title (TI) field.

Adjacency In Postqualification Statements

When two or more results sets have posted to your search history, you can use postqualification to specify adjacency between the search terms of separate sets.
YOU TYPE SEARCH HISTORY DISPLAYS OVIDSP's INTERPRETATION OF THE SEARCH STATEMENT
heart.ti. 1. heart.ti OvidSP runs a search for the term heart through the Title (TI) field of the database and posts results.
attack.ti. 2. attack.ti. OvidSP runs a search for the term attack through the Title (TI) field of the database.
1 adj5 2 3. heart adj5 attack.ti. OvidSP runs a search through the Title (TI) field and retrieves only those records that contain the terms heart and attack within five words of one another.

Postqualifying Search Statements that Contain Operators

When two or more results sets have posted to your search history, you can combine multiple sets using Boolean operators then use postqualification on the resulting set to rerun the bollean search through a different field(s).
YOU TYPE SEARCH HISTORY DISPLAYS OVIDSP's INTERPRETATION OF THE SEARCH STATEMENT
dogs.ab. 1. dogs.ab. OvidSP runs a search for the term dogs through the Abstract (AB) field of the database.
cats.ab. 2. cats.ab. OvidSP runs a search for the term cats through the Abstract (AB) field of the database.
1 or 2 3. 1 or 2 OvidSP runs a search through the Abstract (AB) field and retrieves only those records that include either or both of the terms dogs and cats.
3.ti. 4. (dogs or cats).ti. OvidSP runs a search through the Title (TI) field and retrieves only those records that include either or both of the terms dogs and cats.

Searching Numerically Indexed Fields

When searching numerically indexed fields [such as Pagination (PG), Volume (VO), and Issue/Part (IP)] from the command line, you must enclose your numerical term in quotation marks. Otherwise, OvidSP interprets the search as a request for postqualification of an existing search set.
YOU TYPE SEARCH HISTORY DISPLAYS OVIDSP's INTERPRETATION OF THE SEARCH STATEMENT
jama.so. 1. jama.so. OvidSP runs a search for the term jama (a journal code for The Journal of the American Medical Association) through the Source (SO) fields of the database.

In many OvidSP databases, the Source field consists of several fields that can identify the publication from which the record originated. These fields include such information as: journal name, publisher, issue/part, page on which a publication appears, volume and issue of a publication, year of publication, and so on.

1.pg. 2. jama.pg. OvidSP interprets this search as a request for postqualification. It uses the term from the first set (jama) and runs a search for it through the Page (PG) field. The PG field is numerically indexed; and, as such, the search through it for a non-numerical term like jama yields no records.
"1".pg. 3. "1".pg. OvidSP runs a search for the number 1 through the Page (PG) field of the database, retrieving records of articles that begin on the first page of the source publication.
Another scenario exists when you will need to enclose your numeric search term in quotation marks: if the number you have indicated already exists as a results set. For example, with the search statement 1994.yr., you want OvidSP to run a search for the number 1994 through the Year (YR) field. However, if a results set numbered 1994 happens to exist, OvidSP postqualifies the search terms from results set 1994 to the Year (YR) field.

Subheading Postqualification

When a results set in your search history derives from a subject heading, you can use postqualification to run the subject heading through a subheading field(s). To do so, you must use this syntax format: <n>/<xy> in which n is the number of the existing results set that you want to postqualify and xy is the two-letter code of the subheading field through which you want to search for the subject heading.
YOU TYPE SEARCH HISTORY DISPLAYS OVIDSP's INTERPRETATION OF THE SEARCH STATEMENT
myocardial infarction/ 1. myocardial infarction/ OvidSP recognizes the term myocardial infarction as a subject heading from your search statement and runs a keyword search for it.
1/et,dt 2. 1/et,dt OvidSP runs a search for the term in set 1 (the subject heading myocardial infarction) through the Etiology (ET) and Drug Therapy (DT) subheading fields of the database.

Was this Help context useful? Please let us know by clicking here. Thank you.