Delete Connectors autonomouslyDelete Connectors autonomouslyRE: Delete Connectors autonomouslyMehmet Albayrakhttps://www.adoxx.org/live/c/message_boards/find_message?p_l_id=&messageId=3293662015-07-02T06:18:17Z2015-06-24T06:57:26ZDear Fadi,<br />Thank you for your question. For deleting connectors with the command DELETE_CONNECTOR you need the id of the connector (1) or the source-object-id and the target-object-id (2). Below you can find an example for the both scenarios.<br /><br />1) Delete connectors with relation-id<br /><br /><div class="code"><span class="code-lines"> 1</span>ON_EVENT "AfterEditAttributeValue" {<br /><span class="code-lines"> 2</span>SET id_ModelId: (modelid)<br /><span class="code-lines"> 3</span>SET id_InstId: (instid)<br /><span class="code-lines"> 4</span>SET id_AttrId: (attrid)<br /><span class="code-lines"> 5</span><br /><span class="code-lines"> 6</span>CC "Core" GET_CLASS_ID classname:"A"<br /><span class="code-lines"> 7</span>CC "Core" GET_ATTR_ID classid: (classid) attrname:"Table"<br /><span class="code-lines"> 8</span>SET nTableAttrId: (attrid)<br /><span class="code-lines"> 9</span><br /><span class="code-lines">10</span>#Trigger Event if attribute "Table" is editted<br /><span class="code-lines">11</span> IF (nTableAttrId=id_AttrId) {<br /><span class="code-lines">12</span> CC "Core" GET_OBJ_NAME objid: (id_InstId)<br /><span class="code-lines">13</span> SET sObjName: (objname) <br /><span class="code-lines">14</span><br /><span class="code-lines">15</span>#Query the relation ids of the outgoing "RelatedTo"-relations from the current instance<br /><span class="code-lines">16</span> CC "AQL" EVAL_AQL_EXPRESSION expr: ("{\"" + sObjName + "\"} -> <\"RelatedTo\">" ) modelid: (id_ModelId)<br /><span class="code-lines">17</span> SET s_RelationIds: (objids)<br /><span class="code-lines">18</span><br /><span class="code-lines">19</span>#Delete "RelatedTo"-relations which are outgoing from the current object <br /><span class="code-lines">20</span> FOR i in: (s_RelationIds) {<br /><span class="code-lines">21</span> CC "Core" DELETE_CONNECTOR modelid: (id_ModelId) objid: (VAL i)<br /><span class="code-lines">22</span> }<br /><span class="code-lines">23</span> }<br /><span class="code-lines">24</span>}<br /></div><br /><br />2) Delete Connectors with from-object-id and to-object-id<br /><br /><div class="code"><span class="code-lines"> 1</span>ON_EVENT "AfterEditAttributeValue" {<br /><span class="code-lines"> 2</span>SET id_ModelId: (modelid)<br /><span class="code-lines"> 3</span>SET id_InstId: (instid)<br /><span class="code-lines"> 4</span>SET id_AttrId: (attrid)<br /><span class="code-lines"> 5</span><br /><span class="code-lines"> 6</span>CC "Core" GET_CLASS_ID classname:"A"<br /><span class="code-lines"> 7</span>CC "Core" GET_ATTR_ID classid: (classid) attrname:"Table"<br /><span class="code-lines"> 8</span>SET nTableAttrId: (attrid)<br /><span class="code-lines"> 9</span><br /><span class="code-lines">10</span>#Trigger Event if attribute "Table" is editted<br /><span class="code-lines">11</span> IF (nTableAttrId=id_AttrId) { <br /><span class="code-lines">12</span> CC "Core" GET_CLASS_ID relation classname:"RelatedTo"<br /><span class="code-lines">13</span> SET nRelatedToClassId: (classid)<br /><span class="code-lines">14</span> CC "Core" GET_OBJ_NAME objid: (id_InstId)<br /><span class="code-lines">15</span> SET sObjName: (objname)<br /><span class="code-lines">16</span><br /><span class="code-lines">17</span>#Query the target objects of the current instance<br /><span class="code-lines">18</span> CC "AQL" EVAL_AQL_EXPRESSION expr: ("{\"" + sObjName + "\"} -> \"RelatedTo\"" ) modelid: (id_ModelId)<br /><span class="code-lines">19</span> SET s_RelationIds: (objids)<br /><span class="code-lines">20</span><br /><span class="code-lines">21</span>#Delete "RelatedTo"-relations which are outgoing from the current object <br /><span class="code-lines">22</span> FOR i in: (s_RelationIds) {<br /><span class="code-lines">23</span> CC "Core" DELETE_CONNECTOR modelid: (id_ModelId) fromobjid: (id_InstId) toobjid: (VAL i) classid: (nRelatedToClassId)}<br /><span class="code-lines">24</span> }<br /><span class="code-lines">25</span> }<br /><span class="code-lines">26</span>}<br /></div>Mehmet Albayrak2015-06-24T06:57:26ZDelete Connectors autonomouslyFadi Al Machothttps://www.adoxx.org/live/c/message_boards/find_message?p_l_id=&messageId=3289092015-06-23T17:59:28Z2015-06-23T17:09:44ZWould you please post an example, how to delete a specific connector (relation) of type "Is-A" after the eventĀ "AfterEditAttributeValue".<br />The problem is how to use DELETE_CONNECTOR ConnectorID | FromToIDs!Fadi Al Machot2015-06-23T17:09:44Z