I am trying to run a fetch for next weeks appointments that contain recalls. I need all recalls booked from Monday March 25 to March 31st.
I could write it like this, but it's tedious:
"ApptDate" >= 03/25/2019 and "ApptDate" <= 03/31/2019 and (OpCode = 02FOZZ9907 or OpCode = 03FOZZ9907 or OpCode = 04FOZZ9907 or OpCode = 05FOZZ9907 or OpCode = 06FOZZ9907 or OpCode = 07FOZZ9907 or OpCode = 08FOZZ9907 or OpCode = 09FOZZ9907 or OpCode = 10FOZZ9907 or OpCode = 13FOZZ9907 or OpCode = 15FOZZ9907 or OpCode = 17FOZZ9907 or OpCode = 18FOZZ9907 or OpCode = 19FOZZ9907 or OpCode = 20FOZZ9907 or OpCode = 21FOZZ9907 or OpCode = 26FOZZ9907)
I would like to have the OpCodeGroupCount(01/01/2012,12/31/2012,"Enter Op Code Group") field to be able to be pulled in Appt History source so you can create the group and pull the data all at once with out having to type out every opcode you are looking for in future appointments.