Skip to main content
S
shubhamy0001
September 30, 2021
Question

How to update grid?

  • September 30, 2021
  • 7 replies
  • 0 views

Hi Everyone,

I have created an interface which have grid rows. The fileds are populated from two tables, so I have created a view for that. What I need to implement that if a record is entered into one table, the corresponding fields from other table needs to be updated. Can anyone please suggest any solution for this?

Thank You 

    7 replies

    richardm900458
    richardm900458
    September 30, 2021

    I am not 100% sure if I understand your issue correctly.
    you have already your view and you can display this view via datastore-cdt-queryRule-interface-table logic.
    So if you update one table (as part of the DB SQL view) , your view CDT content is automatically updated as well.
    Thats the main idea of DB views. Can you elaborate your question?

    S
    shubhamy0001Author
    September 30, 2021

    Yes, that is correct. So the main concept is the view includes two DB tables. And my query is if one DB table is updated then the related second tables should be updated to some default values.

    csteward
    csteward
    September 30, 2021

    This will have to occur where your record is entered into table 1, or via a trigger on the DB table (although preference is always to achieve within Appian when possible).  How is your record entered?

    Terms & ConditionsAccessibility statement