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

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

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

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