Welcome to Vortx Community Forum, where you can ask questions and receive answers from the staff at Vortx and other members of the community.

If you had a user account on our previous forums website, you will need to register a new account here.

Learn more about...

AspDotNetStorefront
DotFeed

Adding a filter to aspdnsf_RecentAdditions

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

 

asked May 11 in MultiStore by aflorestal (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')
answered Sep 18 by Vortx-Duncan (760 points)
...