[Bond-users] Multiple selection

[Ezra Tucker]

Hi Vladimir,

I think what you may be looking for could involve using a WITH clause in your SQL query:
www.postgresql.org/docs/9.2/static/queries-with.html
It's useful if you're trying to query a query.
For viewing it, I'd use a dynamic list (dynamic="true") in Bond:
<list dynamic="true" sortable="true" name="myquery-outputs">
  <dbobject name="myquery-outputs">
    <sql>
      WITH (…)
      SELECT (…) FROM (…)
    </sql>
  </dbobject>
  <column title="?">
    <field/>
  </column>
</list>
I personally might shy away from using VALUES lists- fine for having static values, but bad if you would ever want to change it.
Another option-- if you're interested in still using VALUES, or executing a dynamic query, I might recommend writing a function in pl/pgsql that EXECUTEs a string as a query.

Does that help?

-Ezra

Ezra R. Tucker
Senior Analyst | Altenex LLC
7 Liberty Square | Boston, MA 02109
t: 617.500.0105 | m: 818.203.0269
ezra.tucker at altenex.com
www.altenex.com

On Jul 1, 2013, at 1:24 PM, Vladimir Voznesensky <voznesensky at rts.ru> wrote:

> Hello.
> 
> Does Bond have a possibility to select several items from a result of 
> some query?
> It could be used in VALUES lists ( 
> http://www.postgresql.org/docs/9.2/static/queries-values.html ).
> 
> Thank you.
> 
> - VV
> 
> _______________________________________________
> Bond-users mailing list
> Bond-users at lists.hcoop.net
> https://lists.hcoop.net/listinfo/bond-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.hcoop.net/pipermail/bond-users/attachments/20130701/c377cefb/attachment.htm