OTM User Preference

OTM User Preference is a combination of different preferences and settings for a user or a user role or an entire domain. 


To Create a User Preference:

1. Navigate to Configuration and Administration > Preferences > User Preferences
2. Click on 'New' Button
3. Enter a unique User Preference ID
4. Choose the appropriate domain
5. Choose a preference name from the drop down list and its value. click on save button
6. Repeat step 5 to set up different types of preferences.

Commonly used preference settings:

Name	Details	Values	Default
Ask OTM State	Controls the display of Ask OTM wizard tool bar	Show or Hide	Show
Business Monitor	Defines which BM should be visible for a user	Valid Business Monitors available	None
Country	Related to language settings	Canada, China, France, Germany, GB, Italy , USA etc	United States
Currency	Unit of Currency	Around 75 currencies	USD
Date Format	Defines how the date should appear to the user	Various options
Day-of-Week Start	The day to be considered as the start of the week	Sunday or Monday	Sunday
Distance	The unit of measure for distance data.	Miles, Nautical Miles, KMs	Miles
Duration	The unit of time measurement	Seconds, Minutes, Hours, Days, Weeks	Hours
Length	The Unit of measure for lengths	Centimetres, Inches, Feet, yards, Meters	Feet
Finder Click Action	Controls how to open objects when selected from search results	Always open in same window Always open in new window Replace current window	Replace Current Window
Finder Page size	Controls the max no. records appear per page on a screen set results tab	Optimal is between 25 and 100	25
Language	Language of the application labels, screens etc	Chinese, English, French, German, Italian etc	English
Results Query Line State	Controls the display of query section that appears by default at the bottom of every results page	Hidden Visible	Visible
Speed	The unit of measure for distance/time	Miles per Hour Kilometres per Hour	Miles per hour
Stylesheet Location	This is for branding purposes. We can specify a location from which webserver has to pick style sheets.	Value representing the location.	Default
Temperature	The scale of measurement for temperature	Fahrenheit , Kelvin, Celsius	Fahrenheit
Time Format	The format of time	hh:mm a z: 11:59 p.m. EST hh:mm a: 11:59 p.m. hh:mm: 23:59 hh:mm z: 23:59 EST	hh:mm a z: 11:59 p.m. EST
Time Zone	Time Zone used to calculate time records	World Time Zones	EST
Volume	The unit of measure for volume.	Cubic Feet Litres Cubic Meters Gallons Canadian Gallon Cubic Yards Cubic Inches	Cubic Feet
Weight	The unit of measure for weight.	Pound Kilogram Metric Ton Ton Kilopound	Pound

Database Table Names:

------------------------

USER_PREFERENCE table stores the data of all user preferences

USER_PREFERENCE_D table stores the individual preference details of each User Preference. 

For Eg: If we create a User Preference TEST_PREF with 2 settings

Volume - Litres

Language - French

USER_PREFERENCE will contain a single record for TEST_PREF details

where as USER_PREFERENCE_D will have 2 records

TEST_PREF | Volume | Litres

TEST_PREF | Language | French