I have created a new document call PageCatagory the has two columns, CatagoryID and CategoryName. This document type is used in the site tree to create an N-tiered category structure for the site admins to categorize the pages in the site for custom analytics purposes. I have added a custom field attribute to the Page (menu item) document type that is a list box so the user can select what category the page belongs to. The list box needs to be populated with the items from the category structure using a SQL query based on the current site that is being edited. Using the query below how can I make the site id dynamic using a macro? I have tried the query below but it throws an exception.

SELECT CategoryID, CategoryName FROM View_custom_PageCategory_Joined
where NodeSiteID = {%CurrentSiteID%}