• fmCheckMate XML Query
  • The XML Query Dialog
  • XML Structure
  • XPath
    • XPath output options
  • XSLT
  • XQuery

fmCheckMate XML Query

Query your XML Structure with XPath, XSLT, XQuery

Sometimes you just need to quickly dip into the XML structure of your FileMaker file to get some information out of it.

fmCheckmate’s XML Query feature not only lets you do just that, but offers 4 different ways to query your XML structure:

1. XML Structure - for a quick overview get a dump of the entire XPath structure of your XML
2. XPath - pick the cherries out of your XML using XPath (v1.0)
3. XSLT - for more flexibility with the XML transformation language
4. XQuery - for the most powerful queries use the de facto XML query language XQuery¹

The XML Query Dialog

To open the XML Query dialog from the fmCheckmate XML Editor…

• select XML Editor > Show XML-Query from the menu or press ⇧⌘X

The Back Button

Click the Back button to close the window, or press ⌘1 to go back Home.

The heading

The heading shows which XML Query technology is currently active. XPath is the default. Click the heading to switch between the Query technologies.

The query input field

At the top in the middle is the input field for your query.

The output options

To the right of the input field is the output options / header text. Here you can choose the type of output (XML, Text, in XQuery even JSON) and set additional options depending on the selected XML Query technology, for example you can choose to output unique and/or sorted values.

The Play button

Click the Play button to execute your query.

The Functions button

Click the Functions button to open a list of available functions for the currently selected XML Query technology (under construction).

The Output field

The large text area at the bottom is the output field where the results of your query are shown.

XML Structure

To get a quick overview of the XML structure of your FileMaker file

• select Analyse XML Struture from the fmCheckMatemenu or press ⇧⌘S

XPath

In XPath mode you can enter any valid XPath v1.0 expression to query the XML structure of your FileMaker file.

Alternatively you can choose from the value list of xpaths from the structure of your document.

XPath output options

XSLT

XQuery

1. Note: Advanced XML features, XQuery (and XSLT v2+), require an MBS/Saxon licence, but can be previewed first. ↩