$webUsers = $xpdo->getCollectionGraph('modWebUser',array('modWebUserProfile'=>array('internalKey'=>array())));[modWebUserProfile] => Array
(
[package] => modx
[table] => web_user_attributes
[fields] => Array
(
[internalKey] => 0
[fullname] =>
[role] => 0
[email] =>
[phone] =>
[mobilephone] =>
[blocked] => 0
[blockeduntil] => 0
[blockedafter] => 0
[logincount] => 0
[lastlogin] => 0
[thislogin] => 0
[failedlogincount] => 0
[sessionid] =>
[dob] => 0
[gender] => 0
[country] =>
[state] =>
[zip] =>
[fax] =>
[photo] =>
[comment] =>
)
MODX Staff
<object class="modWebUser" table="web_users" extends="modUser">
<composite alias="modWebUserProfile" class="modWebUserProfile" key="id" local="id" foreign="internalKey" cardinality="one" />
<composite alias="modWebUserSetting" class="modWebUserSetting" key="id" local="id" foreign="webuser" cardinality="one" />
<composite alias="modWebGroupMember" class="modWebGroupMember" key="id" local="id" foreign="webuser" cardinality="one" />
<composite alias="modWebUserAttributesExtended" class="modWebUserAttributesExtended" key="id" local="id" foreign="member_id" cardinality="one" />
</object>
<object class="modWebUserProfile" table="web_user_attributes" extends="xPDOSimpleObject">
<aggregate alias="modWebUser" class="modWebUser" key="internalKey" local="internalKey" foreign="id" cardinality="one" />
<aggregate alias="modUserRole" class="modUserRole" key="role" local="role" foreign="id" cardinality="one" />
</object>
<object class="modWebUserAttributesExtended" table="web_user_attributes_extended" extends="xPDOSimpleObject">
<aggregate alias="modWebUser" class="modWebUser" key="member_id" local="member_id" foreign="id" cardinality="one" />
</object>
WHERE modWebUser.id = modWebProfile.internalKey AND modWebUser.id = modWebUserAttributesExtended.member_id
MODX Staff
It definitely does joins fine; not sure exactly what your problem was, but I suspect the model is the problem and owner is definitely now the important attribute for relationships (key was deprecated and is no longer used). I’ll try and get a new model for Evolution cranked out that addresses this. You may also want to get the latest xPDO version from SVN.
I ended up using the built-in MODx DBAPI calls to create a custom SQL recordset. I then iterated through all records to extract each row’s values into an associative array, which I fed into MakeTable. Inefficient? Tell me about it.
It was nice to have an alternative solution but I am disappointed that I couldn’t get XPDO to do a simple join.
MODX Staff
Right, as long as the relationships you want to actually use in the graph is there, you should be fine. No need to define every relationship for every table.
Thanks Jason, I’ve got the SVN version running fine - no errors on my existing code.
I’ll go thru the XML with a fine-tooth comb and let you know if getCollectionObject ends up working.
I was thinking that I only need to check the tables that my code references - I don’t need to set up links for every single table in MODx do I?
<object class="WebUserAttributes" table="web_user_attributes" extends="xPDOSimpleObject"> <field key="internalKey" dbtype="int" precision="10" phptype="integer" null="false" default="0" index="index" /> [ ... fields removed for brevity ... ] <composite alias="User" class="WebUsers" local="internalKey" foreign="id" cardinality="one" owner="foreign" /> </object> <object class="WebUsers" table="web_users" extends="xPDOSimpleObject"> <field key="username" dbtype="varchar" precision="100" phptype="string" null="false" default="" index="unique" /> <field key="password" dbtype="varchar" precision="100" phptype="string" null="false" default="" /> <field key="cachepwd" dbtype="varchar" precision="100" phptype="string" null="false" default="" /> <composite alias="Profile" class="WebUserAttributes" local="id" foreign="internalKey" cardinality="one" owner="local" /> </object>
$WebUsers = $this->xpdo->getObjectGraph('WebUsers','{WebUserAttributes:{Profile:{}}}',1);
OR
$WebUsers = $this->xpdo->getObjectGraph('WebUsers','{Profile:{internalKey:{}}}',1);
THEN
echo $WebUsers->toArray();
MODX Staff
$WebUser = $this->xpdo->getObjectGraph('WebUsers', '{"Profile":{}}', 1);$userData = $WebUser->toArray(); $userProfileData = $WebUser->Profile->toArray();
print_r($WebUsers->_relatedObjects['Profile']->toArray());
Fatal error: Call to a member function toArray() on a non-object