View panel attribute values.
UNDEFINED attributes are not shown in this view. UNKNOWN values are represented by a NULL in both value fields.
The definition of the attributes can be found in the Catalogue Editor.
Output
Column | Type | Description |
|---|---|---|
panelver_id | NUMBER | Primary key of the panel version. |
acronym | VARCHAR2 | Attribute acronym. |
stringval | VARCHAR2 | Value of the attribute, if it is a string. |
numberval | NUMBER | Value of the attribute, if it is a number. |
sequence | NUMBER | Used to sequence multiple values for the same attribute. This is used for list values and long string values. |
Example
The following examples show the use of this view on an SQL statement.
-- find a panel by panel name. select panelver_id from PANEL_ATTRIBUTES_VIEW WHERE acronym = 'PANNAM' and stringval = 'river'; |
-- get the scale for a panel select numberval from PANEL_ATTRIBUTES_VIEW WHERE acronym = 'PSCALE' and panelver_id = 1234; |
Exceptions
None defined at this time.