Copyright © Cloud Software Group, Inc. All rights reserved.

user_setting

The user_setting table holds the settings that a given user has defined in the iProcess Workspace (Browser). This enables a user to keep the same settings when working on any machine.

Structure

The user_setting table has the following structure:

TABLE user_setting (
username varchar(32) NOT NULL,
userkey varchar(128) NOT NULL
valindex integer NOT NULL,
vallen integer NOT NULL
uservalue varbinary(max) NOT NULL

Column	Description
username	The name of the user whose preferences these are, as defined in the user_names table.
userkey	The key of the user.
valindex	The index number into the set of rows that make up the user value. If the user value is longer than 30,000 bytes, multiple rows (in 30,000 byte chunks) are used to store the user value. Each segment of the user value is uniquely identified by its vaindex value. Note: Since iProcess Engine 11.6, the volume of a row is upgraded. The value of valindex might always be 1.
vallen	The size (in bytes) of the memo data for this row.
uservalue	The value of the particular user identified by userkey.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)
pk_usersetting	username userkey valindex

 

Copyright © Cloud Software Group, Inc. All rights reserved.