Skip to Content (Press Enter)
2021-07-27 12-21-25
Mangini
1814Views
2Comments
Solved
Getting Application ID from Espace ID
Question

Good day.

Does anyone know if there is a way to get the Application Id from a espace Id? I was mostly expecting to find a ApplicationId on espace entity on System, but that dosen't seens to be the case...

0
0
14 Dec 2016
Copy Link
2021-07-27 12-21-25
Mangini
Solution

Nevermind, looking at Discovery i found out this path through the entities:

Espace > Module > App_Definition_Module > Application

Still not sure if this is the best solution...

2
0
14 Dec 2016
Copy Link
UserImage.jpg
Carlos Conde

You could try the following:

select ossys_module.espace_id, ossys_app_definition_module.application_id, ossys_app_definition_module.module_id from ossys_module
inner join ossys_app_definition_module on ossys_module.id = ossys_app_definition_module.application_id
inner join ossys_application on ossys_app_definition_module.application_id = ossys_application.id
where ossys_application.id = 42 (some Application Id)
and ossys_module.module_kind_Id = 1 (for eSpaces)

Like this, you will also get the Module Id.

1
0
14 Dec 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.