Hello,
I set the module with:
Query Type new items

But I have a problem because the latest product is dated 2017-07-05 14: 54: 48.067 and then the widget remains empty.

The customer has seasonal products so it can happen that between publishing a product and another passes a long time.
The goal is to always have the latest products (eg last 3) inserted for a given category.

I've also tried Product Category but it is sorted by asc, so it's still not correct.

hi,
Ok so it works, do you see any problem if I remove from where the date control?

Ok, I've chosen the following solution:
1) If I have the result the operation is yours (no modification)
2) If I have no results, I take the top 10 (parameter in) without test date. Can I also be useful to you for future developments?

/****** Object:  StoredProcedure [dbo].[CVStore_GetAllProductCreatedAfterDate]    Script Date: 08/31/2017 12:37:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[CVStore_GetAllProductCreatedAfterDate]
(
@portalId int,
@dateCreated datetime,
@categoryid int
--,@nTop int = 10 --I think it is more correct as an optional parameter, but it goes wrong so I declare it internally
)
as

set nocount on

declare @nitem int = 0
declare @nTop int = 10
if @categoryid <> -1
BEGIN

select @nitem = COUNT(*) from dbo.[CVStore_Products] as p
inner join dbo.[CVStore_CategoryProduct] as cp
on p.productId = cp.productId
where portalId = @portalId and createddate > @dateCreated

and cp.categoryId = @categoryId and displayInStore = 1
and p.isDeleted = 0

if @nitem <> 0
BEGIN
select p.* from dbo.[CVStore_Products] as p
inner join dbo.[CVStore_CategoryProduct] as cp
on p.productId = cp.productId
where portalId = @portalId and createddate > @dateCreated
and cp.categoryId = @categoryId and displayInStore = 1
and p.isDeleted = 0
order by CreatedDate desc
end
else 
begin 
select top(@nTop) p.* from dbo.[CVStore_Products] as p
inner join dbo.[CVStore_CategoryProduct] as cp
on p.productId = cp.productId
where portalId = @portalId --and createddate > @dateCreated
--and createddate > DATEADD(month, -6, GETDATE())
and cp.categoryId = @categoryId and displayInStore = 1
and p.isDeleted = 0
order by CreatedDate desc
end



END
ELSE
begin

select @nitem = COUNT(*) from dbo.[CVStore_Products] as p
where portalId = @portalId and createddate > @dateCreated 
and displayInStore = 1 and p.isDeleted = 0

if  @nitem <> 0
begin
select p.* from dbo.[CVStore_Products] as p
where portalId = @portalId and createddate > @dateCreated 
and displayInStore = 1 and p.isDeleted = 0
order by CreatedDate desc
end
else
begin
select top(@nTop) p.* from dbo.[CVStore_Products] as p
where portalId = @portalId --and createddate > @dateCreated
--and createddate > DATEADD(month, -6, GETDATE()) 
and displayInStore = 1 and p.isDeleted = 0
order by CreatedDate desc
end
END