To create a role, follow these steps:
- Choose to add a new item to the project.
- In the Add New Item dialog, select Data Model from the left-hand list and Query from the right.
- Enter ConVMSVehicleTruckPolicy in the Name field and click on Add.
- In our new query, drag the ConVMSVehicleTable table to the Data Sources node.
- Set the Dynamic Fields property to No and then add the VehicleType field to the Fields list by right-clicking on the Fields node and choosing New | Field.
- Drag the field onto the Ranges node.
- On the new VehicleType range, change the Value property to Truck.
When deployed, this will be updated for us. We can also use the enum's value as the type is not extensible.
- Save and close the query designer.
- In the