Page tree
Skip to end of metadata
Go to start of metadata

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 

  1. Click 'Select All' in the Results tab. 
  2. Go to Tools and choose 'Export and Labels ...' from the menu list. The Export wizard pops up. 
  3. Select 'Excel' from the pull-down list. Click 'Next'.
  4. 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)

  1. How to identify a list of all the new protocols or reviews that your Group published between Issues 1 and 12, 2011. 
    1. In Advanced Search select Review Versions.
    2. Versions First Published between + Issue 1, 2011 and Issue 12, 2011.
    3. Group + is + Your Group.
    4. New + Yes.
    5. Click Search.
  2. How to find reviews with a particular event that have been published between Issues 1, 2011 and Issue 12, 2011?
    1. In  Advanced Search select Review Versions.
    2. Versions Published between + Issue 1, 2011 + Issue 12, 2011.
    3. Group + Is + Group.
    4. Concl. Changed/ Major Change + Yes.
    5. Click Search.
  3. How to identify all new review versions published  in 2012?
    1. In Advanced Search select Review Versions.
    2. Versions First Published between +  Issue 1, 2012 + Issue 12, 2012.
    3. Group + Is +  Group.
    4. Stage + Is +  Full Review.
    5. New or Updated + Is + Yes.
    6. Click Search.
  4. How to determine the workload of individuals involved in the editorial processing of reviews
    1.  In  Advanced Search select Tasks.
    2.  Workflow Status + Is + In Progress.
    3.  Assigned To + Is + Name of the person.
    4.  Status + Is + In Progress.
    5.  End or Due + Before + Date.
    6. Click Search.
  5. How to identify a person's current tasks?
    1. In  Advanced Search select Tasks.
    2. Group + Is + Group.
    3. Assigned to + Is + Name of Person.
    4. Status + Is + In Progress.
    5. Workflow  Status + Is + In Progress.
    6. Click Search.
  6. How to identify specific tasks?
    1. In  Advanced Search select Tasks
    2. Group + Is + Group.
    3. Assigned to + Is + Name of Person.
    4. Status + Is + In Progress.
    5. Workflow + Is + In Progress.
    6. Task Name +Is + Name of the task.
  7. How to find workflows of a particular Group which follow specific workflow templates (1.3 and 1.4)?
    1. In  Advanced Search select Workflows.
    2. Group + Is + Group.
    3. Group with OR.
    4. Workflow version + Is + 1.3.
    5. Workflow version + Is + 1.4.
    6. Group End.
    7. Click Search.
  8. How to identify tasks in workflows based on specific template versions (1.3. and 1.4 )?
    1. Select identified Workflows in the Example 7 and go to the  Advanced Search.
    2. Select Tasks.
    3. Tasks for Selected Workflows.
    4. Status + Is + In Progress.
    5. Assigned To + Is + Name of Person.
    6. Click Search.
  9. 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:
    1. In Advanced Search select Workflows.
    2. Status +  Is + In Progress.
    3. Last Milestone Reached + Is +  A – Draft Protocol submitted for editorial approval.
    4. Group +  Is +  Group.

See also Selection,  Combining results from multiple searches.

  • No labels