I can get the AppointmentsId to show up when using the following mel expression in a data display...
find("Document","AppointmentsID")
but am not having any success getting the FacilityId to show up with the following...
find("_PatientAppointments","FacilityId","AppointmentsId",
find("Document","AppointmentsId"))
What am I missing? I do have the update linked to an appointment or the first expression would have been blank.
I don't see an issue, this is exactly what I use, you can try it (CPS 12.0.12) -
find("AllLocation","abbrevName","FacilityID",find("_PatientAppointments","FacilityID","AppointmentsID",find("Document","AppointmentsID")))
You can try to re-key it, that helps sometimes for whatever reason. Also try to pull something different like "DoctorID" to rule out any issues with the specific facility or appointment.
You can check str(getrowcount("_PatientAppointments")) to verify the object is properly opening as well.
Do you ever write code in another program? I had an issue where I wrote something on a Windows sticky note or Notepad or something, and what should have worked didn't simply because double quotes (") has a different ASCII code in different programs and MEL didn't recognize it. Once I retyped the entire thing, it worked.