Just checked the same schema in 4.8 and this doesn't work!
Getting SQL errors:
do_query error: SELECT count(*) FROM "aquariki"."public"."asset" LEFT OUTER JOIN "aquariki"."public"."asset_in_asset" ON "asset"."code" = "asset_in_asset"."parent_asset_code" LEFT OUTER JOIN "aquariki"."public"."asset" ON "asset_in_asset"."parent_asset_code" = "asset"."code" WHERE ("asset"."s_status" != \'retired\' or "asset"."s_status" is NULL) AND ("asset"."s_status" != \'retired\' or "asset"."s_status" is NULL)
Note here i am not making any query for asset_in_asset, my TEL looks like this @SOBJECT(tvs/asset_in_episode['episode_code', 'EPISODE00002'].tvs/asset)
Project named "aquarki"
Adding this to schema - breaks any relationship query in TACTIC, causing wrong results.
<connect from="tvs/asset" to="tvs/asset" instance_type="tvs/asset_in_asset" relationship="instance"/>
Getting SQL errors:
do_query error: SELECT count(*) FROM "aquariki"."public"."asset" LEFT OUTER JOIN "aquariki"."public"."asset_in_asset" ON "asset"."code" = "asset_in_asset"."parent_asset_code" LEFT OUTER JOIN "aquariki"."public"."asset" ON "asset_in_asset"."parent_asset_code" = "asset"."code" WHERE ("asset"."s_status" != \'retired\' or "asset"."s_status" is NULL) AND ("asset"."s_status" != \'retired\' or "asset"."s_status" is NULL)
Note here i am not making any query for asset_in_asset, my TEL looks like this @SOBJECT(tvs/asset_in_episode['episode_code', 'EPISODE00002'].tvs/asset)
Project named "aquarki"
Adding this to schema - breaks any relationship query in TACTIC, causing wrong results.
<connect from="tvs/asset" to="tvs/asset" instance_type="tvs/asset_in_asset" relationship="instance"/>