Ask A Guru

Dext3r

I'm trying to use this query:

            SELECT

                BUILTIN.DF(sc.category) AS category,

                sc.isdefault

            FROM itemSiteCategory sc

            WHERE sc.item = ${itemId}

To get information about an items commerce categories but it keeps returning no data. Am I using this wrong? AI is suggesting that this isn't available to SQL despite being referenced in the Records Catalog.