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