Jayad / enterprise-log-search-and-archive

Automatically exported from code.google.com/p/enterprise-log-search-and-archive
0 stars 0 forks source link

Dashboard with groupby query problem #115

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

1. Create a dashboard with "groupby" query like this:

{
   "charts" : [
      {
         "y" : "1",
         "options" : {
            "title" : null
         },
         "queries" : [
            {
               "query" : "host=192.168.X.Y",
               "label" : "host=192.168.X.Y"
            },
            {
               "query" : "host=192.168.X.Y",
               "label" : "host=192.168.X.Y"
            },
            {
               "query" : "groupby:host",
               "label" : "groupby:host"
            }
         ],
         "x" : "0",
         "type" : "ColumnChart"
      }
   ],
   "auth_required" : "0",
   "title" : "test2",
   "alias" : "test2"
}

2. View the dashboard

What is the expected output? What do you see instead?

Got an error: "We already have a column with the id 'value' at 
/usr/local/elsa/web/lib/Web/GoogleDatasource.pm line 87.". See the screenshot 
attached.

What version of the product are you using? On what operating system?

ELSA r743, CentOS 6.4.

Please provide any additional information below.

Atached is a patch that fixed the error for me.

Original issue reported on code.google.com by dmitry.f...@gmail.com on 28 Mar 2013 at 3:13

Attachments:

GoogleCodeExporter commented 9 years ago
It looks like you've got identical queries in your chart, so I'm not sure why 
you'd want that, but in any case, I don't see the harm in using something 
similar to your patch, so I've committed that code in rev 746.  Thanks.

Original comment by mchol...@gmail.com on 28 Mar 2013 at 6:40