Changes to the question

Method [company].Rules.SharedBusinessRules.UserRoles not found

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.


  • November 18, 2019 22:31
    tim cullis
    Change in reply 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; \ } } .

See all changes made to topics in this company