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:
1.
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
2.
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.
