Custom Web Publishing Guide

30 FileMaker Server Advanced Custom Web Publishing Guide
For example:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=family&–findall
Note When specifying the fmresultset grammar, be sure to use lowercase.
The Web Publishing Engine will generate an XML document using the fmresultset grammar. In the XML
document, the Web Publishing Engine will reference the document type definition for the
fmresultset
grammar in the
<!DOCTYPE> instruction in the second line of the document, immediately after the <?xml...?>
instruction. The
<!DOCTYPE> instruction specifies the URL for downloading the DTD for the fmresultset
grammar.
Description of elements in the fmresultset grammar
The fmresultset grammar consists primarily of the <datasource> element, the <metadata> element, and the
<resultset> element.
<datasource> element
In the fmresultset grammar, the <datasource> element contains the table, layout, date-format, time-format,
timestamp-format, total-count, and database attributes.
1 The date-format attribute of the <datasource> element specifies the format of dates in the XML
document:
MM/dd/yyyy
where:
1 MM is the 2-digit value for the month (01 through 12, where 01 is January and 12 is December)
1 dd is the 2-digit value for the day of the month (00 through 31)
1 yyyy is the 4-digit value for the year
1 The time-format attribute of the <datasource> element specifies the format of times in the XML
document:
HH:mm:ss
where:
1 HH is the 2-digit value for hours (00 through 23, for the 24-hour format)
1 mm is the 2-digit value for minutes (00 through 59)
1 ss is the 2-digit value for seconds (00 through 59)
1 The timestamp-format attribute of the <datasource> element combines the formats of date-format and
time-format into one timestamp:
MM/dd/yyyy HH:mm:ss
<metadata> element
The <metadata> element of the fmresultset grammar contains one or more <field-definition> and <relatedset-
definition>
elements, each containing attributes for one of the fields of the result set. These attributes specify
whether the field is an
auto-enter field (“yes” or “no”), the maximum number of repeating values (max-repeat
attribute), whether it is a
not-empty field (“yes” or “no”), whether it is a global field (“yes” or “no”), result
(“text,” “number,” “date,” “time,” “timestamp,” or “container”), type (“normal,” “calculation,” or
“summary”), and the field name (fully qualified as necessary).