Oppskrift for federerte søk i OVID - ved hjelp av “use”

Oppskrift mottatt fra Dave Kaunelis i CADTH, Canada:

You can limit a single search line within a search to a specific database or databases by using the Ovid field codes assigned to each database. Ovid database codes can be difficult to find so I have listed the codes for all databases that CADTH subscribes to (see end of this message). For other database, you may need to contact Ovid for the field code.

Removing duplicates:

First, prepare and save your individual database searches separately. Then open all the databases you have searched. This is what Ovid calls a multifile search. Run one of the searches, EMBASE 1980-present, for example.

EMBASE search
Line 1. dogs.ti
Line 2 cats.ti
Line 3. pigs.ti
Line 4. rabbits.ab
Line 5. or/1-4

Line 6. 5 use emez

Line 6 will limit the results of this part of the search to the Embase database only [emez is the 1980-present Embase field code]

Then run another of your individual database searches (Medline 1950-present, for example) with all databases still open.

MEDLINE search
Line 7. dogs.ti,ab
Line 8. cats.hw
Line 9. pigs.mp
Line 10. rabbits.ti,ab,hw
Line 11. or/7-10

Line 12. 11 use mesz

Line 12 will limit the results of this part of the search to the Medline 1950-present database.

Then run any other searches from other databases.

Then OR your results together (Line 6 or Line 12 or …)

Then remove duplicates.


You can also use this feature in other ways. See the example below for limiting specific lines within a multifile search to a specific database by using Ovid database codes.

exp tramadol/ [retrieves items from all databases open]
exp *tramadol/ use emef [retrieves items only from EMBASE]
tramadol.ti,ab,hw use prem,mesz,b10o89 [retrieves items from PreMedline, Medline, Biosis]


Ovid Database Codes
for 2010
(field codes in parentheses)

Biosis
BIOSIS Previews 1985 to 1989 (biol85)
BIOSIS Previews 1989 to present (b10o89) [note: this code changes yearly – the code for 2011 will likely be b11o89]

EBM Reviews
EBM Reviews - ACP Journal Club 1991 to September 2008 (acp)
EBM Reviews - Cochrane Central Register of Controlled Trials current update (cctr)
EBM Reviews - Cochrane Database of Systematic Reviews current update (coch)
EBM Reviews - Database of Abstracts of Reviews of Effects current update (dare)
EBM Reviews - Cochrane Methodology Register current update (clcmr)
EBM Reviews - Health Technology Assessment current update (clhta)
EBM Reviews - NHS Economic Evaluation Database current update (cleed)
The short code for ALL EBM Reviews is ebmz
The short code for EBM Reviews Full Text is ebmy

Embase
EMBASE 1996 to present (emef)
EMBASE 1988 to present (emed)
EMBASE 1980 to present (emez)
EMBASE 1988 to 1995 (emem)
EMBASE 1980 to 1987 (emeb)

ERIC
ERIC 1965 to present (eric)

Medline
Ovid MEDLINE(R) In-Process & Other Non-Indexed Citations and Ovid MEDLINE(R) 1950 to Present (prmz)
Ovid MEDLINE(R) 1950 to present (mesz)
Ovid MEDLINE(R) 1996 to present (medf)
Ovid MEDLINE(R) 1950 to 1995 (medb)
Ovid MEDLINE(R) In-Process & Other Non-Indexed Citations current (prem)
Ovid MEDLINE(R) Daily Update current (mesx)
Ovid MEDLINE(R) 2003 to present (medl)
Ovid MEDLINE(R) 1996 to 2002 (med3)
Ovid MEDLINE(R) 1980 to 1995 (med2)
Ovid MEDLINE(R) 1950 to 1979 (med1)
Ovid OLDMEDLINE(R) 1950 to 1965 (medo)

PsycINFO
PsycINFO 2000 to present (psya)
PsycINFO 1985 to present (psyf)
PsycINFO 1967 to present (psyb)
PsycINFO 1806 to present (psyh)
PsycINFO 1806 to 1966 (psy1)

SØK i CINAHL (Ebsco)

Syns denne fortjente et eget innlegg.

- Fra 1981 –

- Sykepleie + Kvalitativ forskning

- CINAHL Headings

- CINAHL Subheadings

