User Control Views
Business rules may require specific functions to be disabled based on the logged in user. A User Control page can be created to manage the criteria for a User Control View. UserControl Views (UCV) are created in SQL and determine if records can be added, edited, deleted or even viewed by a specified user. Once the views are created in SQL, they need to be registered to the page in DSP® and the control criteria must be defined. A single User Control View can control multiple pages in a WebApp if designed correctly and registered to multiple pages.
Refer to Control Views for general information.
When creating User Control Views (UCV):
- Use the naming convention webXXXUcv, where XXX is the name of the table assigned to the page minus the prefix.
- If using one UCV across multiple tables, XXX is a meaningful name.
NOTE: When controlling multiple pages with a single User Control View, Enforce Strict Naming might need to be turned off depending on the naming convention on the view.
- Use a UCV when the control status determinations are to be made based on what is known about the User.
- Include the following columns:
- boaUserID – Contains DSP® User ID
- boaColumn – Technical name of column on the page
- boaControlStatus – Control Status: disabled (0), enabled (1) and hidden (2)
NOTE: Besides the DSP® Reserved Words, no other columns are considered when applying the UCV control status settings to a page.
Setting up user control views involves the following steps:
- Create a User Control View in Management Studio.
- Register the view in DSP®.
- Define the control criteria on the new page.
The following steps are optional to allow management of the control view’s functionality:
- Create a User Control table.
- Create a User Control Horizontal View to manage the criteria.
- Register the Page in DSP® and assign to the Configuration Menu.
- Create list views for the Column Properties.
- Assign Column Properties.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.