Bonjour! I have a little problem, some fields that have data doesn't show for a reason, I'm joining to another list, sometimes it's the Description field, and sometime is the skills. Some rows have a Description and a Skill and only the Skill is showed.
Also I have a rowLimit = 25 and it goes sometimes up to 29 or 30 rows.
<?xml version="1.0" encoding="utf-8" ?>
<root>
<list title="LEAPStudentProfile" relativeSiteUrl="" stripHtml="true" rowLimit="25" tableName="Profile" >
<fields>Priority,Activity,AssignedTo,Author, Show_x0020_on_x0020_Certificate,_ModerationStatus</fields>
<query>
<Where>
<And>
<Eq>
<FieldRef Name="Author" />
<Value Type="Text">@cat!</Value>
</Eq>
<Eq>
<FieldRef Name="Show_x0020_on_x0020_Certificate" />
<Value Type="Boolean">1</Value>
</Eq>
</And>
</Where>
<OrderBy>
<FieldRef Name="Priority" />
</OrderBy>
</query>
</list>
<list title="L.E.A.P. Activities" relativeSiteUrl="" stripHtml="true" rowLimit="25" tableName="Activities">
<fields>Title, Description, Activity_x0020_Lookup,Skills</fields>
<query></query>
</list>
<sqlOp op="join">
<dstTableName>MergedContacts</dstTableName>
<parentTableName>Profile</parentTableName>
<childTableName>Activities</childTableName>
<parentFieldName>Activity</parentFieldName>
<childFieldName>Activity_x0020_Lookup</childFieldName>
</sqlOp>
<resultSet>MergedContacts</resultSet>
</root>
Regards, Joel :)