Support #13769
[SCP ID :##6881##] : Issue Mandate Notif Message - RppContentCategory
| Status: | Closed - End of life cycle | Start date: | December 06, 2023 | |
|---|---|---|---|---|
| Priority: | High | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | - | Spent time: | 2.00 hours | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
Based on our discussion today, we found some issue related Mandate Notif Message.
1st we can delete / remove ContentCategory without deleted subcategory via backoffice use administrator account
according your latest information, can not delete from UI backoffice.
PFA : Admin1.log
capture menu we deleted from UI
Please support us.
History
#1
Updated by Ngoh Chee Ping 10 months ago
- Status changed from New - Begin Life Cycle to Finished Development
- Assignee changed from Bramantyo Pujo Wiyono to Ngoh Chee Ping
- % Done changed from 0 to 100
Root Cause:
This issue is due to no checking on the content category is having records before delete the content category. Therefore, the mandate notif message data still tie to the deleted content category.
Solution:
1) Use query below to delete the mandate notif message data that having problem.
delete from mandate_notif_message where content_category_id <> (select oid from rpp_content_category where rpp_content_category.content_type_id = 7);
2) Add the checking on delete content category function to check is there any mandate notif message data tie to this content category. If yes, will throw error message and block user from deleting the content category. We will provide the patch for this fix later.
Patch provided: https://penrilsb-my.sharepoint.com/:f:/g/personal/haida_md_penril_net/EtzdVAx_YtVDujGRzD4qzLoBDLWDLuz9hibfrVMuvX1b6w
#2
Updated by Ngoh Chee Ping 10 months ago
- Status changed from Finished Development to Pending Customer Feedback
- Assignee changed from Ngoh Chee Ping to Zahir Abd Latif
Patch already provided, pending ptap team action to test it.
#3
Updated by Zahir Abd Latif 9 months ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Issue closed in SCP.