09-18-2009 07:08 AM
A customer raised an interesting question, "how can they find out what the setting are for each user in the Tools, Options, Lookups and Groups for the Main View and Default Group for each main view?" Once these are set there is no visible way of seeing the settings.
The request came form a system administrator that is trying to minimize the initial Client loading time by having the default group set to a small group.
Where is the user data stored so a report could be written to display this information?
Thanks,
Bruce Pershke
PBDI
615-851-9497
09-18-2009 07:52 AM
10-05-2009 10:20 AM
My understanding is Adam is right, the default group for a mainview is stored in the useroptions table optionvalue memo field, with the Name value being the mainview (for example, “Account”) and the Category value being “DefaultGroup”. If there is no useroption for that user than it uses the value from the useroptiondef table. The value will be in the format mainview:groupname.
There isn't a useroptions entity in SalesLogix; so you can use ado.net, or crystal, or any sql tool that can show you memo fields should work fine.
10-10-2009 03:52 PM
John Perona
Director, Infor CRM DevelopmentInfor CRM
11-18-2009 01:47 PM
11-18-2009 03:11 PM
Web
IUserOptionsService userOption = ApplicationContext.Current.Services.Get<IUserOptionsService>(true);
Web 7.5.2 - Easier
MySlx.Security.UserOptions
John Perona
Director, Infor CRM DevelopmentInfor CRM