Lets say you have SQL View that join multiple tables
If you generate a SmartObject from this view, it will only have a “List” method
So if you try to generate a view, only the List View is available as the CRUD (Create, Read, Update, Delete) methods do not exist. But what if you want to interact with the information in this view, allowing users to edit/update columns?
This can be done by creating your own stored procedures that would (Create, Read, Update, Delete) with the columns in this View; of course, through interacting with the actual tables with the necessary joins, etc.
Lets say you want to update the columns that had been NULL
A stored proc to update can be created (no joins for simplicity)
Refresh SQL service instance to expose this object
Add this method to the View Smartobject
Change the Type to Update, or to whichever Type that matches the stored proc’s function
Map the properties accordingly
Now when generate a view, the Editable List View is available
The Save/Update functionality of an Editable List View is now available; the same can be achieve to Create, Read, Delete