Thanks for the bug report,
this is not a bug, the markup should look like:
(#(inherent:121|select count(distinct email) as email from aiki_users)#)
because in widget 121 there is no way to display the field name count(distinct
email) unless it's selected as a field that already exists in that widget.
mysql considers the full term:
count(distinct email) as a column
** Changed in: aikiframework
Status: New => Invalid
** Changed in: aikiframework
Assignee: (unassigned) => Bassel Safadi (bassel)
--
You received this bug notification because you are a member of Aiki
Framework Admins, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/736057
Title:
distinct don't work with inheried
Status in Aiki Framework:
Invalid
Bug description:
Proof.
select count(distinct email) from aiki_users
75766
on page http://www.openclipart.org/artists
883:
<td class="metric">Total Artists</td>
<td class="number">(#(inherent:121|select count(distinct email) from
aiki_users)#)</td>
121:
SQL: select count(id) from ocal_files where filename RLIKE '.svg' and
upload_published = 1
Content: [records_num]
renders:
Total Artists 80538 (without distinct)
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
