[References Dashboard] Discussion

[References Dashboard] Discussion

  
Forge Component
(5)
Published on 2011-10-20 by ovatsus
5 votes
Published on 2011-10-20 by ovatsus
Any chance of a downgrade to 5.0? 5.1 is quite new and many of us are not using it yet. :)

In the meanwhile, here's a workaround for finding references between eSpaces.  Just customize and execute the query below.


SELECT prd.name as producer, e_ref.name as reference, e_ref.kind, csn.name as consumer
FROM [ossys_Espace] prd
join ossys_Espace_Reference e_ref on prd.ss_key = e_ref.PRODUCER_SS_KEY
join ossys_Espace_Version csn_ver on e_ref.CONSUMER_VERSION_ID = csn_ver.id
join ossys_Espace csn on csn_ver.id = csn.version_id and csn.id = csn_ver.espace_id
WHERE
 prd.is_active = 1 and csn.is_active = 1
--and prd.name like '%xxx%'
and e_ref.[NAME] like 'XXX'  -- name of public action/entity/... here
--and csn.name like '%xxx%'
 
You can try this one for version 4.2.x