Rally Excel附加查询

Question

我正在尝试在Excel add on中复制一个在Rally中工作(获得我想要的结果)的查询，但没有成功。

来自Rally的查询是

(((State != Closed) AND (CreationDate >= 2015-02-10)) AND ((Tags contains "Regression") OR (Name contains "Regression") OR (Name contains Regress))) 

当我在Excel中的新查询的筛选器字段中输入以下内容时，get an error显示

Cannot Parse.  Error parsing expression -- expected ")" but saw OR instead.

OR值在Rally本身中工作，不确定excel中的OR有什么问题

凯伦

Answer 1

我相信下面的语法就是你想要的。请注意Tags上的条件中Tags.Name的用法

(((State != Closed) AND (CreationDate > 2015-02-10)) AND (((Tags.Name contains "Regression") OR (Name contains "Regression")) OR (Name contains "Regress")))