Makumba - set the void in the place where

Question

I am wondering if there is a way to check for a given void in the mak: list where clause.

I would like you to not have to do mak: list the asked question only for mak: lastCount its size.

+3

João Andrade Mar 17 '11 at 16:32

2 answers

hasSuppliers () can be defined simply as

hasSuppliers(){exists(FROM suppliers s)}

+1

Cristian bogdan Apr 04 '11 at 11:48

Rudolf mayer · Accepted Answer · 2011-03-17T16:52:35+0000

Yes, since you can use subqueries in the WHERE clause.

Using data definitions from http://www.makumba.org/page/DataModelHowto , i.e. company.Company with a set

suppliers = set company.Company

you can do something like

<mak:list from="company.Company c" where="(SELECT count(s) FROM c.suppliers s) > 0">
....
</mak:list>

You can also define this as a function in MDD, for example. as

hasSuppliers() { (SELECT count(s) FROM suppliers s) > 0 }

and then use it in your <mak: list> a

<mak:list from="general.Company c" WHERE="c.hasSuppliers()">
....
</mak:list>