Bitbucket Post Webhook FAQs

Bitbucket Post Webhook Frequently Asked Questions

Frequently Asked Questions

You can find Bitbucket Post Webhook Frequently Asked Questions here.

How to delete duplicates?

You can use the following query to delete the duplicates of the notification rules. dbms_lob.compare is used to compare the blob content.

CODE

SELECT DISTINCT t1.id FROM AO_4F04F4_MWF_PLUGIN_SETTINGS t1, AO_4F04F4_MWF_PLUGIN_SETTINGS t2
WHERE 
    t1.id > t2.id AND 
    t1.tag = t2.tag and
    t1.type = 'NOTIFICATION' and 
    dbms_lob.compare(t1.content, t2.content) = 0;

Updated: 09 Apr 2023