Here are the steps to execute the automatic refresh on the embedded list:
- Right-click on the created embedded list and choose properties
- under "General" tab click "Pick Action"
- select "Script and press next
- select Mode "Execute Code Fragmentation on Top-Level Mimic" and write the code as follows Mimic.Layers(0).Item("Lst_2").Sql = Mimic.Layers(0).Item("Lst_2").Sql
- select Next then Finish.
Once configured, save the mimic and put it into runtime mode. If you left-click on the list, the query will update and the list will refresh automatically with the newest results displayed.