AnsweredAssumed Answered

Excel plug-in returning duplicate data

Question asked by MattBlock1358632 on Mar 3, 2016
Latest reply on Mar 7, 2016 by EricNash
I am using the excel plugin and trying to get a list of all Initiatives that have a certain tag, or that belong to a Theme that has that tag.  However, I am getting duplicate entries in what is returned.  Both parts of the query work fine when I do them individually, but when I add them together with an OR I get duplicates.  I have it set to return Iniatives, and here is the filter I'm using.

((Tags.Name = "Enterprise Backlog") OR (Parent.Tags.Name = "Enterprise Backlog"))

If I do just the first half, I get 23 results.  If I do just the second half I get 78,  When I run it combined I get 108 results.  One Initiative shows up 3 times, and 3 of them show up 4 times.  Any idea on why this is happening and how I can fix it?  

Outcomes