Practice - Species
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/09/15 11:04:46.014
RxWorks
MSACCESS
ODBC
RxWorks
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Table inputSelect valuesY Select valuesSort rowsY Sort rowsUnique rowsY Unique rowsFilter rowsY Filter rowsModified Java Script ValueY Filter rowsDummy (do nothing)Y Modified Java Script ValueSpeciesY
Dummy (do nothing)
Dummy
Y
1
none
530
318
Y
Filter rows
FilterRows
N
1
none
Modified Java Script Value
Dummy (do nothing)
N
SPECIES
IS NOT NULL
531
211
Y
Modified Java Script Value
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var NAME = SPECIES.getString()
SPECIES.setString(replace(upper(trim(SPECIES.getString())),"[^A-Z0-9]+",'_'))
NAME
NAME
String
-1
-1
641
210
Y
Species
OpenVPMSLoaderPlugin
Y
1
none
openvpmsSPECIESSPECIES<lookup.species>codetruefalseNAME<lookup.species>nametruefalsetruetrue1000
781
210
Y
Select values
SelectValues
Y
1
none
Patient Species
SPECIES
-2
-2
243
209
Y
Sort rows
SortRows
Y
1
none
%%java.io.tmpdir%%
out
5000
Y
SPECIES
Y
351
212
Y
Table input
TableInput
Y
1
none
RxWorks
SELECT * from Patient
0
N
N
140
210
Y
Unique rows
Unique
Y
1
none
N
SPECIES
N
443
209
Y