Associated User Showing the Wrong Info or User

The current keymaster – associated user does not change when you change the associated user in the miscellaneous tab. To see the change you expect, here is the procedure:

CREATE view DIAGWIN_V_ASSETASSOCIATEDUSER
as
SELECT U.DisplayName AssociatedUser, A.AssetKey, A.DateModified FROM DIAGWIN_ASSET_ASSOCIATEDUSER A,
(SELECT ASSETKEY, MAX(DATEMODIFIED) DateModified FROM DIAGWIN_ASSET_ASSOCIATEDUSER GROUP BY AssetKey) B,
DiagWin_USERINFO_MST U
WHERE a.AssetKey = b.AssetKey and a.DateModified = b.DateModified AND A.UserId = U.UserId

Insert into diagwin_Field_select_mst (class, attribute, title, description, Product)
Values (‘ASSETASSOCIATEDUSER’, ‘AssociatedUser’,‘AssociatedUser’,‘AssociatedUser’,0)

Run the above scripts 1 and 2. It will create a class called ASSETASSOCIATEDUSER visible in the select fields.

Delete the current Keymaster – AssociatedUser from the field select.

Add class= ASSETASSOCIATEDUSER, field AssociatedUser. This will show the latest associated user in the grid.