How do i create and add filters to the aspdnsf_RecentAdditions sproc ?

 

in MultiStore by (225 points)

1 Answer

0 votes
Yes, this is an old post, but here goes.

I think this post hasn't gotten a response because it will require a large amount of base development knowledge that is out of scope for a forum post.

If the following is unfamiliar a dev partner could help you out with this pretty easily.

- how to connect to a database

- how to use sql server management studio

https://docs.microsoft.com/en-us/sql/ssms/tutorials/tutorial-sql-server-management-studio?view=sql-server-2017

- how to modify a SQL stored procedure.

- how to write SQL.

https://www.khanacademy.org/computing/hour-of-code/hour-of-sql/v/welcome-to-sql

https://www.w3schools.com/sql/

 

That being said, to filter products that have a ProductType of "blog", you would update the aspdnsf_RecentAdditions sproc with something like this:

WHERE p.ProductTypeID <> (SELECT ProductTypeID FROM ProductType WHERE ProductType.Name = 'blog')
by (780 points)
...