Database Schema and Views Reference Guide › Database Views › Primary Views Definitions › WGN3USERADDRESS

WGN3USERADDRESS

This view does not conform to the usual naming standard. It was created for compatibility reasons because of a small schema change in CA DataMinder 12.0. We recommend that reports use the Wgn_V_User_Address_1 view instead of this view. RLS is not applied to this view.

Previous to 12.0, Wgn3UserAddress was a table instead of a view. In order to removed the dual access path (the second path was via the WgnUserLogin table), each user login that generates an event (such as Web events) needed to be given an address. This required an extra column in the table. Creating this extra column had compatibility issues. Therefore, table Wgn3UserAddressEx was created for this and the old table became a view which returns the same data that the original would have returned.

View Stack

Column Details