Regenerating views is necessary when updating data security and can be useful for certain errors, such as when a form won't open after adding or updating a custom field.
Use the form VA View Generator to "Add Unsynchronized Views" and regenerate views. You may need to run this after a Vista upgrade.
Click on "Add Unsynchronized Views" - all views that are not in sync will show up in the right window pane. If nothing shows up in the "Views to Regenerate" window then this may not be needed. If there are a few, you can click the "All" button to move the remaining views into the "Views to Regenerate" window (it does not hurt to regenerate all the views - this is really just a refresh).
Regenerating all views will impact all companies and may take a minute or so to complete.
NOTE: Use the Tools > Refresh all views... option to include custom fields.
From the Help Topics:
Use this form to regenerate views after you have adjusted datatype security settings in VA Data Security Setup. The system uses views, in conjunction with VA Data Security Access settings, to implement security on underlying database tables. Views screen out all data that a user does not have permission to access. Use this form to generate views after activating or updating datatype security.
NOTE: Views can be manually refreshed from SQL as well. The commands for this are below:
- All views: exec vspViewRefresher
- Specific view: sp_refreshview viewName
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article