Skip to main content
J
jansij055677
July 19, 2022
Question

Reg Record Data Sync of Database View

  • July 19, 2022
  • 7 replies
  • 0 views

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.

    7 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    July 19, 2022

    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?

    peter.lewis
    peter.lewis
    Employee
    July 19, 2022

    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.

    J
    jansij055677Author
    July 19, 2022

    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.

    Terms & ConditionsAccessibility statement