--- title: "Data Control Views" slug: "data-control-views" updated: 2024-03-26T16:54:35Z published: 2024-03-26T16:54:35Z canonical: "skthelp.syniti.com/data-control-views" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Data Control Views Data Control Views Data Control Views are created in SQL Server and define control based on what is known about the data on the page. Unlike a PCV, which defines the same control for every record in a column, a DCV contains instructions that individually set the control status of each record in a column. For example, a DCV could be used to determine if a record can be edited or deleted, or if buttons are disabled based on the state of the record. Refer to [Control Views](/v1/docs/control-views) for general information. Setting up a DCV involves the following steps: 1. [Create the Data Control View.](/v1/docs/data-control-views#create-the-data-control-view) 2. [Register the Data Control View.](/v1/docs/data-control-views#register-the-data-control-view) ## Create the Data Control View DCVs are created in SQL Server. Use the following guidelines, which assume basic knowledge of the Syniti Construct methodology and SQL Server, to create a DCV: - Use the naming convention **web*Dcv**, where * contains the name of the table registered to the page. - Include all key and criteria columns on the page to control. - Include all column names for the technical names of the columns on the page that contain the control status values (0 = Disable, 1 = Enable, 2 = Hide). - Prefix the column containing the control status with "boaCtl" when assigning a control status to a key column. ## Register the Data Control View To register the DCV to a page in the Syniti Construct: 1. Select **Admin > WebApps** in the *Navigation* pane. 2. Click the **Pages** icon for the desired WEB APP NAME. 3. Click **Vertical View** for the page DESCRIPTION. 4. Click **Control Views** tab. 5. Click **Edit**. 6. Select the SQL view from the **Data Control View** list box. 7. Click **Save**. ## Example of a Data Control View In the following example, a DCV is used to disable the Product History and Order ID icons on the *Customers* page when the count on the linked pages is zero. ### SQL View ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/9acb8eac-cc2a-4bfa-be8c-d747f623d516.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=Ab%2Bb2hN%2Fe0mJLWJVNkMtp2zx2%2BqPMQRvXcX7z08esvI%3D) > [!NOTE] > Note > > In order to control a KEY column, preface the name of the KEY column that is being controlled with "boactl." For example, ```plaintext SELECT CustomerID, 1 as boaCtlCustomerID FROM Customer ``` In the above SQL, the CustomerID column is the Primary Key of the table and the values in the boaCtlCustomerID column are used by the Syniti Construct framework to control the display and editaibilty of the field on the WebApp page. ### Syniti Construct Page ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/a5d33c0c-6628-4f50-82d6-e3680f463a86.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A02Z&se=2026-11-17T20%3A21%3A02Z&sr=b&sp=r&sig=KY0J7jB%2BQK9cQc%2BGptvkjwK2MuSe57Vqci%2BbA4x1vXc%3D)