Coming soon: Your brand new Help Center & Community! Get a sneak-peek here

User Preferences

In this article

    These pages describe the user-preferences used in the Sales & Marketing application.

    Note that many of these preferences control important system functions, and changing the values or adding a new preference value may cause the SuperOffice application or specific functionality (like travel or area management) to stop working.

    In other words, be very careful when manipulating these preferences.

    Preferences are stored in the UserPreference table in the database.

    Preferences can be defined at six different levels:

    1 global defaults
    2 system wide
    3 database wide (e.g. specific to a satellite)
    4 user-group wide (all users in a particular group)
    5 user specific
    6 machine specific (stored in registry under HKLM)

    User preferences are stored at multiple levels.

    We always use the most specific preference for the logged in user.

    UserPreference sample table

    id deflevel maxlevel owner_id prefsection prefkey prefvalue
    1 2 5 0 MyThing Volume quiet
    2 4 5 123 MyThing Volume off
    3 5 5 456 MyThing Volume loud
    4 5 5 789 MyThing Volume quiet
    5 2 3 0 MyThing Color purple
    6 3 3 999 MyThing Color green

    The deflevel value defines which level this preference value is defined at. The values here correspond to the list above.

    The MaxLevel value defines the max level at which a preference should be shown in the GUI. Some preferences are not controlled by the user, and can only be edited in the admin tool.

    The meaning of the owner_id depends on the deflevel value.

    • deflevel = 1 --> owner_id = 0
    • deflevel = 2 --> owner_id = 0
    • deflevel = 3 --> owner_id = satellite id (travelcurrent_id)
    • deflevel = 4 --> owner_id = usergroup_id
    • deflevel = 5 --> owner_id = associate_id
    • deflevel = 6 --> not stored in database

    Given the sample data above, a typical user would have the default value for the preference

    [MyThing] Volume = "quiet"

    since this is the system-wide default.


    A user who is in primary usergroup 123 would get the value "off" for the same preference, since row id 2 overrides the more general preference in row id 1.

    The user with associate_id 456 (even if he was in usergroup 123) would get his user-specific preference, which is "loud".

    The user with assoicate_id 789 would get the value "quiet" because of the preference with id 4. The user-specific preference has a higher priority than any of the others, so it is the one which applies.


    Note that you can define whatever section and keynames you want. You do not need to register your section with SuperOffice. Just start using the section and key names directly.

    Note that if there is no value defined, you won't find a userpreference value in the table. Your code should take care to handle empty preferences in a sensible way.

    With no default defined, we get the empty string back.