If all module level the information stored in Espace, Espace_Reference and Espace_Version System Entity. Then how I can join the entity to get the all-consumer module for individual module if this module consuming different applications module, need that one also. Please help me to create the query.Thanks
Hi @Jivendra Kumar ,
You can check the below post for reference:
https://www.outsystems.com/forums/discussion/57270/how-to-get-the-applicationname-of-a-producer-from-espace-reference-entity/
regards,
Manish Jawla
You can get the consumer modules of a given module by joining Espace with Espace_Reference like this:
select distinct Consumer.Name as ConsumerModule,
Provider.Name as ProviderModule
from Espace_Reference R
join Espace Consumer on R.Espace_Id = Consumer.Id
join Espace Provider on R.Referenced_Espace_Id = Provide
r.Id
This will return each module (Consumer) and the modules it consumes (Provider), even if they belong to different applications. If you also need version info, you can join Espace_Version on Espace.Id.