"Distinct" disapears between RB9 and RB12.05
Hi,
We have reports that worked in RB9 that don't work anymore sinds we upgraded
to 12.05. We don't get distinct data anymore.
The queries were simple, and always seamed to include a "distinct"
statement.
With 12.05 we now get multiple records out.
Example:
Main pipeline on table "Jobs", field "Department". Group by "Department".
We only get distinct data, for example, deplartments A,B,C.
When adding another pipeline on "Job + Employees", we select the Job-->
Department field to link, and the employee's name for example, and group by
Jobs-->Department, name.
Preview this on it's own, we get all employees once.
Link those 2 pipelines together on "Department", we see in the preview that
the first pipeline still give back A, B, C, but the second will return all
employee names as many times as the values A, B and C exist in the database.
So if we have 10 Jobs in Department A, the employees of department A will
all be displayed 10 times.
Like the distinct is executed in the main pipeline, but lost during linking.
Is this normal behavior?
How can we avoid that in RB12.05?
Thanks,
Chantal Marchand
People Inc.
We have reports that worked in RB9 that don't work anymore sinds we upgraded
to 12.05. We don't get distinct data anymore.
The queries were simple, and always seamed to include a "distinct"
statement.
With 12.05 we now get multiple records out.
Example:
Main pipeline on table "Jobs", field "Department". Group by "Department".
We only get distinct data, for example, deplartments A,B,C.
When adding another pipeline on "Job + Employees", we select the Job-->
Department field to link, and the employee's name for example, and group by
Jobs-->Department, name.
Preview this on it's own, we get all employees once.
Link those 2 pipelines together on "Department", we see in the preview that
the first pipeline still give back A, B, C, but the second will return all
employee names as many times as the values A, B and C exist in the database.
So if we have 10 Jobs in Department A, the employees of department A will
all be displayed 10 times.
Like the distinct is executed in the main pipeline, but lost during linking.
Is this normal behavior?
How can we avoid that in RB12.05?
Thanks,
Chantal Marchand
People Inc.
This discussion has been closed.
Comments
test. If not perhaps you can provide an example using a small sample
database or the DBDemos data that I can build and run here. IF so please
send to support@ in zip format.
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com