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
Yes, you can. You define your CDT just like you would for a regular view or table.
IS this possible in MY SQL (Appian Cloud)?
MySQL doesn't have materialized views. Nothing to do with Appian or Appian Cloud.
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:
Both approaches have pros and cons.