Public bug reported:
If you use certain sub-queries then pagination breaks. For example:
select username from aiki_users where usergroup in (select id from
aiki_users_groups)
This query should return every single user. If you set this widget at
let's say "Records per page: 10" than it does return 10 records but does
not show the paginations links at the bottom. You can still manually
page through by setting the page= attribute in the URL.
The 'where fieldname in (subquery)' must be breaking the algorithm that
is counting the results and drawing the page navigation.
** Affects: aikiframework
Importance: High
Status: New
** Affects: openfontlibrary
Importance: Undecided
Status: New
** Changed in: aikiframework
Importance: Undecided => High
** Changed in: aikiframework
Milestone: None => 0.9
--
You received this bug notification because you are a member of Aiki
Framework Admins, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/797412
Title:
pagination breaks using SQL like where fieldname in (subquery)
Status in Aiki Framework:
New
Status in Open Font Library:
New
Bug description:
If you use certain sub-queries then pagination breaks. For example:
select username from aiki_users where usergroup in (select id from
aiki_users_groups)
This query should return every single user. If you set this widget at
let's say "Records per page: 10" than it does return 10 records but
does not show the paginations links at the bottom. You can still
manually page through by setting the page= attribute in the URL.
The 'where fieldname in (subquery)' must be breaking the algorithm
that is counting the results and drawing the page navigation.
To manage notifications about this bug go to:
https://bugs.launchpad.net/aikiframework/+bug/797412/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
