Item relation list returns a single value instead of an array of multiple values

Pernille Mortensen

Posted on 23/04/2019 11:22:48

I would like to get all values from an item relation list that is part of a page item type, but I have a problem because the item relation list returns a single value instead of an array of all the items.

This is the code I use:

// Get all pages under a certain parent page

var products = Dynamicweb.Services.Pages.GetPagesByParentID([my_page_id]).Where(x => x.Active && x.Published);

// Loop through the pages in order to get values for each single page

foreach(var product in products){

<span>Produktnavn:</span> @product.MenuText<br/>

<span>Træsort:</span> @product.Item["Tr_sorter"]

}

The last line (@product.Item["Tr_sorter"]) refers to a item relation list (where item source = paragraphs). It contains several items/paragraphs, but it only returns a single number - and I'm not sure how this number corresponds to the item - it is not the paragraph ID nor the item ID. I would expect it to return an array / multiple values.

How can I output a list of all the items/paragraps in the item relation list?

Replies

Adrian Ursu

Posted on 23/04/2019 12:02:59

Hi Pernille,

That ID is the ID of the List. You will need to use the API to get the elements of that list, but keep in mind that the APi will return the IDs of the Items attached to that list. Which means you might need an additional conversion from ItemId to the actual Item before you can access the Item properties.

I have used something like this in the past:

var customList = ItemList.GetItemListById(customListID);

Combined with :

foreach(var item in customList){
 Dynamicweb.Content.Items.Item tempItem = Dynamicweb.Content.Items.Item.GetItemById("DiscountsImages", item);
}

There might be better alternatives in newer versions of DW.

I hope this helps.

Adrian

Pernille Mortensen

Posted on 23/04/2019 13:55:00

Thank you very much for your answer. It makes sense that the number is the ID of the list.

I have tried you code but get an error when trying to loop through the list.

My code:

var treeList = Dynamicweb.Content.Items.ItemList.GetItemListById(treeListId);

foreach(var item in treeList){

}

It returns the template error: foreach statement cannot operate on variables of type 'Dynamicweb.Content.Items.ItemList' because 'Dynamicweb.Content.Items.ItemList' does not contain a public definition for 'GetEnumerator'

Any ideas what I'm doing wrong?

Adrian Ursu

Posted on 23/04/2019 14:14:17

Hi Pernille,

I have given you incomplete information.

The foreach should be done against a Relations property:

foreach(var item in treeList.Relations){

...

}

I am sorry I missed that. I have not used it in a while :)

Adrian

Pernille Mortensen

Posted on 24/04/2019 10:32:47

Thank you. It works! :)

Here is the code I used in order to get the field values of my item relation list items (for anyone stumbling upon this thread in the future):

foreach(var item in treeList.Relations){

// Convert itemEntry to Item
Dynamicweb.Content.Items.Item myItem = new Dynamicweb.Content.Items.Item(item);

// This is a field with the system name "Title"

var itemTitle = myItem["Title"];

// This is a field with the system name "Image"

var itemImage = myItem["Image"];

}

Nuno Aguiar

Posted on 24/04/2019 10:51:13

Hi Pernille,

You should be able to do this

var customList = ItemList.GetItems(customListID);

foreach(var item in customList){
 // the 'item' var is already your item
}

That makes it simper than having to go through the relations and then get each individual item.

Best Regards,

Nuno Aguiar

Adrian Ursu

Posted on 27/04/2019 13:51:52

Nuno's alternative is a lot more elegant and efficient.

I will update my code to use his instead.

Thank you Nuno!

Adrian

Nuno Aguiar

Posted on 06/05/2019 15:11:39

You are welcome!

You must be logged in to post in the forum

Developer forum

Item relation list returns a single value instead of an array of multiple values

Replies