Materialised Views

Hi All,

Can we use Materialised views in APpian and if so how to query the data from Appian side.

  Discussion posts and replies are publicly visible

Parents Reply
  • Whilst this is literally true, you could take a couple of different approaches to achieve the same sort of thing. If you think of a materialised view as a physical table that holds the results of the SQL that a VIEW would normally be constructed from, you could:

    1. run a scheduler that periodically empties and then re-loads a table with the data that you want
    2. add triggers to the relevant table(s) to manage the content of another table that would act like a materialised view

    Both approaches have pros and cons.

Children
No Data