I am updating a site from Kentico v9 - v11. The view [View_CONTENT_MenuItem_Joined] has been changed, specifically the column MenuItemGroup. In our code we use a SQL Select statement like
SELECT * FROM View_CONTENT_MenuItem_Joined WHERE MenuItemGroup = 'top'
However since the update this MenuItemGroup column appears to be a 16bit hexadecimal value. Is there any way to write an equivalent where statement?
If I am not mistaken this view is gone in version 9. It existed in prior version, but not in 9+. Looks like you are getting GUID there, but even in 11 MenuItemGroup is still intact and you still has 'top', 'footer' etc. Although there is column MenuItemTeaserImage which is GUID, so I would assume that somehow you get guids from MenuItemTeaserImage written into MenuItemGroup.
Ahhhhh, I see. The view is changing the names, didn't even notice that. That's a little bit confusing. Thank you!
dbo.CONTENT_MenuItem.MenuItemTeaserImage AS MenuItemGroup,
dbo.CONTENT_MenuItem.MenuItemGroup AS MenuPosition
Please, sign in to be able to submit a new answer.