Home > Synergy > Hints and tips > Reports

Search

4 or more repeat prescriptions

If you are on Synergy 1.4 this can be done with a single query

Report for each Patient where
Patient.Registration_Type = "Full GMS"
with/without note where Note.Read_Code = "8B314" 
and Note.Start_Date > -15M
with Authorisation where Authorisation.Current = True
and Authorisation.Auth_Type = "Repeat"
and authorisation.read_code not between "a" and "b" # topical medicines range 
and authorisation.read_code not between "x" and "y" # in case another exclusion needed 
and Authorisation.Count >= 4 
;