SQL to delete data in JSON
Posted by: Ra Nala
Date: March 08, 2019 09:33AM
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": []}}
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": []}}
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
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.