Reports View(s)

[jSylvestre]

Create view(s) in the database to facilitate running reports with filters.
Will need to look at payment's dates as one of the filters, and maybe sum up the amount of payments during that time range as well as reporting on the actual order fields.

Once view is created and tested, that will need to be pulled into the migration

[jSylvestre]

SELECT dbo.Payments.CreatedOn, dbo.Payments.Status, dbo.Orders.Id, dbo.Orders.Name, dbo.Payments.Amount
FROM dbo.Payments INNER JOIN
dbo.Orders ON dbo.Payments.OrderId = dbo.Orders.Id

SELECT TOP (1000) [Id]
,sum([Amount]) as total
,max([createdOn]) as toDate
,max([createdOn]) as fromDate
FROM [Hippo].[dbo].[Test View]
where Status = 'Completed'
and CreatedOn < '2024-08-01' and CreatedOn >= '2024-07-01'
group by Id