test/Client/ResultSet/TestAssets/projectsampledata.xml
<?xml version ="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//EN" "http://shn.serveftp.net:80/fmi/xml/fmresultset.dtd">
<fmresultset xmlns="http://www.filemaker.com/xml/fmresultset"
version="1.0">
<error code="0"></error>
<product build="06/21/2012" name="FileMaker Web Publishing Engine"
version="12.0.2.228"></product>
<datasource database="FMServer_Sample_Web" date-format="MM/dd/yyyy"
layout="Project" table="Projects" time-format="HH:mm:ss"
timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="3"></datasource>
<metadata>
<field-definition auto-enter="yes" four-digit-year="no"
global="no" max-repeat="1" name="PROJECT ID MATCH FIELD" not-empty="no"
numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
<field-definition auto-enter="yes" four-digit-year="no"
global="no" max-repeat="1" name="Created By" not-empty="no"
numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
<field-definition auto-enter="yes" four-digit-year="no"
global="no" max-repeat="1" name="Creation TimeStamp" not-empty="no"
numeric-only="no" result="timestamp" time-of-day="no" type="normal"></field-definition>
<field-definition auto-enter="yes" four-digit-year="no"
global="no" max-repeat="1" name="Project Name" not-empty="no"
numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="1" name="Description" not-empty="no"
numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
<field-definition auto-enter="yes" four-digit-year="no"
global="no" max-repeat="1" name="Status" not-empty="no" numeric-only="no"
result="number" time-of-day="no" type="calculation"></field-definition>
<field-definition auto-enter="yes" four-digit-year="no"
global="no" max-repeat="1" name="Status on Screen" not-empty="no"
numeric-only="no" result="text" time-of-day="no" type="calculation"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="1" name="Start Date" not-empty="no"
numeric-only="no" result="date" time-of-day="no" type="calculation"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="1" name="Due Date" not-empty="no"
numeric-only="no" result="date" time-of-day="no" type="calculation"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="1" name="Days Remaining" not-empty="no"
numeric-only="no" result="number" time-of-day="no" type="calculation"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="1" name="Days Elapsed" not-empty="no"
numeric-only="no" result="number" time-of-day="no" type="calculation"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="1" name="Project Completion" not-empty="no"
numeric-only="no" result="number" time-of-day="no" type="calculation"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="1" name="Tag" not-empty="no" numeric-only="no"
result="text" time-of-day="no" type="normal"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="1" name="Start Date Project Completion"
not-empty="no" numeric-only="no" result="date" time-of-day="no"
type="calculation"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="1" name="Due Date Project Completion"
not-empty="no" numeric-only="no" result="date" time-of-day="no"
type="calculation"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="9" name="Repeating Field" not-empty="no"
numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
<relatedset-definition table="Tasks">
<field-definition auto-enter="yes" four-digit-year="no"
global="no" max-repeat="1" name="Tasks::Task Name" not-empty="no"
numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
<field-definition auto-enter="yes" four-digit-year="no"
global="no" max-repeat="1" name="Tasks::TASK ID MATCH FIELD"
not-empty="no" numeric-only="no" result="number" time-of-day="no"
type="normal"></field-definition>
<field-definition auto-enter="no" four-digit-year="no"
global="no" max-repeat="9" name="Tasks::Repeating Field" not-empty="no"
numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
</relatedset-definition>
</metadata>
<resultset count="3" fetch-size="3">
<record mod-id="5" record-id="7676">
<field name="PROJECT ID MATCH FIELD">
<data>1</data>
</field>
<field name="Created By">
<data>Tim Thomson</data>
</field>
<field name="Creation TimeStamp">
<data>02/22/2012 17:19:47</data>
</field>
<field name="Project Name">
<data>Launch web site</data>
</field>
<field name="Description">
<data>Launch the web site with our new branding and product line.
Third line</data>
</field>
<field name="Status">
<data>4</data>
</field>
<field name="Status on Screen">
<data>Overdue</data>
</field>
<field name="Start Date">
<data>04/13/2011</data>
</field>
<field name="Due Date">
<data>05/02/2012</data>
</field>
<field name="Days Remaining">
<data>0</data>
</field>
<field name="Days Elapsed">
<data>275</data>
</field>
<field name="Project Completion">
<data>.48</data>
</field>
<field name="Tag">
<data>marketing</data>
</field>
<field name="Start Date Project Completion">
<data>04/13/2011</data>
</field>
<field name="Due Date Project Completion">
<data>05/02/2012</data>
</field>
<field name="Repeating Field">
<data>A1</data>
<data>B2</data>
<data>C3</data>
<data>D4</data>
<data>E5</data>
<data>F6</data>
<data>G7</data>
<data>H8</data>
<data>I9</data>
</field>
<relatedset count="5" table="Tasks">
<record mod-id="1" record-id="14999">
<field name="Tasks::Task Name">
<data>Site map sketch</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>2</data>
</field>
<field name="Tasks::Repeating Field">
<data>1</data>
<data>2</data>
<data>3</data>
</field>
</record>
<record mod-id="1" record-id="15000">
<field name="Tasks::Task Name">
<data>Send art to vendor</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>4</data>
</field>
<field name="Tasks::Repeating Field">
<data>4</data>
<data>5</data>
<data>6</data>
</field>
</record>
<record mod-id="1" record-id="15001">
<field name="Tasks::Task Name">
<data>Review mock ups</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>5</data>
</field>
<field name="Tasks::Repeating Field">
<data>7</data>
<data>8</data>
<data>9</data>
</field>
</record>
<record mod-id="0" record-id="15002">
<field name="Tasks::Task Name">
<data>Write page text</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>6</data>
</field>
<field name="Tasks::Repeating Field">
<data></data>
<data></data>
<data></data>
</field>
</record>
<record mod-id="0" record-id="15003">
<field name="Tasks::Task Name">
<data>New logo art</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>3</data>
</field>
<field name="Tasks::Repeating Field">
<data></data>
<data></data>
<data></data>
</field>
</record>
</relatedset>
</record>
<record mod-id="4" record-id="7677">
<field name="PROJECT ID MATCH FIELD">
<data>7</data>
</field>
<field name="Created By">
<data>Tim Thomson</data>
</field>
<field name="Creation TimeStamp">
<data>02/22/2012 17:19:47</data>
</field>
<field name="Project Name">
<data>Prototype</data>
</field>
<field name="Description">
<data>Build a working prototype of the new product.
Fourth line.</data>
</field>
<field name="Status">
<data>4</data>
</field>
<field name="Status on Screen">
<data>Overdue</data>
</field>
<field name="Start Date">
<data>02/06/2012</data>
</field>
<field name="Due Date">
<data>02/17/2012</data>
</field>
<field name="Days Remaining">
<data>0</data>
</field>
<field name="Days Elapsed">
<data>9</data>
</field>
<field name="Project Completion">
<data>.32</data>
</field>
<field name="Tag">
<data>manufacturing</data>
</field>
<field name="Start Date Project Completion">
<data>02/09/2012</data>
</field>
<field name="Due Date Project Completion">
<data>02/17/2012</data>
</field>
<field name="Repeating Field">
<data>*1</data>
<data>-2</data>
<data>+3</data>
<data>.4</data>
<data>/5</data>
<data>=6</data>
<data>=7</data>
<data>-8</data>
<data>`9</data>
</field>
<relatedset count="5" table="Tasks">
<record mod-id="1" record-id="15005">
<field name="Tasks::Task Name">
<data>Build prototype</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>9</data>
</field>
<field name="Tasks::Repeating Field">
<data>a</data>
<data>b</data>
<data>c</data>
</field>
</record>
<record mod-id="1" record-id="15006">
<field name="Tasks::Task Name">
<data>Review sketches</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>8</data>
</field>
<field name="Tasks::Repeating Field">
<data>d</data>
<data>e</data>
<data>f</data>
</field>
</record>
<record mod-id="1" record-id="15007">
<field name="Tasks::Task Name">
<data>Complete sketches</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>7</data>
</field>
<field name="Tasks::Repeating Field">
<data>g</data>
<data>h</data>
<data>i</data>
</field>
</record>
<record mod-id="0" record-id="15014">
<field name="Tasks::Task Name">
<data>Draft requirements</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>16</data>
</field>
<field name="Tasks::Repeating Field">
<data></data>
<data></data>
<data></data>
</field>
</record>
<record mod-id="0" record-id="15015">
<field name="Tasks::Task Name">
<data>Review requirements</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>17</data>
</field>
<field name="Tasks::Repeating Field">
<data></data>
<data></data>
<data></data>
</field>
</record>
</relatedset>
</record>
<record mod-id="4" record-id="7678">
<field name="PROJECT ID MATCH FIELD">
<data>13</data>
</field>
<field name="Created By">
<data>Tim Thomson</data>
</field>
<field name="Creation TimeStamp">
<data>02/22/2012 17:19:47</data>
</field>
<field name="Project Name">
<data>Investor meeting</data>
</field>
<field name="Description">
<data>This is important. We need the investors to have confidence.
Second line.</data>
</field>
<field name="Status">
<data>4</data>
</field>
<field name="Status on Screen">
<data>Overdue</data>
</field>
<field name="Start Date">
<data>12/12/2011</data>
</field>
<field name="Due Date">
<data>03/22/2012</data>
</field>
<field name="Days Remaining">
<data>0</data>
</field>
<field name="Days Elapsed">
<data>73</data>
</field>
<field name="Project Completion">
<data>.4285714285714286</data>
</field>
<field name="Tag">
<data>finance</data>
</field>
<field name="Start Date Project Completion">
<data>01/02/2012</data>
</field>
<field name="Due Date Project Completion">
<data>03/22/2012</data>
</field>
<field name="Repeating Field">
<data>a1</data>
<data>b2</data>
<data>c3</data>
<data>d4</data>
<data>e5</data>
<data>f6</data>
<data>g7</data>
<data>h8</data>
<data>i9</data>
</field>
<relatedset count="7" table="Tasks">
<record mod-id="1" record-id="15004">
<field name="Tasks::Task Name">
<data>Gather requirements</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>1</data>
</field>
<field name="Tasks::Repeating Field">
<data>*</data>
<data>-</data>
<data>+</data>
</field>
</record>
<record mod-id="1" record-id="15008">
<field name="Tasks::Task Name">
<data>Investor meeting</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>13</data>
</field>
<field name="Tasks::Repeating Field">
<data>`</data>
<data>=</data>
<data>-</data>
</field>
</record>
<record mod-id="1" record-id="15009">
<field name="Tasks::Task Name">
<data>Final draft of slides</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>12</data>
</field>
<field name="Tasks::Repeating Field">
<data>(</data>
<data>)</data>
<data>^</data>
</field>
</record>
<record mod-id="0" record-id="15010">
<field name="Tasks::Task Name">
<data>Complete business plan</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>10</data>
</field>
<field name="Tasks::Repeating Field">
<data></data>
<data></data>
<data></data>
</field>
</record>
<record mod-id="0" record-id="15011">
<field name="Tasks::Task Name">
<data>First draft of slides</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>11</data>
</field>
<field name="Tasks::Repeating Field">
<data></data>
<data></data>
<data></data>
</field>
</record>
<record mod-id="0" record-id="15012">
<field name="Tasks::Task Name">
<data>Market research</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>14</data>
</field>
<field name="Tasks::Repeating Field">
<data></data>
<data></data>
<data></data>
</field>
</record>
<record mod-id="0" record-id="15013">
<field name="Tasks::Task Name">
<data>Competitive analysis</data>
</field>
<field name="Tasks::TASK ID MATCH FIELD">
<data>15</data>
</field>
<field name="Tasks::Repeating Field">
<data></data>
<data></data>
<data></data>
</field>
</record>
</relatedset>
</record>
</resultset>
</fmresultset>