Page Comparison

...

Code Block
<repoName>.protocolservice.database.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver <repoName>.protocolservice.database.url=jdbc:sqlserver://localhost:1433;databaseName=CONTENTSERVER;

Tables:

PROTOCOL

Contains on record per access, defines acces modul and access data

...

Expand

title	Table create script (based on MSSQL)

CREATE TABLE [dbo].[PROTKEY_VALUES](
[ID] [numeric](19, 0) NOT NULL,
[FIELDBOOLVALUE] [bit] NULL,
[FIELDDATETIMEVALUE] datetime2 NULL,
[FIELDDECIMALVALUE] [numeric](28, 0) NULL,
[FIELDINTVALUE] [numeric](28, 0) NULL,
[FIELDSTRINGVALUE] varchar NULL,
[TYPEID] varchar NOT NULL,
[RECORDID] [numeric](19, 0) NOT NULL,
[FIELDID] varchar NOT NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[PROTKEY_VALUES] ADD DEFAULT ((0)) FOR [FIELDBOOLVALUE]
GO

ALTER TABLE [dbo].[PROTKEY_VALUES] WITH CHECK ADD CONSTRAINT [PROTKEY_VALUESRECORDID] FOREIGN KEY([RECORDID])
REFERENCES [dbo].[PROTOCOL] ([RECORDID])
GO

ALTER TABLE [dbo].[PROTKEY_VALUES] CHECK CONSTRAINT [PROTKEY_VALUESRECORDID]
GO

Example Queries (based on MSSQL)

Read find all Entries

Code Block

language	sql

SELECT p.*, pv.FIELDSTRINGVALUE as 'Path'
  FROM [PROTOCOL] p
  inner join PROTKEY_VALUES pv on p.RECORDID = pv.RECORDID
  where pv.FIELDID = 'path'

find read entries only

you can replace “read“ with the following values to get only certain categories:

Value	Description
read	all read access to a folder or document
create	all create folder or document entries
update	all update requests
delete	all delete requests for folder or documents
info	for info requests (AricheLink or ILM)
admin	all admin access like create put certificate or serverInfo

Code Block
SELECT p.*, pv.FIELDSTRINGVALUE as 'Path' FROM [PROTOCOL] p inner join PROTKEY_VALUES pv on p.RECORDID = pv.RECORDID where pv.FIELDID = 'path' and p.COMMANDCATEGORY = 'read'

Versions Compared

Old Version 3

New Version 4

Key

Tables:

Example Queries (based on MSSQL)