Present Scenario, A custom page where complaints being logged by any authenticated users are added as items to a SharePoint lists. Whenever new complaints are logged a unique reference number gets generated and the new item will get added in the one of the SharePoint lists. Each item has few columns like, the category of the complaint type, mode, and products related to the complaints, customer basic details. A workflow process runs behind the scene and stops when the manager approves the task. Currently what has to be done; There may be situation where the bulk complaints have to be managed. For ex: for an ATM Machine issue, the customers are logging the compliant simultaneously from different regions to the bank. Since the issue is same, it should fall under same bulk complaint category. But bank compliant loggers of different branches are not aware of another logger who is logging the same issue, since the issue is similar, the related ATM problem should be tagged under bulk complaint category and work flow stops when any one of the similar complaint is resolved. There are two scenarios in which the complaint will be locked as bulk ones. 1. Two users are logging the complaint from different locations at the same time, if the complaint type is of same category with common issues, then both the complaints should be tagged under bulk complaint category. 2. If already few complaints are logged under bulk complaint category and a new complaint while logging has found is of similar issue like already existing bulk complaint then the new complaint should go into that category.
Can anyone please suggest me how could i get it done
Regards
PRC