MySQL Forums
Forum List  »  InnoDB

SQL to delete data in JSON
Posted by: Ra Nala
Date: March 08, 2019 09:33AM

Hi,

Could you please how to delete data from JSON. below is the sample JSON data which I want to delete.

Example: in this data, what is the delete sql to delete record related to $.bomItemToParts[14].comments[0].comments



{"attachments": [{"id": 1, "url": "TB260B_Q1B150_1_1549188681889.png", "name": "TB260B_Q1B150_1.png", "type": "PartsCatalog", "entityId": 45580, "versions": [], "createdBy": 2, "updatedBy": 2, "entityName": "BomItem", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User", "attachmentInfos": [{"reasons": [], "x1Cords": 2183, "x2Cords": 2223, "y1Cords": 1034, "y2Cords": 1074, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2183;1034;2223;1074", "extensionList": [], "itemReference": "12", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2147, "x2Cords": 2187, "y1Cords": 950, "y2Cords": 990, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2147;950;2187;990", "extensionList": [], "itemReference": "13", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1174, "x2Cords": 1214, "y1Cords": 1008, "y2Cords": 1048, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1174;1008;1214;1048", "extensionList": [], "itemReference": "9", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2149, "x2Cords": 2189, "y1Cords": 828, "y2Cords": 868, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2149;828;2189;868", "extensionList": [], "itemReference": "6", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1078, "x2Cords": 1118, "y1Cords": 824, "y2Cords": 864, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1078;824;1118;864", "extensionList": [], "itemReference": "8", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2144, "x2Cords": 2184, "y1Cords": 892, "y2Cords": 932, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2144;892;2184;932", "extensionList": [], "itemReference": "14", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2143, "x2Cords": 2183, "y1Cords": 621, "y2Cords": 661, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2143;621;2183;661", "extensionList": [], "itemReference": "3", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2143, "x2Cords": 2183, "y1Cords": 489, "y2Cords": 529, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2143;489;2183;529", "extensionList": [], "itemReference": "2", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1232, "x2Cords": 1272, "y1Cords": 972, "y2Cords": 1012, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1232;972;1272;1012", "extensionList": [], "itemReference": "11", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1881, "x2Cords": 1921, "y1Cords": 289, "y2Cords": 329, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1881;289;1921;329", "extensionList": [], "itemReference": "1", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1414, "x2Cords": 1454, "y1Cords": 970, "y2Cords": 1010, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1414;970;1454;1010", "extensionList": [], "itemReference": "11", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2339, "x2Cords": 2379, "y1Cords": 1528, "y2Cords": 1568, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2339;1528;2379;1568", "extensionList": [], "itemReference": "6", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1945, "x2Cords": 1985, "y1Cords": 572, "y2Cords": 612, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1945;572;1985;612", "extensionList": [], "itemReference": "7", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1033, "x2Cords": 1073, "y1Cords": 620, "y2Cords": 660, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1033;620;1073;660", "extensionList": [], "itemReference": "11", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1348, "x2Cords": 1388, "y1Cords": 1017, "y2Cords": 1057, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1348;1017;1388;1057", "extensionList": [], "itemReference": "4", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2076, "x2Cords": 2116, "y1Cords": 733, "y2Cords": 773, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2076;733;2116;773", "extensionList": [], "itemReference": "5", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2339, "x2Cords": 2379, "y1Cords": 1692, "y2Cords": 1732, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2339;1692;2379;1732", "extensionList": [], "itemReference": "12", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 952, "x2Cords": 992, "y1Cords": 674, "y2Cords": 714, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "952;674;992;714", "extensionList": [], "itemReference": "4", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1112, "x2Cords": 1152, "y1Cords": 1046, "y2Cords": 1086, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1112;1046;1152;1086", "extensionList": [], "itemReference": "10", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2111, "x2Cords": 2151, "y1Cords": 1594, "y2Cords": 1634, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2111;1594;2151;1634", "extensionList": [], "itemReference": "5", "manulHotspotUpdated": false}], "manualHotspotInfos": []}], "latestComment": {"id": 3, "comments": "a", "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, "bomItemToParts": [{"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442857, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442858, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442859, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442860, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442861, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442862, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"comments": [{"id": 1, "comments": "a", "entityId": 442863, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 08:41:04", "updatedDate": "02-03-2019 08:41:04", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 2, "comments": "a", "entityId": 442863, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 09:59:40", "updatedDate": "02-03-2019 09:59:40", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 3, "comments": "a", "entityId": 442863, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}], "extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442863, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn01Code": "126100003~126102093", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}, "latestComment": {"id": 3, "comments": "a", "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}}, {"comments": [{"id": 1, "comments": "A", "entityId": 442864, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 08:41:04", "updatedDate": "02-03-2019 08:41:04", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 2, "comments": "A", "entityId": 442864, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 09:59:40", "updatedDate": "02-03-2019 09:59:40", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 3, "comments": "A", "entityId": 442864, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}], "extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442864, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn01Code": "126102094~", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}, "latestComment": {"id": 3, "comments": "A", "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442865, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442866, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"comments": [{"id": 1, "comments": "with shut-off valve", "entityId": 442867, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 08:41:04", "updatedDate": "02-03-2019 08:41:04", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 2, "comments": "with shut-off valve", "entityId": 442867, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 09:59:40", "updatedDate": "02-03-2019 09:59:40", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 3, "comments": "with shut-off valve", "entityId": 442867, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}], "extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442867, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}, "latestComment": {"id": 3, "comments": "with shut-off valve", "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}}, {"comments": [{"id": 1, "comments": "A", "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 08:41:04", "updatedDate": "02-03-2019 08:41:04", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 2, "comments": "a", "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 08:41:04", "updatedDate": "02-03-2019 08:41:04", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 3, "comments": "A", "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 08:41:04", "updatedDate": "02-03-2019 08:41:04", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 4, "comments": "A", "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 09:59:40", "updatedDate": "02-03-2019 09:59:40", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 5, "comments": "a", "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 09:59:40", "updatedDate": "02-03-2019 09:59:40", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 6, "comments": "A", "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 09:59:40", "updatedDate": "02-03-2019 09:59:40", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 7, "comments": "A", "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 8, "comments": "a", "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 9, "comments": "A", "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}], "extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442868, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn01Code": "126102094~", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}, "latestComment": {"id": 9, "comments": "A", "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}}, {"comments": [{"id": 1, "comments": "A", "entityId": 442869, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 08:41:04", "updatedDate": "02-03-2019 08:41:04", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 2, "comments": "A", "entityId": 442869, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 09:59:40", "updatedDate": "02-03-2019 09:59:40", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 3, "comments": "A", "entityId": 442869, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}], "extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442869, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn01Code": "126102094~", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}, "latestComment": {"id": 3, "comments": "A", "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}}, {"comments": [{"id": 1, "comments": "a", "entityId": 442870, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 08:41:04", "updatedDate": "02-03-2019 08:41:04", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 2, "comments": "a", "entityId": 442870, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 09:59:40", "updatedDate": "02-03-2019 09:59:40", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 3, "comments": "a", "entityId": 442870, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}], "extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442870, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn01Code": "126100003~126102093", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}, "latestComment": {"id": 3, "comments": "a", "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}}, {"comments": [{"id": 1, "comments": "A", "entityId": 442871, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 08:41:04", "updatedDate": "02-03-2019 08:41:04", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 2, "comments": "A", "entityId": 442871, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 09:59:40", "updatedDate": "02-03-2019 09:59:40", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}, {"id": 3, "comments": "A", "entityId": 442871, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}], "extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442871, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn01Code": "126102094~", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}, "latestComment": {"id": 3, "comments": "A", "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "commentType": "Serial", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442872, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442873, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}, {"extension": {"id": 1, "reasons": [], "comments": [], "entityId": 442874, "createdBy": 2, "updatedBy": 2, "entityName": "BomItemToPart", "extn02Code": "TB260B_Q1B150_1.svg", "attachments": [], "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "createdByUser": "Migration User", "extensionList": [], "updatedByUser": "Migration User"}}], "latestAttachment": {"id": 1, "url": "TB260B_Q1B150_1_1549188681889.png", "name": "TB260B_Q1B150_1.png", "type": "PartsCatalog", "entityId": 45580, "versions": [], "createdBy": 2, "updatedBy": 2, "entityName": "BomItem", "createdDate": "02-03-2019 10:11:23", "updatedDate": "02-03-2019 10:11:23", "shareDetails": [], "accessDetails": [], "createdByUser": "Migration User", "updatedByUser": "Migration User", "attachmentInfos": [{"reasons": [], "x1Cords": 2183, "x2Cords": 2223, "y1Cords": 1034, "y2Cords": 1074, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2183;1034;2223;1074", "extensionList": [], "itemReference": "12", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2147, "x2Cords": 2187, "y1Cords": 950, "y2Cords": 990, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2147;950;2187;990", "extensionList": [], "itemReference": "13", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1174, "x2Cords": 1214, "y1Cords": 1008, "y2Cords": 1048, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1174;1008;1214;1048", "extensionList": [], "itemReference": "9", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2149, "x2Cords": 2189, "y1Cords": 828, "y2Cords": 868, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2149;828;2189;868", "extensionList": [], "itemReference": "6", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1078, "x2Cords": 1118, "y1Cords": 824, "y2Cords": 864, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1078;824;1118;864", "extensionList": [], "itemReference": "8", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2144, "x2Cords": 2184, "y1Cords": 892, "y2Cords": 932, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2144;892;2184;932", "extensionList": [], "itemReference": "14", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2143, "x2Cords": 2183, "y1Cords": 621, "y2Cords": 661, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2143;621;2183;661", "extensionList": [], "itemReference": "3", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2143, "x2Cords": 2183, "y1Cords": 489, "y2Cords": 529, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2143;489;2183;529", "extensionList": [], "itemReference": "2", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1232, "x2Cords": 1272, "y1Cords": 972, "y2Cords": 1012, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1232;972;1272;1012", "extensionList": [], "itemReference": "11", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1881, "x2Cords": 1921, "y1Cords": 289, "y2Cords": 329, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1881;289;1921;329", "extensionList": [], "itemReference": "1", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1414, "x2Cords": 1454, "y1Cords": 970, "y2Cords": 1010, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1414;970;1454;1010", "extensionList": [], "itemReference": "11", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2339, "x2Cords": 2379, "y1Cords": 1528, "y2Cords": 1568, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2339;1528;2379;1568", "extensionList": [], "itemReference": "6", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1945, "x2Cords": 1985, "y1Cords": 572, "y2Cords": 612, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1945;572;1985;612", "extensionList": [], "itemReference": "7", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1033, "x2Cords": 1073, "y1Cords": 620, "y2Cords": 660, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1033;620;1073;660", "extensionList": [], "itemReference": "11", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1348, "x2Cords": 1388, "y1Cords": 1017, "y2Cords": 1057, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1348;1017;1388;1057", "extensionList": [], "itemReference": "4", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2076, "x2Cords": 2116, "y1Cords": 733, "y2Cords": 773, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2076;733;2116;773", "extensionList": [], "itemReference": "5", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2339, "x2Cords": 2379, "y1Cords": 1692, "y2Cords": 1732, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2339;1692;2379;1732", "extensionList": [], "itemReference": "12", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 952, "x2Cords": 992, "y1Cords": 674, "y2Cords": 714, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "952;674;992;714", "extensionList": [], "itemReference": "4", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 1112, "x2Cords": 1152, "y1Cords": 1046, "y2Cords": 1086, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "1112;1046;1152;1086", "extensionList": [], "itemReference": "10", "manulHotspotUpdated": false}, {"reasons": [], "x1Cords": 2111, "x2Cords": 2151, "y1Cords": 1594, "y2Cords": 1634, "comments": [], "attachments": [], "manulHotspot": false, "positionInfo": "2111;1594;2151;1634", "extensionList": [], "itemReference": "5", "manulHotspotUpdated": false}], "manualHotspotInfos": []}}

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL to delete data in JSON
49
March 08, 2019 09:33AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.