Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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	varchar2(32 char)	NOT NULL,
    	userkey		varchar2(128 char)	NOT NULL
    	valindex	number(10)			NOT NULL,
    	vallen		number(10)			NOT NULL
    	uservalue	blobNULL

Column | Description
`username` | The name of the user whose preferences are 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 larger 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) | Index Tablespace
`pk_user_setting` | `username userkey valindex` | BIGINDEXSPACE

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine