[ENG] (6.1.z) Clicking on chart item don't filter other KPIs properly

+++ This bug was initially created as a clone of Bug #1181181 +++

+++ This bug was initially created as a clone of Bug #1179516 +++

Description of problem:
I have a dashboard with 2 bar charts (NVD3) using distinct datasources (SQL).
Both have a column named "Test". When I select a bar from the first chart, the second chart is updated, but the filter is wrong.
If I use the filter in the left side, the bug doesn't occurs.

Version-Release number of selected component (if applicable):
6.2 (trunk)

How reproducible:

Steps to Reproduce:
1. Add two bar charts to the dashboard, using distinct data-sources. Both datasources must have columns in common.
2. Click in a bar from the first chart.

Actual results:
Data is shown wrong, messed.

Expected results:
Data is shown correctly

Additional info:
The bug only occurs if I filter from the chart. Using the filter on the left side, bug don't occurs.

— Additional comment from JBoss Product and Program Management on 2015-01-06 18:50:39 CST —

Since this issue was entered in Red Hat Bugzilla, the release flag has been
set to ? to ensure that it is properly evaluated for this release.

— Additional comment from Van Halbert on 2015-01-06 18:56:29 CST —

Please use the admin user to export the dashboard and workspace. Should have files with the following extensions:

(workspace) .kpiex
(dashboard) .cex

— Additional comment from Walter on 2015-01-06 19:45:30 CST —

Workspace and Dashboard files attached

— Additional comment from Van Halbert on 2015-01-06 21:03:17 CST —

Are these files from DV 6.0 dashboard?

— Additional comment from Van Halbert on 2015-01-06 21:05:13 CST —

Why I ask are these from DV 6.0, because when I export dashboard and export workspace, I don't get a workspace like this.

— Additional comment from Van Halbert on 2015-01-09 08:46:15 CST —

Walter,

Can you test with DV 6.1 to see if your issues are resolved? There have been many improvements in Dashboard Builder.

Thanks.

Van

— Additional comment from Van Halbert on 2015-01-09 08:47:51 CST —

Please use the latest build that can be found here: http://dev138.mw.lab.eng.bos.redhat.com/candidate/dv-6.1.0-ER5/

— Additional comment from Walter on 2015-01-09 15:10:32 CST —

Van,

I tested with the master branch of github. It is the 6.1?
I forked the code and fixed it. I don't think mine solution is the best, but worked for me. You could take a look at: https://github.com/walteram/dashboard-builder/commit/fc6d294054486b1c6d638a1a3c18ffe8ac133702

— Additional comment from Van Halbert on 2015-01-09 15:14:52 CST —

We're using version 6.0.3.

Also, I'll need to post this BZ to the BRMS BAM component so that they can apply the change.

— Additional comment from JBoss Product and Program Management on 2015-01-12 09:30:07 EST —

Since this issue was entered in Red Hat Bugzilla, the release flag has been
set to ? to ensure that it is properly evaluated for this release.

— Additional comment from David Gutierrez on 2015-01-26 11:56:31 EST —

I've tried to reproduce it on latest dashbuilder 6.2.x. It works fine tough.

I created two KPIs on the same dashboard and fed them from two different data sources and tables. When I filter by a column that exists in both tables both kpis are filtered correctly. Clicking on chart or in a filter form it makes no difference.

I need more info to reproduce it.

— Additional comment from Van Halbert on 2015-02-06 09:38:04 EST —

For DV 6.1 use, it appears you cannot reproduce the problem. Which is good. The only suggestion I would make would be to test this scenario off your master. Because this is where this issue was seen. And if you do see it, then this BZ can be updated to target upstream.

— Additional comment from David Gutierrez on 2015-02-09 10:20:46 EST —

As mentioned, this is not reproducible neither on master nor 6.2.x.

Setting status to MODIFIED.

— Additional comment from Jan Hrcek on 2015-03-23 04:05:03 EDT —

Just playing with BPM Suite 6.1.0 ER6 and I'm not sure that the current behavior is desired. Please review the steps I used below and let me know what you think:

1) Create 2 data sources that both have identically named property. For simplicity use CSV file data sources based on following 2 files. Notice that both data sources have the "age" property:

> cat people.csv
id,name,age
1,Jan,30
2,Dan,30
3,Sam,50

> cat cars.csv
id,car,age
1,BMW,10
2,Porsche,10
3,Pontiac,30

2) Create 2 Pie chart KPIs on one page, one displaying (X axis: age, Y axis: count of IDs) for people, the other for cars.
3) Create dashboard filter panel to include Car's age property.
4) Filter by clicking charts (click 30 for car's age) or using filter panel (enter from 30 to 30).

What I find problematic is that People's ages are filtered too - even though we are filtering on car's age. What do you think of this behavior? Shouldn't filtering be isolated on per-datasource basis?

— Additional comment from Van Halbert on 2015-04-06 09:20:46 EDT —

I would agree, filtering should be based on datasource.column. Right now it appears based on column, regardless of datasource. Which seems you would get unintended filtering.

— Additional comment from Rajesh Rajasekaran on 2015-05-21 15:56:49 EDT —

Increasing the priority as a fix for this issue was requested by the DV team. If a fix is available it should be targeted for 6.1 patch Update 02.