Examples for DELETE

Attempted Import on the repository for record A and D. The data file used in the data source for the import is as follows:

ID,Ext,ShortDesc,Contains

A,A,A,"B:B::21:DELETE,D:D::21"

D,D,D,

Result: Record A has the following hierarchy remaining.

A (contains)

|

|__D

Note: A new relationship with record D is created, while those of all old relationships are lost. As you delete relationship of record A with record B for relationship type 21, the relationship with record B is deleted. At the same time, you are adding a relationship with record D for relationship type 21, which overwrites the previous relationship of record A with record C. That is, A contains C.

Attempted Import on the repository for record A. The data file used in the data source for the import is as follows:

ID,Ext,ShortDesc,Contains

A,A,A,"B:B::21:DELETE,B:B::21"

Result: Record ‘A’ has the following hierarchy remaining.

A (contains)

|

|__C

Note: Relationship with record B is deleted even though an attempt was made to add the relationship for the same record. This is because DELETE takes precedence.

Attempted Import on the repository for record A and D. The data file used in the data source for the import is as follows:

ID,Ext,ShortDesc,Contains

A,A,A,"B:B::21:DELETE,B:B::21,D:D::21"

D,D,D,

Result: Record ‘A’ has the following hierarchy remaining:

A (contains)

|

|__D

Note: Relationship with record B is deleted even though an attempt was made to add the relationship for the same record. This is because DELETE takes precedence.

Also, a new relationship with record D is created, while that of all old relationships is lost. As you delete relationship of record A with record B for relationship type 21, the relationship with record B is deleted. At the same time, you add a relationship with record D for relationship type 21, which overwrites the previous relationship of record A with record C. That is, A contains C.