This SQL-query that I use in Microsoft SQL Server Management Studio gives me the desired results:
select AV.NAME from OSSYS_APP_VERSION as AV
join OSSYS_APPLICATION as A on AV.APPLICATIONID = A.ID
where A.NAME = 'Rider'
and year(AV.CREATEDON) > 2021
In Outsystems in the tab Manage dependencies under the public elements for Systems I can find the entitiy 'Application', but not the entity 'App_Version'. Why???? Is the logic name different???
Hi Danny,
I think this entity is not exposed natively.
But I believe you can access it through the extension below:
https://www.outsystems.com/forge/component-overview/2146/extended-metamodel
Regards,
Pedro Costa
Thanks for your help.