Retrieving value from view changed during an update

Regis Wengel asked on May 24, 2018 23:32

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?

Column Differences

Correct Answer

Peter Mogilnitski answered on May 25, 2018 00:01

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.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Regis Wengel answered on May 25, 2018 00:18

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
0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.