Hi,
I have created one SharePoint list Colum’s are
Approver Name & sequence.
I want used this list as destination group so I had created SO for this list but I found that records are fetch randomly. since there is no way to arrange the approvers in sequence using sequence column of the list. I had write SharePoint Event wizard and trigger workflow which save data in SQL table. I had created the store procedure which checked if the List ID is present it update the data else add new records in sql table.
Now my problem is that suppose any one deleted the columns from SharePoint list. How I can find out that and deleted the records in SQL table. I had checked the ItemDeleted option in my SharePoint event wizard.. Is there any way so I can find out that Item Deleted method is called and I can delete that records from SQL table.
Thanks in advance.