I'm looking to get to the data that produces the Study's updateDatasetVisitMapping.view page in my own queries to create a GUI that compares StudyData rows for a participant against what datasets are required for visits. This will enable a study monitor or QA person to quickly see what datasets (which compose an eCRF) are missing.

Looking at the study controller's action updateDatasetVisitMapping, the StudyManager uses a study schema table called 'VisitMap' and has two hard coded SQL queries (VISITMAP_JOIN_BY_VISIT and VISITMAP_JOIN_BY_DATASET) and a method getRequiredMap().

These is perfect for what I want to do, however, the VisitMap table is not available in the schema browser.

Would it be possible to expose this table or at least expose a read only query ( one or both of the two hardcoded in the StudyManager)?


I know there is an study API action called browseStudySchedule.api which populates a Grid view of the study schedule, but the way the data is returned in the resulting JSON is structured very specifically for that Grid and is difficult, but not impossible, to transform for my use case. It would be great to be able to do all transformations and joins in SQL instead of javascript.


Thanks,

Anthony