[Bond-users] Filtering the outputya

[Dru Hill]

You can use a <widget> tag within your SQL query to change hte where clause,
for both dropdowns and check boxes. Ie

select * from person where isdeleted=false <widget prefix=" and canswim='" postfix="'" nullalternative="">canswimwidget</widget>

You can do similar logic around if a variable is null or not and how to mold your sql
queries around values.
You can also dynamically change the columns in a list based on the results of a sql query.


On Sun, Jun 30, 2013 at 02:50:21PM +0400, Vladimir Voznesensky wrote:
> Hello.
> 
> May Bond form an output of SELECT with a variable list of WHERE 
> conditions? This list may be formed by, say, a set of checkboxes: each 
> checked checkbox enables some condition.
> 
> Thank you.
> 
> - VV
> 
> _______________________________________________
> Bond-users mailing list
> Bond-users at lists.hcoop.net
> https://lists.hcoop.net/listinfo/bond-users

-- 
Dru Hill
Managing Director

Treshna Enterprises Ltd
EPIC Sanctuary
78-106 Manchester St
Christchurch 8011
New Zealand

Phone: 64 3 3663649 ext 203
http://www.treshna.com