Public bug reported:
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.
** Affects: aikiframework
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Aiki
Framework Admins, 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:
New
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.
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
