Practical examples of using Advanced Search
The following searches have been provided by the ME Support team. Each example includes a link to load a instance of the search, which you can modify before saving, eg to use you own CRG, see Saving and loading searches.
How to identify overdue Workflow tasks for a particular person
And create a report that included review titles and IDs.
Advanced Search > Tasks, Match all rows (AND)
Workflow Status | Is | In Progress
Status | Is | In Progress
Assigned To | Is | NAME
Is Overdue | Yes
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1510290335037094808121606172668
Click 'Save'. Save as: name the search > ok. The search appears in the list of Saved Searches*
Click 'Search'
Step 2 - Export the search
- Click 'Select All' in the Results tab.
- Go to Tools and choose 'Export and Labels ...' from the menu list. The Export wizard pops up.
- Select 'Excel' from the pull-down list. Click 'Next'.
- Select the fields to include and then click 'Export'.
How to identify active Authors who do not yet have an Archie account
Advanced Search > People, Match all rows (AND) Is Active | Yes Role in Group |Author| in | YOUR GROUP's NAME | Active Is User | Is | No
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1211202343380640166967646987314
How to identify 'empty' published reviews
I.e. reviews with no included studies.
Advanced Search > Review Versions, Match all rows (AND) Versions published between | Issue 1, 2015 | and issue 1, 2015 Group | Is | NAME OF GROUP Stage | Is | Full Review Number of… | Included Studies | Equals | 0
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1510290342298852441851056952439
How to identify Authors from LMIC countries
(This requires a grouping and selection of three country income level options)
Advanced Search > People, Match all rows (AND) Role in Group | Author |YOUR GROUP's NAME Group with OR Country Income Level | Is | Low Income Country Income Level | Is | Low-Middle Income Country Income Level | Is | Upper-Middle Income Group End
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1510290346420018595948766031089+
How to identify contributors who requested monthly Group updates
Advanced Search > People, Match all rows (AND) Role in Group | any role | YOUR GROUP's NAME Note text | Contains | You need to have created a note system to identify people who have requested monthly information emails, e.g. mailing list
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1511170129316753119490784823312
How to identify Workflow tasks overdue by more than 7 days
Advanced Search > Tasks, Match all rows (AND) Workflow Status| Is | In Progress Group | Is | YOUR GROUP's NAME Is Overdue | Yes Days Left | Less than or equals | -7
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1409080443197727010447694410229
How to identify new and updated published reviews & protocols during a particular time span
For example reviews and protocols published in 2014. After generating the list you can export this as an Excel file - useful for reporting to funders.
Advanced Search > Review Versions search, Match all rows (AND)
Versions First Published between | Issue 1, 2014 | Issue 12, 2014
Group | Is | YOUR GROUP's NAME
New or Updated | Yes
Amended | No
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1503170408548052061379926515616
How to identify published reviews with at least one SoF table
Advanced Search > Review Versions search, Match all rows (AND)
Versions published between | Issue 1, 2015 | and | Issue 1, 2015
Group | Is | YOUR GROUP's NAME
Number of… | Summary of Findings Tables | Greater than or equals | 1
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1503170411021777018192831477356
How to identify Workflow workload tasks for a particular person which will be due by the end of April 2015
Advanced Search > Tasks, Match all rows (AND)
Workflow Status| Is | In Progress
Assigned To | Is | NAME
Status | Is | In Progress
End or Due | Not before | 30/04/15
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1502250258597291469812892120320
How to identify Japanese translators
The total of selected results should identify all Japanese translators
Advanced Search > People, Match all rows (AND) Role in Group | Translator | in |Any group | Active
Role Specification | Contains | Japanese
Select All
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1510290353071753699483275705606
Advanced Search > People, Match all rows (AND) Role in Group | Translator | in |Any group | Active
Note Title | Contains | Japanese
Select All
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1510290355337902928483642983860
Advanced Search > People, Match all rows (AND) Role in Group | Translator | in |Any group | Active
Note Text | Contains | Japanese
Select All
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1510290359094386288173725385089
How to identify which reviews are in the Editorial Phase
Useful to see what's in the pipeline.
Advanced Search > Documents, Match all rows (AND) Group | Is | YOUR GROUP's NAME Review Phase | Is | Editorial
Review Status | Is | Active Document Type | Is | Review Document Review Stage | Is not | Vacant Title
Click 'Search'
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1503170417206827260224081615182
Pending Review Updates to start by particular date
Advanced Search > Tasks search, Match all rows (AND) Workflow Status | Is | Pending Workflow Type | Is | Review Update Task Name | Is | Agree with Contact Person on search date Group | Is | YOUR GROUP'S NAME End or Due | Before | Add date, e.g. end of the month
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1503152247509839304716960838751
How to identify all reviews and protocols published during a particular time span
e.g. reviews and protocols published in 2014 (After generating the list you can export this as an Excel file - useful for reporting to funders).
Documents search, Match all rows (AND) Group | Is | YOUR GROUP's NAME Date Published | Before | Add date Date Published | After | Add date Click 'Search'
To load the search, click the link below:
https://archie.cochrane.org/search.jsp?savedSearchPK=z1503170420345688844796962145701
Original examples (2013)
- How to identify a list of all the new protocols or reviews that your Group published between Issues 1 and 12, 2011.
- In Advanced Search select Review Versions.
- Versions First Published between + Issue 1, 2011 and Issue 12, 2011.
- Group + is + Your Group.
- New + Yes.
- Click Search.
- How to find reviews with a particular event that have been published between Issues 1, 2011 and Issue 12, 2011?
- In Advanced Search select Review Versions.
- Versions Published between + Issue 1, 2011 + Issue 12, 2011.
- Group + Is + Group.
- Concl. Changed/ Major Change + Yes.
- Click Search.
- How to identify all new review versions published in 2012?
- In Advanced Search select Review Versions.
- Versions First Published between + Issue 1, 2012 + Issue 12, 2012.
- Group + Is + Group.
- Stage + Is + Full Review.
- New or Updated + Is + Yes.
- Click Search.
- How to determine the workload of individuals involved in the editorial processing of reviews
- In Advanced Search select Tasks.
- Workflow Status + Is + In Progress.
- Assigned To + Is + Name of the person.
- Status + Is + In Progress.
- End or Due + Before + Date.
- Click Search.
- How to identify a person's current tasks?
- In Advanced Search select Tasks.
- Group + Is + Group.
- Assigned to + Is + Name of Person.
- Status + Is + In Progress.
- Workflow Status + Is + In Progress.
- Click Search.
- How to identify specific tasks?
- In Advanced Search select Tasks
- Group + Is + Group.
- Assigned to + Is + Name of Person.
- Status + Is + In Progress.
- Workflow + Is + In Progress.
- Task Name +Is + Name of the task.
- How to find workflows of a particular Group which follow specific workflow templates (1.3 and 1.4)?
- In Advanced Search select Workflows.
- Group + Is + Group.
- Group with OR.
- Workflow version + Is + 1.3.
- Workflow version + Is + 1.4.
- Group End.
- Click Search.
- How to identify tasks in workflows based on specific template versions (1.3. and 1.4 )?
- Select identified Workflows in the Example 7 and go to the Advanced Search.
- Select Tasks.
- Tasks for Selected Workflows.
- Status + Is + In Progress.
- Assigned To + Is + Name of Person.
- Click Search.
- How to identify all Protocols that have been submitted for editorial approval and are awaiting action by someone at your editorial base or other CRG Advisors:
- In Advanced Search select Workflows.
- Status + Is + In Progress.
- Last Milestone Reached + Is + A – Draft Protocol submitted for editorial approval.
- Group + Is + Group.
See also Selection, Combining results from multiple searches.