|
With the release of WIMS Client 8.3.2 a database upgrade is required. The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 8.3.2 client.
Tech Notes:
SQL Server Scripts:
OPSROOT
INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','GRAPHBAR','GRAPHBAR(GraphId, GroupOffset/StartDate, Grouping/EndDate)', 'displays a saved Bar Graph in the cell','14793', 'SPECIAL', 'GRAPH','')
INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','GRAPHSTS','GRAPHSTS(GraphId, GroupOffset/StartDate, Grouping/EndDate)', displays a saved Time Series Graph in the cell','14812', 'SPECIAL', 'GRAPH','')
INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','GRAPHLINEVARS','GraphLineVars(QuickStyle, GroupOffset/Date, Grouping/EndDate,MainTitle, SubTitle, YAxisType, LinesOn2ndY, YaxisMin, YAzisMax, varnum1,..,Varnum10)', isplays a Line Graph for specified variables','14814', 'SPECIAL', 'GRAPH','')
INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','AVERAGE','AVERAGE(Value1, Value2, ...)', 'returns the average of the specified values','11514', 'PRIMITIVE', '','')
Facility Databases
ALTER TABLE LC_TEST ALTER COLUMN CASNO NVARCHAR(20)
ALTER TABLE VARDESC ADD UD10 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD11 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD12 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD13 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD14 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD15 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD16 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD17 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD18 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD19 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE VARDESC ADD UD20 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD11 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD12 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD13 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD14 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD15 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD16 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD17 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD18 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD19 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LOCATION ADD UD20 NVARCHAR(255) NULL DEFAULT (NULL)
CREATE TABLE [dbo].[EXCELREPORT](
[ID] [int] IDENTITY(1,1) NOT NULL,
[AUDITUSER] [varchar](50) NULL,
[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
[TEMPLATENAME] [nvarchar](500) NULL,
[DEFAULTDATES] [nvarchar](100) NULL,
[GROUPID] [Numeric](18, 0) NULL DEFAULT NULL,
[NAME] [nvarchar](255) NULL) ON [PRIMARY]
CREATE TABLE [dbo].[EXCELREPORTVARS](
[ERVID] [int] IDENTITY(1,1) NOT NULL,
[ERID] [int] NOT NULL,
[AUDITUSER] [varchar](50) NULL,
[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
[VARID] [numeric](18, 0) NULL DEFAULT (NULL),
[SHOWTV] [numeric](18, 0) NULL DEFAULT (NULL),
[SHOWCV] [numeric](18, 0) NULL DEFAULT (NULL),
[SHOWCOM] [numeric](18, 0) NULL DEFAULT (NULL),
[SORTTV] [numeric](18, 0) NULL DEFAULT (NULL),
[SORTCV] [numeric](18, 0) NULL DEFAULT (NULL),
[SORTCOM] [numeric](18, 0) NULL DEFAULT (NULL),
[FILTERTV] [nvarchar](1000) NULL DEFAULT (NULL),
[FILTERCV] [nvarchar](1000) NULL DEFAULT (NULL),
[FILTERCOM] [nvarchar](1000) NULL DEFAULT (NULL)
)ON [PRIMARY]
UPDATE SETTINGS SET CURVALUE = '832' WHERE SETTING= 'DATAVERSION'
Oracle Scripts:
OPSROOT
INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','GRAPHBAR','GRAPHBAR(GraphId, GroupOffset/StartDate, Grouping/EndDate)', 'displays a saved Bar Graph in the cell','14793', 'SPECIAL', 'GRAPH','')
INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','GRAPHSTS','GRAPHSTS(GraphId, GroupOffset/StartDate, Grouping/EndDate)', displays a saved Time Series Graph in the cell','14812', 'SPECIAL', 'GRAPH','')
INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','GRAPHLINEVARS','GraphLineVars(QuickStyle, GroupOffset/Date, Grouping/EndDate,MainTitle, SubTitle, YAxisType, LinesOn2ndY, YaxisMin, YAzisMax, varnum1,..,Varnum10)', isplays a Line Graph for specified variables','14814', 'SPECIAL', 'GRAPH','')
INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('UP832','2024-11-14','AVERAGE','AVERAGE(Value1, Value2, ...)', 'returns the average of the specified values','11514', 'PRIMITIVE', '','')
Facility Databases
ALTER TABLE LC_TEST MODIFY(CASNO NVARCHAR2(20))
ALTER TABLE VARDESC ADD UD10 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD11 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD12 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD13 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD14 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD15 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD16 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD17 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD18 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD19 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE VARDESC ADD UD20 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD11 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD12 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD13 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD14 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD15 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD16 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD17 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD18 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD19 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LOCATION ADD UD20 NVARCHAR2(255) DEFAULT NULL
CREATE TABLE "EXCELREPORT"
("ID" NUMBER NOT NULL,
"AUDITUSER" VARCHAR2(50) NULL,
"AUDITTIMESTAMP" DATE DEFAULT NULL,
"TEMPLATENAME" NVARCHAR2 (500) NULL,
"DEFAULTDATES" NVARCHAR2 (100) NULL,
"NAME" NVARCHAR2 (255) NULL,
"GROUPID" NUMBER DEFAULT 0 NULL)
CREATE SEQUENCE "A_EXCELREPORT" INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER
CREATE TRIGGER "T_EXCELREPORT" BEFORE INSERT ON "EXCELREPORT" FOR EACH ROW BEGIN SELECT "A_EXCELREPORT".NEXTVAL INTO :NEW. "ID" FROM DUAL; END T_EXCELREPORT;
UPDATE SETTINGS SET CURVALUE = '832' WHERE SETTING= 'DATAVERSION'
|
 |
|
|
|
No Related Articles Available.
|
|
|
|
|
No Attachments Available.
|
|
|
|
|
No Related Links Available.
|
|
|
|
|
|
|
|
|
|
No user comments available for this article.
|
|
|
|
|
|
|
Created on 11/14/2024 10:24 AM. |
|
|
Last Modified on 12/20/2024 11:50 AM. |
|
|
Last Modified by Scott Dorner. |
|
|
Article has been viewed 367 times. |
|
|
Rated 0 out of 10 based on 0 votes. |
|
 Print Article |
|
 Email Article
|
|
|