Lookup Results group

[robertkoch]

Hi

I just wanted to confirm...  is the layout of the Lookup results group in the webclient in version 8.0 defined by the default group for that mainview?

Thanks

Robert

[RJLedger · Accepted solution]

Nope.. in Tools->Group (Web Client) you have a specific "pick" that says:

     Default Lookup Group

 For the MainView you picked above it.

[robertkoch]

Thanks!

[Wicssmith]

Is it possible to set all users lookup group to a common group?

Is it possible to do as a mas update without having to log in as each user to update?

[greensweater]

There are two tables - USEROPTIONS and USEROPTIONSDEF which contain user options. USEROPTIONSDEF contains the default values for various options. USEROPTIONS contain the user-specific values for these options. Options are sorted by NAME and CATEGORY. The option value is in OPTIONVALUE for USEROPTIONS and DEFVALUE for USEROPTIONDEF. 

For example, to clear all users of the Account Lookup Group, you could just DELETE from USEROPTIONS where NAME = 'ACCOUNT' and CATEGORY = 'LOOKUPLAYOUTGROUP'. This would set all users' value back to the default which can be seen as SELECT * from USEROPTIONDEF where NAME = 'ACCOUNT' and CATEGORY = 'LOOKUPLAYOUTGROUP'.