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...


Adding a filter to aspdnsf_RecentAdditions

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


asked May 11, 2018 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


- how to modify a SQL stored procedure.

- how to write 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, 2018 by Vortx-Duncan (780 points)