- Wildcard – truncation
? - erstatter en bokstav, midt i eller på slutten av et ord
# - erstatter eller erstatter ikke en bokstav, midt i eller på slutten av et ord
* - legger til ingen, en eller flere bokstaver på slutten av et ord

- Operatorer
AND – OR – NOT
Nn - NEAR - beholder eller snur rekkefølgen på ordene
Wn - WITHIN - beholder rekkefølgen på ordene

- Stoppord overses. Se Ebscos stoppordliste

- ”Exact phrase”, men kun fraser uten stoppord/operatorer, søkes med doble anførselstegn

- Søk på bindestreksord gir treff på ordet med og uten bindestrek

- Søk på entallsform av et ord gir treff på entallsform, flertallsform og genitivform

- Søk på flertallsform av et ord gir kun flertallsformen (+)

- Eksempel på PT - publikasjonstype
Systematic review
Clinical trial
Search strategy

- EM - Entry Date
- Avgrense med EM
EM 2000 gir referansene som kom inn i 2000
EM 200012 gir referansene som kom inn i desember 2000
EM 200012- gir referansene som kom inn fra og med desember 2000 og til søkedato
EM -200012 gir referansene som kom inn før og til og med desember 2000

- Clinical Queries

- Andre filter
RCT

 

 

 

 

 

 

 

CRD (SR)filter brukt for DARE
S1 (MH "Meta Analysis") S2 TI metaanaly* or AB metaanaly* S3 TI meta-analy* or AB meta-analy* S4 AB cochrane or TI cochrane S5 PT nursing interventions S6 PT systematic review S7 TI review* or TI overview* S8 MH "Literature Review+") S9 MH "Literature Searching+") or (MH "Computerized Literature Searching+") S10 TX synthes* N3 literature* or TX synthes* N3 research or TX synthes* N3 studies or TX synthes* N3 data S11 TX medline or medlars or embase or scisearch or psycinfo or psychinfo or psychlit or psyclit S12 TX pooled analy* or TX data N2 pool* S13 TX hand N2 search* or TX manual N2 search* or TX database* N2 search* or TX computer* N2 search*S14 (MH "Reference Databases+") or (MH "Reference Databases, Health+") S15 TX electronic* N2 database* or TX electronic* N2 data base* or TX bibliographic* N2 database* or TX bibliographic* N2 data base* S16 PT review S17 AB systematic* or AB methodologic* or AB quantitative* or AB research* or AB literature* or AB studies or AB trial* or AB effective*S18 S17 and S16 S19 AB systematic* N10 review* or AB methodologic* N10 review* or AB quantitative* N10 review* or AB research* N10 review* or AB literature* N10 review* or AB studies N10 review* or AB trial* N10 review* or AB effective* N10 review*S20 AB systematic* N10 overview* or AB methodologic* N10 overview* or AB quantitative* N10 overview* or AB research* N10 overview* or AB literature* N10 overview* or AB studies N10 overview* or AB trial* N10 overview* or AB effective* N10 overview* S21 S20 or S19 or S18 or S15 or S14 or S13 or S12 or S11 or S10 or S9 or S8 or S7 or S6 or S5 or S4 or S3 or S2 or S1 S22 PT book review S23 S21 not S22 S24 SO cochrane database of systematic reviewsS25 s23 not s24

CRD (Cost)filter brukt for NHSEED
S1 MH "Economics+"
S2 MH "Financial Management+"
S3 MH "Financial Support+"
S4 MH "Financing, Organized+"
S5 MH "Business+"
S6 S2 OR S3 or S4 OR S5
S7 S1 NOT S6
S8 MH "Health Resource Allocation"
S9 MH "Health Resource Utilization"
S10 S8 OR S9
S11 S7 OR S10
S12 TI (cost or costs or economic* or pharmacoeconomic* or price* or pricing*) OR AB (cost or costs or economic* or pharmacoeconomic* or price* or pricing*)
S13 S11 OR S12
S14 PT editorial
S15 PT letter
S16 PT commentary
S17 S14 or S15 or S16
S18 S13 NOT S17
S19 MH "Animal Studies"

- Limits
Exclude MEDLINE referanser
Limit til Inpatients
Limit til Outpatients

- Bruk Clear knappen flittig