Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > distinct values in datalist View modes: 
User avatar
Member
Member
bijukumar.r-gmail - 1/24/2011 5:09:15 AM
   
distinct values in datalist
hi

i have one custom document,In which i wish to display one type of attribute with distinct (without repetitions)functionality in a datalist

eg.product have different product series.i wish to display distinct product series in the top of products page in datalist.

User avatar
Member
Member
dima - 1/24/2011 5:16:07 AM
   
RE:distinct values in datalist
I think you're looking for something like a nested repeater.
Have a look at this article:
http://www.kenticodeveloper.com/Matthew-Lee/December-2010/Nested-Repeaters.aspx
I believe it may help you

User avatar
Member
Member
bijukumar.r-gmail - 1/24/2011 6:50:12 AM
   
RE:distinct values in datalist
i have only one datalist in which i want to populate one of my document attribute with out duplication...


the data populated succesfully but problem is while adding the data to document product series field have same values .i want to display this product series field with out replication (i mean like distinct).i have only this value in tranformation of document

User avatar
Member
Member
dima - 1/24/2011 7:23:04 AM
   
RE:distinct values in datalist
how do you specify product series related to a product?

User avatar
Member
Member
bijukumar.r-gmail - 1/24/2011 11:04:53 PM
   
RE:distinct values in datalist
product document have 10 field values and i have 15 products using it


the attributes are

1,product series(common for some products)
2,product name
3,.......
4,.......
.........


in which i wish to display the product series attribute as distinct


User avatar
Member
Member
dima - 1/25/2011 1:54:16 AM
   
RE:distinct values in datalist
I am not sure if I understood you correctly but I think there are different ways of achiving it.
You can create a new custom query like
SELECT disctinct series from custom_product
and
create transformation specifically for rendering series.
and
drop repeater web part on the page selecting the created transformation

I hope it helps.

User avatar
Kentico Developer
Kentico Developer
kentico_ivanat - 1/26/2011 3:29:18 AM
   
RE:distinct values in datalist
Hi,

as Dima said - you can create a custom query in the Queries tab of your document type (Site Manager - Development - Document Types - your document type - Queries).

Then do display selected data you can use Datalist with custom query webpart.

Best regards,
Ivana Tomanickova