I have a need to get data from a SUBFILE, similar to SYNONYMS in the DRUG file or INSURANCE TYPE in the PATIENT file. So I took a look at FMOrder/FMOrderableItem as the example and though the FMOrderableItem is defined as a SUBFILE in hte FMOrder, FMOrderableItem is being retrieved directly in the OrderRespository and file 101.43 aka ORDERABLE ITEMS can be access directly anyway. Also I am not sure it makes sense to me as in FMOrder, the attribute for FMOrderableItem is defined as a one-to-one and not a one-to-many. It would seem it needs to be defined as a one-to-many like List<FMOrderableItem>, since it is a multiple. I took a look at FMDrug/FMDrugSynonym and this is a better example, but same query occurs to me there also, which is how to get the list of synonyms, when in FMDrug the attributes is FMDrugSynonym is defined as a one-to-one and not List<FMDrugSynonym> to reflect that it is a list.
Any help would be appreciated.
Thanks
Mike H. Sr
Hello Mike,
In the latest version of ovid in lp:launchpad, take a look at the getRaceInformation and getEthnicity from PatientRepository.java. Both RACE and ETHNICITY are SUBFILE fields in PATIENT and can have multiple values, returned as a List<> in the java repository code. I think that this mimics your use case.
If it isn't clear, let me know more details and I can put together an example specific to your problem next week.
Andy