https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/45708.aspxMon, 10 Aug 2009 15:55:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:45708ben.oates0https://www.infopathdev.com:443/forums/thread/45708.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=45708<p>Never mind, I worked out where I had gone wrong.</p> <p>/dfs:myFields/dfs:dataFields/dfs:Stacks[not(@Stack_Name = preceding-sibling::dfs:Stacks/@Stack_Name)]</p> <p>That works.</p>https://www.infopathdev.com:443/forums/thread/45701.aspxMon, 10 Aug 2009 14:20:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:45701ben.oates0https://www.infopathdev.com:443/forums/thread/45701.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=45701<p>Hi all,</p> <p>I don&#39;t know what I am doing wrong here. I have a filter on a field from a SharePoint list and for some reason it is not returning unique values. It is returning all values.</p> <p>/dfs:myFields/dfs:dataFields/dfs:Stacks/@Stack_Name[not(. = preceding-sibling::dfs:Stacks/@Stack_Name)]</p> <p>I have used this approach before and it has worked a treat. I can&#39;t work out why it isn&#39;t working this time. It&#39;s probably something stupid but I can&#39;t spot it. If it helps, the field was originally the title on the list.</p> <p>Any suggestions?</p> <p>Thanks,</p> <p>Ben</p>