OK, have a client on V4.
I understand and know the button header is not based on the product name,
The client has changed some product names however its not just the button headder which hasnt updated, the product name also remains the same…
Is this expected behavior?
Grouse for example has had the product name changed to Amaretto.
While I understand and have recommended they add new products they insist on updating product names.
However I would have expected the product name column to be correct and the header column to just need updating…
Does anyone have or is able to provide a quick script to update these values?
Have the columns here;
SELECT m.[Id], m.[Name] AS ProductName, s.[Name] AS ScreenName FROM [ScreenMenuItems] s JOIN [MenuItems] m on m.[Id] = s.[MenuItemId] WHERE 1=1
Ideally want to INSERT m.[Name] into s.[Name] but obviously isn’t a straight insert and needs to do it based on m.[Id] = s.[MenuItemId]
@QMcKay any chance of a bit of your magic