http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5786
Srdjan Jankovic <srd...@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |In Discussion --- Comment #67 from Srdjan Jankovic <srd...@catalyst.net.nz> --- That did not happen to me: Server version: 5.5.24-0ubuntu0.12.04.1 (Ubuntu) mysql> SELECT opacitemholds,categorycode,itemtype,branchcode FROM issuingrules WHERE -> (issuingrules.categorycode = 'Adult' OR issuingrules.categorycode = '*') -> AND -> (issuingrules.itemtype = 'AGN' OR issuingrules.itemtype = '*') -> AND -> (issuingrules.branchcode = 'N' OR issuingrules.branchcode = '*') -> ORDER BY -> issuingrules.categorycode desc, -> issuingrules.itemtype desc, -> issuingrules.branchcode desc; +---------------+--------------+----------+------------+ | opacitemholds | categorycode | itemtype | branchcode | +---------------+--------------+----------+------------+ | 1 | * | AGN | N | | 1 | * | * | * | +---------------+--------------+----------+------------+ 2 rows in set (0.00 sec) On a general note, we should have a centralised rule picker. I remember writing one some years ago, but it seems to have been lost. On an even more general note, issuingrules table is just so wrong. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/