Bonjour!
En test sur mon PC ca fonctionne tres bien.
Voila mon dataset 1:
<FieldRef Name="Priority" />
</OrderBy>
</query>
</list>
<list title="L.E.A.P. Activities" relativeSiteUrl="" stripHtml="true"
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>
Dataset 2 pour ma liste de choix en parametre:
<?xml version="1.0" encoding="utf-8" ?>
<root>
<list title="LEAPStudentProfile" relativeSiteUrl="" tableName="Profile">
<fields>Author</fields>
<query>
</query>
</list>
<sqlOp op="distinct" >
<sortOrder>Author</sortOrder>
<dstTableName>Students</dstTableName>
<tableName>Profile</tableName>
<fieldName>Author</fieldName>
</sqlOp>
<resultSet>Students</resultSet>
</root>