Skip to main content
SharePoint

Return to Question

edited tags
Source Link
user20377051
user20377051
  • 11
  • 3

We were using a sharepoint 2019 list as logging list and we moved that to SQL server. Then using BCS we are only reading the data from SQL and displaying in sharepoint using External Content Type and External list.

My question is: how can I trigger a workflow or external event receiver when the system/application creates/logs an entry in the database? We use the external list to view the data only, we don't create or update items residing in the external list. How can I notify the user when there is a change in the SQL database (table) which is used in the BCS to view the data only.

We were using a sharepoint list as logging list and we moved that to SQL server. Then using BCS we are only reading the data from SQL and displaying in sharepoint using External Content Type and External list.

My question is: how can I trigger a workflow or external event receiver when the system/application creates/logs an entry in the database? We use the external list to view the data only, we don't create or update items residing in the external list. How can I notify the user when there is a change in the SQL database (table) which is used in the BCS to view the data only.

We were using a sharepoint 2019 list as logging list and we moved that to SQL server. Then using BCS we are only reading the data from SQL and displaying in sharepoint using External Content Type and External list.

My question is: how can I trigger a workflow or external event receiver when the system/application creates/logs an entry in the database? We use the external list to view the data only, we don't create or update items residing in the external list. How can I notify the user when there is a change in the SQL database (table) which is used in the BCS to view the data only.

Source Link
user20377051
user20377051
  • 11
  • 3

BCS: get notified when data is changed in sql server?

We were using a sharepoint list as logging list and we moved that to SQL server. Then using BCS we are only reading the data from SQL and displaying in sharepoint using External Content Type and External list.

My question is: how can I trigger a workflow or external event receiver when the system/application creates/logs an entry in the database? We use the external list to view the data only, we don't create or update items residing in the external list. How can I notify the user when there is a change in the SQL database (table) which is used in the BCS to view the data only.