I am trying to let users create rules so that they can define simple workflows via Dynamic Permissions.
When the user creates a rule that UserGroup WidgetAdmins can access Widgets in Status "New", I will need to create a view like "Select * from Widgets where status='New'" so that I can set the Access Control/Dynamic Permissions for that View and Rule or enable the user to do so.
Anyone have ideas as to how/whether this can be done?
Any other requirements for creating views programmatically within an application?
