[Koha-bugs] [Bug 23991] Move SearchSuggestion to Koha::Suggestions

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23991

Tomás Cohen Arazi <tomascohen at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |BLOCKED

--- Comment #20 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
Looking. I'm investigating this query log differences:

before:

                   242 Query    select DISTINCT(STATUS) as value, count(*) as
cnt from suggestions group by value order by STATUS
                   242 Query    SELECT COUNT( * ) FROM `suggestions` `me` WHERE
( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) )
                   242 Query    select DISTINCT(managedby) as value, count(*)
as cnt from suggestions group by value order by managedby
                   242 Query    select DISTINCT(acceptedby) as value, count(*)
as cnt from suggestions group by value order by acceptedby
                   242 Query    select DISTINCT(suggestedby) as value, count(*)
as cnt from suggestions group by value order by suggestedby
                   242 Query    select DISTINCT(budgetid) as value, count(*) as
cnt from suggestions group by value order by budgetid


after:

                   242 Query    select DISTINCT(STATUS) as value, count(*) as
cnt from suggestions group by value order by STATUS
                   242 Query    SELECT COUNT( * ) FROM `suggestions` `me` WHERE
( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) )
                   242 Query    select DISTINCT(managedby) as value, count(*)
as cnt from suggestions group by value order by managedby
                   242 Query    select DISTINCT(acceptedby) as value, count(*)
as cnt from suggestions group by value order by acceptedby
                   242 Query    select DISTINCT(suggestedby) as value, count(*)
as cnt from suggestions group by value order by suggestedby
                   242 Query    select DISTINCT(budgetid) as value, count(*) as
cnt from suggestions group by value order by budgetid
                   242 Query    SELECT COUNT( * ) FROM `suggestions` `me` WHERE
( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) )
                   242 Query    SELECT COUNT( * ) FROM `suggestions` `me` WHERE
( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) )
                   242 Query    SELECT `me`.`suggestionid`, `me`.`suggestedby`,
`me`.`suggesteddate`, `me`.`managedby`, `me`.`manageddate`, `me`.`acceptedby`,
`me`.`accepteddate`, `me`.`rejectedby`, `me`.`rejecteddate`,
`me`.`lastmodificationby`, `me`.`lastmodificationdate`, `me`.`STATUS`,
`me`.`archived`, `me`.`note`, `me`.`author`, `me`.`title`,
`me`.`copyrightdate`, `me`.`publishercode`, `me`.`date`, `me`.`volumedesc`,
`me`.`publicationyear`, `me`.`place`, `me`.`isbn`, `me`.`biblionumber`,
`me`.`reason`, `me`.`patronreason`, `me`.`budgetid`, `me`.`branchcode`,
`me`.`collectiontitle`, `me`.`itemtype`, `me`.`quantity`, `me`.`currency`,
`me`.`price`, `me`.`total` FROM `suggestions` `me` WHERE ( ( `STATUS` = 'ASKED'
AND `archived` = '0' AND `branchcode` = 'CPL' ) )
                   242 Query    SELECT `me`.`module`, `me`.`page`,
`me`.`tablename`, `me`.`columnname`, `me`.`cannot_be_toggled`, `me`.`is_hidden`
FROM `columns_settings` `me` WHERE ( ( `module` = 'acqui' AND `page` =
'suggestions' AND `tablename` = 'suggestions' ) )
                   242 Query    SELECT COUNT( * ) FROM `suggestions` `me` WHERE
( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) )

-- 
You are receiving this mail because:
You are watching all bug changes.