Bric_soap element list_ids: Is this a bug or am I misunderstanding the documentation?

Trying to list elements based on a search by output channel,
eg.
[gharrison]$  bric_soap element  --search
output_channel=EIAManualWeb
list_ids 

Generates the error below (note the duplicate
"element_type__output_channel ao" in the FROM
clause), but 
[gharrison]$   bric_soap element  --search
output_channel_id=1030
list_ids 
works.

Error Log tail:

Issuing rollback() for database handle being DESTROY'd
without explicit
disconnect() at
/usr/local/lib/perl5/site_perl/5.8.1/i686-linux/DBI.pm
line 1446, <GEN599> line 24.
[Fri Mar 30 15:47:45 2007] [error]
SOAP::Serializer::envelope: Server
Application error Unable to select column into arrayref:
DBD::Pg::db
selectcol_arrayref failed: ERROR:  Table name "ao"
specified more than
once
 [for Statement "
        SELECT DISTINCT a.id
        FROM   element_type a, member m, element_type_member
c, 
            element_type__output_channel ao,
element_type__output_channel ao
        WHERE  a.id = c.object_id AND c.member__id = m.id
AND m.active =
'1' 
              AND a.active = ? AND ao.element_type__id =
a.id 
              AND ao.output_channel__id = ? AND
ao.element_type__id =
a.id 
              AND ao.output_channel__id = ?
        ORDER BY a.id
    "] at /usr/local/bricolage/lib/Bric/Util/DBI.pm
line 1628, <GEN599>
line 24.

[/usr/local/bricolage/lib/Bric/Util/DBI.pm:1629]
[/usr/local/bricolage/lib/Bric/Biz/ElementType.pm:2107]
[/usr/local/bricolage/lib/Bric/Biz/ElementType.pm:528]
[/usr/local/bricolage/lib/Bric/SOAP/ElementType.pm:215]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Lite.pm:2322]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Transport/HTTP.pm
:286]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Transport/HTTP.pm
:464]
[/usr/local/bricolage/lib/Bric/SOAP/Handler.pm:169]
[/usr/local/bricolage/lib/Bric/SOAP/Handler.pm:249]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Lite.pm:2397]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Lite.pm:1196]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Lite.pm:805]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Lite.pm:2372]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Transport/HTTP.pm
:296]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Lite.pm:2365]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Transport/HTTP.pm
:286]
[/usr/local/lib/perl5/site_perl/5.8.1/SOAP/Transport/HTTP.pm
:464

On Mar 30, 2007, at 09:18, Harrison, George ((STEM)) wrote:

> Trying to list elements based on a search by output
channel, eg.
> [gharrison]$  bric_soap element  --search
output_channel=EIAManualWeb
> list_ids
>
> Generates the error below (note the duplicate
> "element_type__output_channel ao" in the FROM
clause), but
> [gharrison]$   bric_soap element  --search
output_channel_id=1030
> list_ids
> works.

Thanks George. Mind filing a bug report?

This one should be pretty easy to fix, if someone wants to
take it on.

Best,

David

David E. Wheeler <mailto:davidkineticode.com> wrote on
March 30, 2007
13:49 PM:

> On Mar 30, 2007, at 09:18, Harrison, George ((STEM))
wrote:
> 
>> Trying to list elements based on a search by output
channel, eg.
>> [gharrison]$  bric_soap element  --search
>> output_channel=EIAManualWeb list_ids 
>> 
>> Generates the error below (note the duplicate
>> "element_type__output_channel ao" in the
FROM clause), but
>> [gharrison]$   bric_soap element  --search
output_channel_id=1030
>> list_ids works.
> 
> Thanks George. Mind filing a bug report?
> 
> This one should be pretty easy to fix, if someone wants
to take it on.
> 
> Best,
> 
> David

Done. Bug #1284

gh