using Group along with asof in query.v1

80 views
Skip to first unread message

Kameshwaran A

unread,
Apr 1, 2015, 3:33:30 PM4/1/15
to version...@googlegroups.com
Hi ,

I am trying to group by changedate  on the histroy of all the stories in a time box however when I use group along with the below mentioned json, I am getting a server error :

If we cannot group by change date, what are all the fields I can use in group by ?


Working json without group :
---------------------------------------

{
    "from" : "Story",
        "select" : [
     "Name","Estimate","ChangeDate","Status.Name"
   ],
    "filter" : [
     "Timebox='Timebox:1318689'"
     
     ],
     "sort" : [
                +ChangeDateUTC
     ],
     "asof" :All
    
}

Json not wkorking (with Group)
----------------------------------------------

{
    "from" : "Story",
        "select" : [
     "Name","Estimate","ChangeDate","Status.Name"
   ],
    "filter" : [
     "Timebox='Timebox:1318689'"
     
     ],
     "sort" : [
                +ChangeDateUTC
     ],
     "asof" :All,
      "group":
    [{
      "from": "Story",
      "select":
        [
          "ChangeDate"
        ]
        }]
}



Reply all
Reply to author
Forward
0 new messages