Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# list_values

The `list_values` table holds the value of every item in every iProcess list on the system.

## Structure

The `list_values` table has the following structure:

    TABLE list_values (
    	node_id		INTEGER		NOT NULL,
    	list_id		INTEGER		NOT NULL,
    	record_id	INTEGER		NOT NULL,
    	list_value	VARCHAR(30)	NULL)

Column | Description
`node_id` | ID of the node that this list item is stored on, as defined in the nodes table.
`list_id` | ID of the list that this list item is stored in, as defined in the list_names table.
`record_id` | Unique ID for this list item.
`list_value` | Value of this list item.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_list_values` | `list_id record_id node_id`

## Triggers

None.

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed
`idx_list_values_fk` | `list_id node_id`

## Table Activity

The `list_values` table contains one row for each iProcess list item defined on the system.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | a Move System Information is performed, if the flag_table indicates that the Lists data area has been modified. Note: The table is purged and rewritten using the values from the tsys_list_values table.
updated | never.
deleted | a Move System Information is performed, if the flag_table indicates that the Lists data area has been modified. Note: The table is purged and rewritten using the values from the tsys_list_values table.

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