Configuring additional user fields

If searching a user by the username alone does not provide unique results, you can include more fields such as email, employee Id’s, names and login names by modifying the global configuration table.

For modifying the global configuration table,

• Using the command prompt, Go to the product installation location.
• Find pgsql folder.
• Open bin folder.
• Execute the command, "psql -U postgres -p 65433".
• Connect to the assetexplorer database by executing the command, "c assetexplorer"(By default the product database name would be "assetexplorer".).
• Execute the command, "update gobalconfig set paramvalue = 'name,email,employeeId,loginName' where category = 'UserSearchOptions’;".
• Changing the order of the parameters will change the order in the search box as well.
  
  For databases in mssql and mysql servers,
• Execute this command "update gobalconfig set paramvalue = 'name,email,employeeId,loginName' where category = 'UserSearchOptions’;" by connecting to the product database.By default the product database name would be "assetexplorer".