i check it again and it works. The only problem is: if widget have a normal_select that doesn't return any record, the (sql( will be no executed. But it's not a bug: if widget behavior.
** Changed in: aikiframework Status: Confirmed => Fix Released -- You received this bug notification because you are a member of Aiki Framework Developers, which is subscribed to aikiframework. https://bugs.launchpad.net/bugs/760414 Title: SQL COUNT doesn't display if called inside a widget Status in Aiki Framework: Fix Released Bug description: Say I need to display the number of a certain batch of records that have been returned from within an inner-widget sql. I would type something like: (sql( (SELECT COUNT(some_field) as 'number' FROM some_table || [-[number]-] ) )sql) The sql appears to execute, but I can't get the number to output to display on a webpage. I've also tried to use the global variable [records_num] within the inner-SQL & that also fails to display. The same SQL statement, if inserted in the Aiki Query section (and [-[number]-] is switched to ((number)) ), will execute as expected. To manage notifications about this bug go to: https://bugs.launchpad.net/aikiframework/+bug/760414/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~aikiframework-devel Post to : aikiframework-devel@lists.launchpad.net Unsubscribe : https://launchpad.net/~aikiframework-devel More help : https://help.launchpad.net/ListHelp