Can I get a email notification when new packages are added to app portal?
Oct 14, 2019 11:04 AM
While there is no feature in App Portal that allows for this, you could create a report in SQL Server Reporting Services using the following query:
SELECT [PackageID] ,[PackageTitle] ,[BriefDescription] ,[PackageVisible] ,[Deleted] ,[CreatedBy] ,[CreatedOn] ,[UpdatedBy] ,[UpdatedOn] FROM [AppPortal].[dbo].[WD_WebPackages] WHERE [CreatedOn] > DATEADD(HOUR,-24,GETUTCDATE())
This will show all catalog items created in the previous 24 hours. Then set up a subscription to send yourself the report each day. If you only want to see catalog items that were created and not subsequently archived, you could modify the query to move the [Deleted] column to the WHERE clause as "AND [Deleted] = 0".
Oct 15, 2019 01:31 AM - edited Oct 15, 2019 01:31 AM
Unfortunately at this time, there is no feature in App Portal to send out emails when new packages have been added.
Oct 14, 2019 12:19 PM
While there is no feature in App Portal that allows for this, you could create a report in SQL Server Reporting Services using the following query:
SELECT [PackageID] ,[PackageTitle] ,[BriefDescription] ,[PackageVisible] ,[Deleted] ,[CreatedBy] ,[CreatedOn] ,[UpdatedBy] ,[UpdatedOn] FROM [AppPortal].[dbo].[WD_WebPackages] WHERE [CreatedOn] > DATEADD(HOUR,-24,GETUTCDATE())
This will show all catalog items created in the previous 24 hours. Then set up a subscription to send yourself the report each day. If you only want to see catalog items that were created and not subsequently archived, you could modify the query to move the [Deleted] column to the WHERE clause as "AND [Deleted] = 0".
Oct 15, 2019 01:31 AM - edited Oct 15, 2019 01:31 AM