Changing field name in a pagetype

Monjoie Dominique asked on April 3, 2017 13:39

I have tables that have fields with the same name (ex: table_A.picto, table_A.picto2, table_B.picto, table_B.picto2).

I tried to put the full name in my transformations but it generates an error.

I then tried to change names for the fields in one of the 2 tables. When I do a SELECT using Microsoft SQL, it works but when I put these new names in a transforation, nothing appears for these fields.

Do you have a solution ?

Best regards,

Correct Answer

Brenden Kehren answered on April 3, 2017 14:39

Are you using a custom query? Are you using a SQL to manage the field names or the Kentico UI?

You might want to check out using a Universal Viewer because you can specify which page type the transformations are for and when they get used vs. a standard repeater and joining 2 tables together.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Ilesh Mistry answered on April 3, 2017 14:39

Hi Monjoie

What are you trying to do? Is it a repeater and you're changing trying to get the values out in the transformation?

If the page type fields names are the same, have you tried <% Eval('picto') %>? And then limit the page types in the web part settings?

Can you provide some more information on this please?

0 votesVote for this answer Mark as a Correct answer

Monjoie Dominique answered on April 5, 2017 11:33

All is OK. I found my way. Thanks.

0 votesVote for this answer Mark as a Correct answer

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