How can I 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?

Question:

How can I 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?

Answers:

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.

Want content like this delivered to your inbox? Sign up for our newsletter!

Submit a Comment

Your email address will not be published. Required fields are marked *