How to get the "ApplicationName" of a Producer from "Espace_Reference" Entity?

Hi,


I'm consuming Outsystems System Entity "Espace_Reference", In this entity there's a field called "Producer_Name". Does anyone have an idea how to get the "ApplicationName" where this Producer (Espace) belongs?


Thank you,

Lanz


Hi Lanz,

Did you mean getOwnerURLPath?

Or

Or


Regards,

You can use following Systems Entity to Get Application Name

 {Espace} -> {Module} -> {App_Definition_Module} -> {Application}


Regards

Wei

Hi Wei,


Thanks for the reply. However, This is not what I mean. Please see screenshot below.

Field Producer_Name technically is an Espace Name. I need to get the ApplicationName of that Espace.

Thank you,

Lanz

Solution

You can join {Espace} with following condition and then join related Entitys above.

  {Espace}.[Name] = {Espace_Reference}.[Producer_Name] AND {Espace}.[Is_Active] = True



Solution

Hi Hanz,

You can use below SQL query to get the Application Name of a particular eSpace.  Just pass the Espace Name.

SyntaxEditor Code Snippet

select {Application}.[Name] from {Application}
where {Application}.[Id]=(select {App_Definition_Module}.[Application_Id] from {App_Definition_Module}
where {App_Definition_Module}.[Module_Id]=(select ID from {Module} where {Module}.[Espace_Id]=(select {Espace}.[Id] from {Espace} where {Espace}.[Name]=@EspaceName and {Espace}.[Is_Active]=1)));

Note : Use the Output structure as per your need.

Hope this helps you.

Regard's,

Lakshmi Kumar