I have created a custom list with a field (column) of 'External Data' type, connected to my external content type. External Content Type's source is an SQL view. My problem is, when I make changes on the database, I would like the column in my sharepoint list to update as well, unfortunately this does not happen (well it does, when I click 'edit item' and 'save', but this would be a bit uncomfortable with a lot of data ;). Is it possible to get the data 'auto-refresh' on database change? I would appreciate any help.
lwbecker2
- 1.5k
- 1
- 9
- 23