This question has been answered by Bruno17. See the first response.
<?xml version="1.0" encoding="UTF-8"?> <model package="clientWork" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1"> <object class="Client" table="clients" extends="xPDOSimpleObject"> <field key="title" dbtype="varchar" precision="255" phptype="string" null="false" default="" /> <field key="logo" dbtype="varchar" precision="255" phptype="string" null="false" default="" /> <field key="createdon" dbtype="datetime" phptype="datetime" null="true" /> <field key="createdby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="editedon" dbtype="datetime" phptype="datetime" null="true" /> <field key="editedby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <composite alias="Work" class="Work" local="id" foreign="clientId" cardinality="many" owner="local" /> <aggregate alias="CreatedBy" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" /> <aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign" /> </object> <object class="Work" table="works" extends="xPDOSimpleObject"> <field key="clientId" dbtype="int" precision="10" phptype="integer" null="false" index="index" /> <field key="title" dbtype="varchar" precision="255" phptype="string" null="false" default="" /> <field key="description" dbtype="text" phptype="string" null="false" default="" /> <field key="createdon" dbtype="datetime" phptype="datetime" null="true" /> <field key="createdby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="editedon" dbtype="datetime" phptype="datetime" null="true" /> <field key="editedby" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" /> <aggregate alias="Client" class="Client" local="clientId" foreign="id" cardinality="one" owner="foreign" /> <aggregate alias="CreatedBy" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" /> <aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign" /> </object> </model>
[{"alias":"Client"}]
[{"alias":"Client","selectfields":"title,logo"}]
[{"alias":"Client","selectfields":"title,logo"},{"alias":"AnotherAlias"},{"alias":"notInSchema","classname":"modResource","on":"modResource.id=myClass.resource_id"}]