[Bond-users] Multiple selection
Ezra Tucker
ezra.tucker at altenex.com
Tue Jul 2 08:43:59 EDT 2013
Ah! I think I understand your question better now. You would like it if multiple rows in a list were selectable- is this correct? For example if you wanted to delete specific rows by selecting multiples and pressing a delete button?
That is indeed a good question. And I don't know the answer to it. However, I would be curious to find out! Sorry I can't be more help in this matter.
-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 2, 2013, at 2:09 AM, Vladimir Voznesensky <voznesensky at rts.ru> wrote:
> Hello.
>
> Erza, thanks for your answer.
>
> Well, PostgreSQL is pretty flexible for managing sets and subsets. Unfortunately, I cannot find a Bond way for an GUI end-user to mark a subset of the list in Bond, so your fair explanation does help to not solve the main problem.
>
> It seems that there is now way in current Bond to mark a subset of some query result set (using Ctrl-click on the GTK+ tree widget or so). Is it true?
>
> Thanks in advance.
>
> 01.07.2013 22:02, 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 ).
>
> _______________________________________________
> 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/20130702/8c8cd647/attachment-0001.htm
More information about the Bond-users
mailing list