Practice - Reminder Group
/
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 ValueReminder GroupY
Dummy (do nothing)
Dummy
Y
1
none
530
318
Y
Filter rows
FilterRows
N
1
none
Modified Java Script Value
Dummy (do nothing)
N
GROUP
IS NOT NULL
531
211
Y
Modified Java Script Value
ScriptValueMod
Y
1
none
0
Script 1
//Script here
GROUP.setString(replace(upper(trim(GROUP.getString())),"[^A-Z0-9]+",'_'))
641
210
Y
Reminder Group
OpenVPMSLoaderPlugin
Y
1
none
openvpmsGROUPGROUP<lookup.reminderGroup>codetruefalseGROUP<lookup.reminderGroup>nametruefalsetruetrue1000
780
210
Y
Select values
SelectValues
Y
1
none
Reminder Category
GROUP
-2
-2
243
209
Y
Sort rows
SortRows
Y
1
none
%%java.io.tmpdir%%
out
5000
Y
GROUP
Y
351
212
Y
Table input
TableInput
Y
1
none
RxWorks
SELECT * from [List - Reminder]
0
N
N
140
210
Y
Unique rows
Unique
Y
1
none
N
GROUP
N
443
209
Y