{"type":"doc","content":[{"type":"paragraph","content":[{"text":"A fundamental thing when building a report based on XML data is to understand some basics about XPath. XPath is a syntax used to describe parts of an XML document and you can think of it as a path to the data you want. You can refer to a set of nodes such as all the rooms in the document, a specific attribute like the room name attribute in the room and many other variants.","type":"text"},{"type":"hardBreak"},{"text":"XF Designer will help you create most of these expressions for you, but it is recommended to get some understanding of this. In some of the more advanced reports/tasks you might also need to edit some expressions manually.","type":"text"}]},{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"When you refer to multiple nodes you refer to a node set. ","type":"text"}]},{"type":"paragraph","content":[{"text":"In the example image to the right the expression","type":"text"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

/drofus-xml/room-container/room

","nestedContent":{"type":"doc","content":[{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"/drofus-xml/room-container/room","type":"text"}]}]}]}]}],"version":1},"reason":"A table in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"text":"refers to all the room nodes under the room-container node, in this case two rooms.","type":"text"}]},{"type":"paragraph","content":[{"text":"You use this kind of XPath expression when you want to do something for each room in the XML.","type":"text"}]},{"type":"paragraph","content":[{"text":"If you want to get a specific attribute value,","type":"text"}]},{"type":"paragraph","content":[{"text":"such as the value of the project name attribute, you can use","type":"text"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

/drofus-xml/property-set/@project_name

","nestedContent":{"type":"doc","content":[{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"/drofus-xml/property-set/@project_name","type":"text"}]}]}]}]}],"version":1},"reason":"A table in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"text":"There are also functions that you can use to make tests or other operations, e.g. sum, count etc:","type":"text"}]},{"type":"paragraph","content":[{"text":"The expression","type":"text"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

count(/drofus-xml/room-container/room)

","nestedContent":{"type":"doc","content":[{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"count(/drofus-xml/room-container/room)","type":"text"}]}]}]}]}],"version":1},"reason":"A table in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"text":"returns the number of rooms in this document, 2.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"mediaSingle","attrs":{"layout":"align-start","width":33.0},"content":[{"type":"media","attrs":{"width":326,"id":"86d0d00b-ae90-456d-98e3-d5e2c9c1b1ea","collection":"contentId-1318364117","type":"file","height":307}}]}]}]}]}],"version":1}

Browser not supported