[Tickets #10535] DISTINCT sql query feature in Horde/Rdo/Query.php

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/10535
------------------------------------------------------------------------------
  Ticket             | 10535
  Created By         | lfbm.andamentos at gmail.com
  Summary            | DISTINCT sql query feature in Horde/Rdo/Query.php
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Enhancement
  State              | New
  Priority           | 1. Low
  Milestone          |
  Patch              | 1
  Owners             |
------------------------------------------------------------------------------


lfbm.andamentos at gmail.com (2011-09-20 03:31) wrote:

Zitat von Luis Felipe Marzagao/Andamentos <lfbm.andamentos at gmail.com>:

> Hello:
>
> Is this the recommended way of running a SELECT DISTINCT query with  
> Horde Rdo?
>
> $mapper = new OrderMapper();
>
> $query = new Horde_Rdo_Query($mapper);
> $query->setFields('DISTINCT client_id');
>
> $mapper->find($query);

That's more like a hack. We should add some feature to Horde_Rdo_Query  
instead that makes a query DISTINCT.

Jan.

- - - - - - - - - -

Attached is a suggestion.

Luis Felipe



lfbm.andamentos at gmail.com (2011-09-20 03:31) uploaded:  
0001-Added-sql-DISTINCT-query-feature.patch

http://bugs.horde.org/h/services/download/?module=whups&actionID=download_file&file=0001-Added-sql-DISTINCT-query-feature.patch&ticket=10535&fn=%2F0001-Added-sql-DISTINCT-query-feature.patch