Skip to Content (Press Enter)
2024-12-17 14-32-59
Matthias Preuter
 
MVP
20Views
3Comments
Publishing date/time of a Extension
Question
For a eSpace you can see the published date/time and publisher, in the table ossys_Publishing where can i find the same information for a extension?

Kind regards,

Matthias
0
0
11 Oct 2010
Copy Link
2018-05-03 15-19-41
Miguel João
Staff
Hello Matthias

You can find this information on the ossys_Extension table of the OutSystems Datamodel.

If you're considering using this information on your application, I recommend reference the (system) Publishing and Extension entities, so you can access them using Simple Queries, instead of manually building your SQL statements.

Cheers

Miguel Simões João
0
0
16 Oct 2010
Copy Link
UserImage.jpg
Kevin Ward
This is the tSQL code I use to keep track of whats being published on the server and by who:

Select 
'Espace' AS Type, 
u.Name AS PublishedBy, 
u2.Name AS CodeBy, 
pub.Published_Date AS PublishDate, 
ev.Uploaded_Date AS CodeDate,
e.Name AS EspaceName, 
ev.Description
from ossys_Publishing pub
INNER JOIN ossys_User u 
on pub.Published_By = u.ID
LEFT OUTER JOIN ossys_Espace_Version ev
ON pub.Version_ID = ev.ID
LEFT OUTER JOIN ossys_Espace e 
ON ev.ESPACE_ID = e.ID
LEFT OUTER JOIN ossys_User u2 
on ev.UpLoaded_By = u2.[ID]
UNION ALL
Select 
'Extension' AS Type, 
u.[Name] AS PublishedBy, 
u2.Name AS CodeBy, 
ex.Published_Date AS PublishDate, 
ev.Uploaded_Date AS CodeDate,
ex.Name AS EspaceName, 
ev.Description
from ossys_Extension ex
LEFT OUTER JOIN OSSYS_DEVELOPER d
ON ex.Published_By = d.ID
LEFT OUTER JOIN ossys_User u 
on d.[User_ID] = u.ID
LEFT OUTER JOIN ossys_Extension_Version ev
ON ex.Version_ID = ev.ID AND ex.ID = ev.extension_ID
LEFT OUTER JOIN OSSYS_DEVELOPER d2
ON ev.UpLoaded_By = d2.ID
LEFT OUTER JOIN ossys_User u2 
on d2.[User_ID] = u2.ID
ORDER BY PublishDate Desc

Hope it's helpful, took a while to figure out that extensions join to Developer instead of directly to User...

Kevin
1
0
17 Feb 2011
Copy Link
2017-10-02 14-22-21
Paulo Tavares
Staff
Hi Kevin,

Thanks for sharing this info - especially on your first post.

Do keep it coming!

Regards,

Paulo Tavares
0
0
18 Feb 2011
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.