self to self relationship

[Diego]

Hi,
Last time I tried Many to many on the same sType is handled through collections.

It uses the parent_asset_code and child_asset_code columns


<connect from="prj/asset_in_asset" to="prj/asset" relationship="code" from_col="parent_asset_code" to_col="code"/>
<connect from="prj/asset_in_asset" to="prj/asset" relationship="code" from_col="child_asset_code" to_col="code"/>


You should select "support collections" when creating the sType, or simply add a boolean custom column called "_is_collection" if the sType was already created.
Then create your asset_in_asset sType with the parent_asset_code and child_asset_code columns and edit your schema accordingly.

I'm not sure this is still supported!