Pages

Monday, April 16, 2012

OTM User Favorites

Favorites are the records that you select to appear first in search results. You can define records from tables of order, shipment , locations etc,. You can edit , delete and also add new favorites to your preferences at any time. 


For example, you can select your most commonly used service providers to appear first in the search results of the Service Provider Manager. 


To Configure User Favorites, 
-> Navigate to Configuration and Administration > Preferences > User Favorites
-> Click on 'New Favorite'
-> Select the appropriate table name. For Eg: Location, Service Provider ID, etc,.
-> Enter the record value. For Eg: Location : Chennai
-> Click on Save button
-> Repeat the above steps to add multiple favorites
-> Finally click on 'Save Favorites' to save it to your preferences. 



Database Table names
-----------------------
User Favorites details are stored in 2 tables
1. USER_FAVORITE_TABLE
Contains the data of OTM User ID & Query TABLE names. 

2. USER_FAVORITE
Contains the data of OTM User ID - Query Table name - Favorite Value

For Example: If i set up a favorite location : Chennai
USER_FAVORITE will have below data
GL_USER_GID|QUERY_TABLE_GID|USER_FAVORITE_VALUE
D1.SAM|LOCATION|CHENNAI

& USER_FAVORITE_TABLE will have
GL_USER_GID|QUERY_TABLE_GID
D1.SAM|LOCATION

No comments:

Post a Comment