Accessing the UserOptions for a User in the Infor CRM (formerly Saleslogix) Web Client

The entity model in the web client does not contain an entity which exposes the UserOptions table.  SO how can you access the data here?

Well there are 2 ways really. Lets take a look.

#1 Add the USEROPTIONS table to the Saleslogix Application Entities area.  Then you can query against it and do finds using the IRepositoryHelper. The following shows how to get the default team for a user:

var userExCode = “SYST00000001”;
Sage.Platform.RepositoryHelper<IUserOptions> repository =
Sage.Platform.Repository.ICriteria criteria = repository.CreateCriteria();
criteria.Add(repository.EF.Eq(“USERID”, “XYZ”));     
criteria.Add(repository.EF.Eq(“CATEGORY”, “General”));     
criteria.Add(repository.EF.Eq(“NAME”, “InsertSecCodeID”));     
System.Collections.Generic.IList<Sage.Entity.Interfaces.IUserOptions> options = criteria.List<Sage.Entity.Interfaces.IUserOptions>();
foreach(Sage.Entity.Interfaces.IUserOptions option in options)
   userExCode = option.OPTIONVALUE;   

#2 Use something already built in!  The UserOptionsService.  Here is a sample C# snippet showing how to use it to also find the users default owner:

var userOption = ApplicationContext.Current.Services.Get<IUserOptionsService>();
var userExCode = !string.IsNullOrEmpty(userOption.GetCommonOption(“InsertSecCodeID”, “General”))
? userOption.GetCommonOption(“InsertSecCodeID”, “General”)
: “SYST00000001”;

Note that users may or may not always have a specific option defined.  That is why you should always check that like shown in the code snippet above.


Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!