how to update a custom view after main table changes

This topic is locked

how to update a custom view after main table changes	10/2/2022 6:50:34 PM
PHPRunner General questions
W wfcentral author Is it possible to update a custom view to add a new field that is required. Below is just a simplified example of what I'm trying to do. main table = rosters fields = id, name, date, course I made a custom view of that table called "rosters2" fields = id, name, date, course Now my client has asked that the field "email" be available in rosters and rosters2 (list, add, edit pages). I don't want to redo the custom view from scratch as it has many things in designer that are done. The only way I see to add this new field to rosters2 is to use join statements in the SQL query to basically join the custom view BACK to it's original source table "rosters".


	Sergey Kornilov admin 10/2/2022
	Once you create a custom view it becomes an independent entity and no changes made to the main table are applied to the custom view. I guess you simply need to modify the SQL query of the Custom View and then make that new field appears on required pages.