0.00.0100011NY5000Y-2007/04/10 10:05:11.810openvpmslocalhostMYSQLNativeopenvpms3306openvpmsEncrypted 2be98afc86aa7f2e4a409ab7ec882a2c9EXTRA_OPTION_MYSQL.defaultFetchSize500EXTRA_OPTION_MYSQL.useCursorFetchtrueIS_CLUSTEREDNMAXIMUM_POOL_SIZE10PORT_NUMBER3306STREAM_RESULTSYUSE_POOLINGNVisit Text InputTransform Visit Text FieldsYTransform Visit Text FieldsGroup text togetherYGroup text togetherTransform into linesYXBase inputSelect Visit FieldsYSelect Visit FieldsFilter rowsYMerge JoinAdd Item IDYFilter rowsDummy (do nothing)YFilter rowsMerge JoinYTransform into linesMerge JoinYAdd Item IDPatient Visit Text OutputYAdd Item IDScriptValueModY1none0Script 1//Script here
var VISITITEMID = "TEXT" + TREATNO.getString();VISITITEMIDVISITITEMIDString-1-171698YDummy (do nothing)DummyY1none393188YFilter rowsFilterRowsY1noneMerge JoinDummy (do nothing)NNPETNUMBER<>constantNumber0.0-1-1NNANDTREATNOIS NOT NULLNANDPETNUMBERIS NOT NULL39398YGroup text togetherGroupByY1noneNN%%java.io.tmpdir%%grpNTREATNOTEXTTEXTCONCAT_COMMA348291YMerge JoinMergeJoinY1noneINNERFilter rowsTransform into linesTREATNOTREATNO58897YPatient Visit Text OutputOpenVPMSLoaderPluginY1noneopenvpmsVISITITEMIDTEXT<act.patientClinicalNote>notetruefalseTREATDATE<act.patientClinicalNote>startTimefalsefalsePETNUMBER<act.patientClinicalNote>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseVISITITEMID<act.patientClinicalNote>patient[0]<participation.patient>acttrue<act.patientClinicalNote>$valuefalseTREATNO<actRelationship.patientClinicalEventItem>sourcetrue<act.patientClinicalEvent>$valuefalseVISITITEMID<actRelationship.patientClinicalEventItem>targettrue<act.patientClinicalNote>$valuefalsetruetrue84196YSelect Visit FieldsSelectValuesY1nonePETNUMBER-2-2TREATNO-2-2TREATDATE-2-224598YTransform Visit Text FieldsScriptValueModY1none0Script 1// Prefix text strings with type
/*
if (TYPE.getString() == "D") {
TEXT.setString("Diagnosis: " + TEXT.getString())
}
else if (TYPE.getString() == "E") {
TEXT.setString("Exam: " + TEXT.getString())
}
else if (TYPE.getString() == "T") {
TEXT.setString("Treatment: " + TEXT.getString())
}
else if (TYPE.getString() == "C") {
TEXT.setString("Reason: " + TEXT.getString())
}
else {
TEXT.setString("History: " + TEXT.getString())
}
*/
// Replace and comma with @ so grouping can be split into lines
TEXT.setString(replace(TEXT.getString(),",","@"))219292YTransform into linesScriptValueModY1none0Script 1//Script here
TEXT.setString(replace(TEXT.getString(),",","\n\r"))
TEXT.setString(replace(TEXT.getString(),"@",","))590292YVisit Text InputXBaseInputY1noneF:\VETAID\CONTEXT.DBF0NNN96293YXBase inputXBaseInputY1noneF:\VETAID\CONSULT.DBF0NNN9898Y