Product - Group
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:14.000
Quickvet
MSACCESS
ODBC
Quickvet
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Sort rowsUnique rowsY Modified Java Script ValueProduct GroupY Merchandise InputSelect FieldsY Select FieldsSort rowsY Medication InputSelect Fields 2Y Select Fields 2Sort rowsY Service InputSelect Fields 3Y Select Fields 3Sort rowsY Unique rowsModified Java Script ValueY
Medication Input
TableInput
Y
1
none
Quickvet
select * from druginv
0
N
N
83
243
Y
Merchandise Input
TableInput
Y
1
none
Quickvet
select * from stockINV
0
N
N
83
152
Y
Modified Java Script Value
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var wordUtils = Packages.org.apache.commons.lang.WordUtils;
Category.setString(wordUtils.capitalizeFully(trim(Category.getString())))
if (Category.getString() == null)
Category.setString("None")
var CODE = replace(upper(Category.getString()),"[^A-Z0-9]+",'_')
CODE
CODE
String
-1
-1
573
149
Y
Product Group
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCODECategory<lookup.productGroup>nametruefalseCODE<lookup.productGroup>codetruefalsefalsetrue100
695
150
Y
Select Fields
SelectValues
Y
1
none
Category
-2
-2
220
151
Y
Select Fields 2
SelectValues
Y
1
none
Category
-2
-2
219
245
Y
Select Fields 3
SelectValues
Y
1
none
Category
-2
-2
217
346
Y
Service Input
TableInput
Y
1
none
Quickvet
select * from procedre
0
N
N
80
347
Y
Sort rows
SortRows
Y
1
none
%%java.io.tmpdir%%
out
5000
Y
Category
Y
365
153
Y
Unique rows
Unique
Y
1
none
N
Category
Y
454
150
Y