UK MatrixAttributeDisplayOrder help

May 14, 2013
Reaction score
Hello, I've been struggling for a few weeks now trying to figure out how the colour code in MatrixAttributeDisplayOrder corresponds to the Item table.

I need to pull the corresponding colour code using either item id or item lookup code. I tried to join the tables on id columns but it didn't return anything and then using the alias table inbetween which returns some results but they don't look right

Here is my query using the alias table as glue between item and the matrix table

ISNULL((SELECT TOP 1 Code FROM MatrixAttributeDisplayOrder WHERE MatrixAttributeDisplayOrder.ID = (SELECT TOP 1 ID FROM Alias WHERE Alias.ItemID = Item.ID)),'')

Please help =)


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question