Publishing date/time of a Extension

Publishing date/time of a Extension

  
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
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
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
Hi Kevin,

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

Do keep it coming!

Regards,

Paulo Tavares