title: Developing and implementing electronic search strategies to recruit patients with chronic musculoskeletal pain in primary care databases.
abstract: BACKGROUND
  Identifying patients with chronic musculoskeletal pain using database searches is difficult, as chronic pain is not represented with a unique diagnostic code in electronic primary care records. Aim This paper describes the development and implementation of a search strategy to identify patients with chronic musculoskeletal pain in primary care databases to invite them to participate in a randomised controlled trial.
  
  
  METHODS
  We used an exploratory, iterative approach. The first phase involved consultations with IT specialists, practice managers and doctors to gain an understanding about the processes and issues of electronic coding. In the second and third phases, we determined the most appropriate search terms and strategies. In the final phase, we tested, modified and re-tested the search strategy until the quantity and quality of the output appeared good enough to be used in general practices with different IT systems. This strategy was then implemented to recruit participants for a trial. Findings We identified three main search 'domains': prescribing, coding and attendance. We found the most useful identifier for chronic pain was the use of repeat medication. Wide variations in coding terms for chronic pain were seen between practices and individuals. Understanding 'coding cultures' were necessary to inform the electronic searches. In the case of chronic pain, searching on repeat medication for analgesia, low dose antidepressants and carefully selected coding terms captured most relevant patients.
authors.affiliation: NIHR Clinical Lecturer,The Blizard Institute,Centre for Primary Care and Public Health,Barts and The London School of Medicine and Dentistry,Queen Mary University of London,London,UK.
authors.forename: Jens
authors.initials: J
authors.lastname: Foell
authors.affiliation: NIHR Clinical Lecturer,The Blizard Institute,Centre for Primary Care and Public Health,Barts and The London School of Medicine and Dentistry,Queen Mary University of London,London,UK.
authors.forename: Dawn
authors.initials: D
authors.lastname: Carnes
authors.affiliation: NIHR Clinical Lecturer,The Blizard Institute,Centre for Primary Care and Public Health,Barts and The London School of Medicine and Dentistry,Queen Mary University of London,London,UK.
authors.forename: Kate
authors.initials: K
authors.lastname: Homer
authors.affiliation: NIHR Clinical Lecturer,The Blizard Institute,Centre for Primary Care and Public Health,Barts and The London School of Medicine and Dentistry,Queen Mary University of London,London,UK.
authors.forename: Stephanie
authors.initials: S
authors.lastname: Taylor
mesh_terms: D000328:Adult; D000700:Analgesics / Q000627:therapeutic use*; D059350:Chronic Pain; D059019:Clinical Coding / Q000379:methods / Q000592:standards*; D016208:Databases, Factual; D004739:England; D006801:Humans; D016247:Information Storage and Retrieval / Q000379:methods; D059352:Musculoskeletal Pain; D009819:Office Visits / Q000706:statistics & numerical data; D018579:Patient Selection; D011320:Primary Health Care / Q000379:methods / Q000706:statistics & numerical data*
chemical_list: D000700:Analgesics