In order to preserve the promise of transparency and open communication, the change log records changes to topics made by both customers and employees. Anyone can dispute a change by clicking the "Dispute" link and entering additional details.

Change inreply
by
tim cullis
to
Hi. Does this snippet from support help ?
<br /><br />
TESTING ROLES IN SQL BUSINESS RULES
<br /><br />
Developers can now access parameter @BusinessRules_UserRoles in the code of SQL Business Rules and test user roles for conditional processing.
<br /><br />
For example, create a Transact-SQL business rule in Products data controller may look as follows:
<br /><br />
if @UnitPrice &gt; 30 AND CHARINDEX('Administrators', @BusinessRules_UserRoles) = 0
<br />
set @Result_Error = 'Only admin can set a high price!'
<br />
Set Command Name of the rule to Insert|Update and Phase to Before. Run the app, login with a non-administrative account, and try to update a product with a price higher than $30.
<br /><br />
SQL business rules tests user Roles to prevent data input in an app created with Code On Time app generator.
<br /><br />
Use the corresponding “contains” function and parameter marker in front of “BusinessRules_UserRoles” when working with the database engines other than Microsoft SQL Server..
Also ...
Customer Service, Company Admin
7267 Posts 438 Reply Likes
Parameter @BusinessRules_UserName returns the value of the property BusinessRules.UserName. This is the implementation of it:
public static string UserName
{
\ get
{
return System.Web.HttpContext.Current.User.Identity.Name;
\ }
}
.