xquery version "1.0"; declare option exist:serialize "method=xhtml media-type=text/html indent=yes"; let $collection := '/db/apps/SOAPNotes/data' return Patient in Novemeber

Patient in Novemeber

    { (: search any column that matchs this string :) for $hit in collection($collection)/item[*/text()] where substring($hit/date/text(), 6, 2) = '11' return
  1. {$hit/name/text()} - Date of Injury {$hit/date/text()} | Patient ID {$hit/patient_id/text()}
  2. }
Reports | Notes Home