/
Item List Report
Document toolboxDocument toolbox

Item List Report

Owned by Brok Howard
Last updated: Nov 06, 2023



Filename:

Item list.xfd

Level

Beginner

XML from report:

Other export -> FF&E Catalog XML export

  • Include FF&E items

  • Include FF&E cost

  • With sub FF&E

XML sample file:

xml/ffe_with_cost.xml

Key concepts

Table repeat, sum

This report prints out FF&E items in a table. If the item has sub items, this is printed below the parent. The report uses a repeating table row (see 3.6) for each /drofus-xml/article-container/article. Inside the name column there is a repeating section for sub-article-list/sub-article that will list the sub items.
At the bottom we use the sum function to sum the cost for all items. The XPATH expression for this is:

sum(/drofus-xml/article-container/article/cost/price/net/excluding-vat/)

sum(/drofus-xml/article-container/article/cost/price/net/excluding-vat/)



Related content

https://support.drofus.com