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?
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.
11-18-2009 03:11 PM
IUserOptionsService userOption = ApplicationContext.Current.Services.Get<IUserOptionsService>(true);
Web 7.5.2 - Easier
John PeronaDirector, Infor CRM Development