ClassMethod GetPatientDetails(patientID As %String) As %String
{
New SQLCODE
&sql(SELECT Profession->Industry,Profession->Profession,FavoriteColor
INTO :Industry,:Profession,:FavoriteColor
FROM BI_Study.PatientDetails
WHERE PatientID=:patientID)
If (SQLCODE'=0) {
Set Industry="",Profession="",FavoriteColor=""
}
Set ReturnValue=$LISTBUILD(Industry,Profession,FavoriteColor)
Quit ReturnValue
}