Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 7.x > Portal Engine > CMSRepeater and related datatype View modes: 
User avatar
Certified Developer 13
Certified Developer 13
TL - 10/16/2013 5:16:50 PM
   
CMSRepeater and related datatype
Hello,
I would like to show a field from a related custom datatype in CMSRepeater.

Let's say I have two custom datatypes - x.Person and x.Address and I am displaying list of x.Person and its details when user clicks it. Person has FirstName and LastName and AddressId and x.Address has AddressId and City for example. So they are linked by AddressId.

I am able to display FirstName, LastName and AddressId by CMSRepeater, but how can I achieve displaying FirstName, LastName and City?
What is recommended solution for this? Is it possible by CMSRepeater?

Regards,
Tomas Loun

User avatar
Kentico Support
Kentico Support
kentico_janh - 10/17/2013 6:19:35 AM
   
RE:CMSRepeater and related datatype
Hello,

You should be able to done this using nested repeaters where you take only that document with appropriate AddressID, however I would recommend you to take advantage of the Repeater with custom query web part where you can specify complete sql query and join any two tables (or more), so the returned dataset would contain all necessary data.

Best regards,
Jan Hermann

Top