Login / Register  search  syndication  about

          SalesLogix Questions & Answers

Your place to get answers to your SalesLogix related questions.

 Home  |   Subscribe via RSS  |   Subscribe via E-mail  |   

Custom Tables and Seccodeid in SalesLogix Web

Question: We have 20+ custom tables in a highly customized SalesLogix platform.  Seccodeid has been added to all of the tables because they need to abide by field level security.  I've notice that in the Windows client that the Provider seems to take care of the initial setting of this value, but I don't find that to be the case in the Web client.  When I save data with a data bound control on a form in the Web, a record is created but it throws an error when I try to save.  I find the seccodeid value is not set when I look at the record in SQL, and setting the value fixes the problem.  How can I fix this issue?

Answer: You will need write some code for Web client.  Here is an example of code added to the OnBeforeInsert event for the custom table (AccountService in this case):

public static void OnBeforeInsertStep( IAccountService accountservice, ISession session)
{
accountservice.Owner = accountservice.Account.Owner;
}

and the following to the Account ChangeAccountOwner business rule as a Post Execute Step:

public static void ChangeAccountOwnerStep( IAccount account)
{
if (account != null)
{
foreach (IAccountService accsvc in account.AccountServices)
{
accsvc.Owner = account.Owner;
}
}
}

Hope this helps!

What's This?
  
Bookmark and Share

About SalesLogix Support

   Your SalesLogix Business Partner for SalesLogix Support.


Related Content
   Delivering Data & Schema in SalesLogix Bundles
If you've had any exposure to SalesLogix, you'll have used a bundle. Bundles are great, but when
Posted on Apr 24, 2014 by Ryan Farley to Ryan Farley's Blog
 
   Mobile 3.0.3 for Saleslogix v7.5.4, v8.0.0 & v8.1.0 is now available!
Saleslogix Mobile v3.0.3 is now available in the customer portals. This update addresses all issues int
Posted on Apr 14, 2014 by Scott Weber to SalesLogix Product Blog
 
   Editing Filters in Saleslogix Web Client 8.0
Is it possible to add or remove Saleslogix filters from the List view in Accounts?
Posted on Apr 08, 2014 by SalesLogix Support to SalesLogix Questions & Answers
 
   Bug in the Saleslogix Web LiveGrid Lookup dialog
I recently ran into an issue with the Opportunity Products grid in the Saleslogix web client.  I cli
Posted on Apr 04, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Creating a Unique Saleslogix table ID in a SQL Function
A couple of months ago Ryan Farley wrote an article about how to use a SQL stored procedure to create a S
Posted on Mar 25, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
Comments

No Comments
All contents Copyright © 2014 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register