Java connector problems when using select distinct

Suite and Optimus Suite 5
#1

Hi,

I have a connector defined where the SQL has a select distinct. For example:

select distinct id,name,address,dob,tel from people....

I am using dynamic loading.

It seems like 2 queries are run. The query above and

select count(*) from people....

Because the second query ignores the distinct keyword the count includes the duplicates and breaks filtering and displays blank rows.

Is this a bug? Or expected behaviour? If the latter how can I overcome this?

#2

Unfortunately connector doesn’t support sql-queries with distinct keyword and dynamic loading.

#3

Is this something that can be added in future version?

#4

You may create mysql-view which may be used as a table without DISTINCT word.
Then you may use it in connector requests.