Issue 111831 - Base: Distinct values button has no effect
Summary: Base: Distinct values button has no effect
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO320m17
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2010-05-25 21:44 UTC by jimmyjazz
Modified: 2010-06-19 15:24 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
choose Queries->"distinct values"->edit, Run Query, Distinct Values (15.48 KB, application/vnd.sun.xml.base)
2010-05-26 13:09 UTC, jimmyjazz 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jimmyjazz 2010-05-25 21:44:06 UTC 
All values within a Base query view are shown as before (twice ore more) after klicking the 'Distinct values' button. Each of them should be shown only one time. Also appears in 3.1.1 / Linux.
Comment 1 r4zoli 2010-05-26 11:37:01 UTC 
I can not confirm it, I tested in OOo 3.2 and 3.2.1RC1 and DEV300_m78 works in
all versions on win7.

@ jimmyjazz 
Please upload an example file where you find this problem, without confidential
data.
Comment 2 jimmyjazz 2010-05-26 13:09:53 UTC 
Created attachment 69635 [details]
choose Queries->"distinct values"->edit, Run Query, Distinct Values
Comment 3 r4zoli 2010-05-26 14:06:28 UTC 
If you switch ON "Distinct values" you must run query again, then new query will
contain distinct values only.

If you switch OFF then run query again, an will show all data.

Not forget this is a Query design window, and Distinct values on "Design"
toolbar, not on "Table data" toolbar.
Comment 4 jimmyjazz 2010-05-26 19:08:23 UTC 
@ r4zoli sorry for any inconvenience. Shouldn't teach myself using a book that
is very detailed and suddenly lacks information...
Comment 5 Mechtilde 2010-06-19 15:24:58 UTC 
invalid -> closed