This view reflects an interface of the table Wgn3EventIssue with RLS applied and returns 1 row per issue. For these releases the column ParticipantIndex was removed and put into a new table Wgn3IssueParticipant as part of a schema change to allow an issue to be associated with zero, one or many participants. It should be used wherever WGN_V_ISSUE_1 was previously used and the ParticipantIndex column is NOT required. If you want to see the field ParticipantIndex then this can be done using the view WGN_V_CURR_ISSUE_PARTICIPANT_1 instead. Do NOT revert back to using WGN_V_ISSUE_1 this has been deprecated post these release and is subject to performance problems.
View Stack
|
Wgn_V_Issue_2 |
|
|
|
||
|
→ |
WGN_V_m_ISSUE_2 |
|
|||
|
|
→ |
WGN_V_MD_ISSUE_2 |
|
||
|
|
|
→ |
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. |
|
Copyright © 2014 CA.
All rights reserved.
|
|