Hi All,
I am using a record to show the data in read only grid along with selection.
I have to use a database view as a source for record,along with user filters,export to excel functionalities and search box.
Since it is a view,I am unable to do the Data sync.But it lands in a performance issue as it takes more time to load.
Is it possible to do Data sync for a view?
Thanks in advance.
Discussion posts and replies are publicly visible
Data sync on views is not possible. If the view is slow, you will have to analyze the execution plan and modify it.
Could you replicate the view logic with Synced records?
Agreed with Stefan - can you give more context on what your database view is doing? You can usually define similar logic using record relationships and custom record fields.
Thanks Stefan and Lewis for your response!!
My scenario is like we have to show the list of data from a record view to the user in front end in the UI by using a grid with the flexibility of selection,export excel,user filters everything.
If the user selects 2 rows among the list of available rows,then we write those selected row data in our table.
For example,the view contains the list of contracts data which is present in another schema tables.We are creating a view in our schema from those tables.
Our requirement is like the user have to select the data from the list available in view and have to proceed further.
Does this mean that this view is predefined and you do not have the power to go a different way?
Yes correct
OK. Then you still need to solve that performance issue in that view. I my experience, views are notorious for being slow or becoming slower over time.
Now, would it be an option to create a stored procedure which copies that data into a table? This would help in terms of speed and allow you to use a synced record.
Okay,we will try this out.Thank you so much for providing an alternate way.