Skip navigation
2,639 Views 1 Reply Last post: Apr 2, 2010 5:27 AM by Andy Pardue RSS
Michael Huneycutt Sr Contributor 7 posts since
Jun 25, 2009
Currently Being Moderated

Apr 1, 2010 10:49 PM

Is there a good SUBFILE Example?

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

Andy Pardue Medspherian 159 posts since
Sep 11, 2008
Currently Being Moderated
1. Apr 2, 2010 5:27 AM in response to: Michael Huneycutt Sr
Re: Is there a good SUBFILE Example?

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

More Like This

  • Retrieving data ...

Bookmarked By (0)