This view was created as the results of a schema changes which introduced the table Wgn3IssuePaticipant. This is returns the same columns as WGN_V_ISSUE_1 but it returns 1 row per participant for all issues with RLS applied. It should be used wherever WGN_V_ISSUE_1 was previously used and the ParticipantIndex column is required.
Important: Do not revert back to using WGN_V_ISSUE_1. This view has been deprecated and has performance problems.
View Stack
|
WGN_V_CURR_ISSUE_PARTPNT_1 |
|
||||
|
→ |
WGN_V_m_CURR_ISSUE_PARTPNT_1 |
||||
|
|
→ |
WGN_V_MD_CURR_ISSUE_PARTPNT_1 |
|||
|
|
|
→ |
wgn3eventissue |
||
|
|
|
|
WGN3ISSUEPARTICIPANT |
||
|
|
|
|
WGN_V_MD_PNTUSER_1 |
||
|
|
|
|
→ |
wgn3eventparticipant |
|
|
|
|
|
|
WGN_V_RLS_ADDR_1 |
|
|
|
|
|
|
→ |
TMP_WGN3ADDRRLS |
Column Details
|
Column |
Data Type |
Length |
Description |
|
issueuid |
IDENTITYDEF |
13 |
Key used to uniquely identify an event issue. |
|
issuename |
VARCHAR |
255 |
The name of the issue, as specified in the iConsole or Data Management console. |
|
eventuid |
IDENTITYDEF |
13 |
Key used to uniquely identify a captured or imported event. |
|
eventtimestamp |
TIMESTAMP |
8 |
The time at which the event occurred. |
|
participantindex |
INTEGER |
4 |
Part-key used to identify an event participant. |
|
Copyright © 2014 CA.
All rights reserved.
|
|