Return PM output when using startProcess in an expression rule instead of "Smart Service"

Thank you Stefan Helzle and rohito0002. My requirement is to update data on the UI based on a certain type of insert into a db table. So the basic flow is, db table gets updated, refreshVariable grabs updates from the table, triggers a PM to update local variables according to the db update. 

I'm no expert appian developer so this is a POC at the moment. I will try out this suggested solution.

Thank you Stefan Helzle and rohito0002. My requirement is to update data on the UI based on a certain type of insert into a db table. So the basic flow is, db table gets updated, refreshVariable grabs updates from the table, triggers a PM to update local variables according to the db update. 

I'm no expert appian developer so this is a POC at the moment. I will try out this suggested solution.

My main question is: how is the initial database table update happening? Is it occurring through an Appian process or an external system or is it triggered based on some user action on the interface? If it's occurring through an Appian process, I'd recommend just having any additional changes also happen in that process. If the database is updated outside of Appian, you could also have database triggers that are kicked off based on an initial insert into the table.

Here's how I usually like to think about it:

• If you want something in the interface to refresh based on a user action, then use the action (e.g. button click) to also update whatever else you want.
• If you want the interface to passively view some change in an external system, then try to set up all of the processing outside of the interface (i.e. through a process model or database trigger).