Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


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 conceptsTable 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/)