Thread: Dont show Category if there are no Products

I was looking for a setting or a way of reproducing the function of the HideProductsWithLessThanThisInventoryLevel variable in the appconfig, only for categories/sub categories. This way I could create the categories/sub categories and the code to sort the products correctly, and not have to worry about blanks on my site.

Add a query to your package:

Code:

<query name="EntityMaster" rowElementName="Entity">
    <![CDATA[
      SELECT Name,EntityID,ParentEntityID,NumObjects FROM dbo.EntityMaster WHERE EntityType='category' AND Published = 1 AND NumObjects > 0
    ]]>
    
  </query>

Then you can use it to compare and filter out nodes that you do not want.

thanks. works like a charm.