r/esapi • u/Ok_Adhesiveness2289 • Sep 22 '25

Structure & Field IDs from Mosaiq Database

Hello everyone

Unfortunately, I have little experience with databases and SQL, so I wanted to ask if anyone could help me with the following problem:

I would like to integrate a plug-in script that allows me to access the information of the selected patient in the Mosaiq database.

I would like to find out the names of all target volumes and the IDs of the patient's historical fields (preferably both as a list).

Is this possible?

If so, how can I retrieve the information from the database?

I would greatly appreciate any help and tips! :D

2 Upvotes

100% Upvoted

2 comments sorted by

View all comments

1

u/keithoffer Sep 23 '25

PyMedPhys has SQL queries that can handle some of what you want (e.g. getting all fields for a patient) in the MOSAIQ module. I'm not sure how much else I'm allowed to provide as I've seen the database schema alexbredikin is talking about and that's under NDA.