Procurei mas não achei onde.
Alguém sabe dizer se há no koha, como saber quais são os termos mais pesquisados no OPAC?
Gustavo, encontrei na comunidade internacional dois relatórios, veja se atende:
Most Popular Searches
Purpose: Find popular search terms
SELECT COUNT() AS Count,*
RIGHT(
query_desc,
Length(query_desc) - Instr(query_desc, ‘:’)
) AS ‘Search string’
FROM search_history
GROUP BY RIGHT(query_desc, Length(query_desc) - Instr(query_desc, ‘:’))
ORDER BY COUNT() DESC*
Most Popular Searches II
Purpose: Find popular search terms
SELECT search_history.sessionid,
search_history.query_desc,
search_history.type,
search_history.total,
search_history.time,
borrowers.branchcode,
borrowers.categorycode
FROM search_history
JOIN borrowers ON (search_history.userid=borrowers.borrowernumber)
JOIN branches ON (borrowers.branchcode=branches.branchcode)
WHERE borrowers.branchcode=<<
SELECT Library|branches>>
AND search_history.time BETWEEN <<SEARCH history TIMESTAMP BETWEEN (yyyy-mm-dd)|date>> AND <<AND (yyyy-mm-dd)|date>>
O primeiro apresentou a seguinte mensagem de erro ao ser executado
O segundo também deu erro, com a seguinte mensagem
Gustavo, observei que o editor mudou o código. Tenta acessar o link https://wiki.koha-community.org/wiki/SQL_Reports_Library#Most_Popular_Searches
e procurar (Crtl+F) por ‘Most Popular Searches’
e veja se dá o mesmo erro.
Tentei colar o código novamente agora sem deixar o editor do fórum alterar automaticamente:
Opção 1
SELECT COUNT(*) AS Count,
RIGHT(
query_desc,
Length(query_desc) - Instr(query_desc, ':')
) AS 'Search string'
FROM search_history
GROUP BY RIGHT(query_desc, Length(query_desc) - Instr(query_desc, ':'))
ORDER BY COUNT(*) DESC
Opção 2
SELECT search_history.sessionid,
search_history.query_desc,
search_history.type,
search_history.total,
search_history.time,
borrowers.branchcode,
borrowers.categorycode
FROM search_history
JOIN borrowers ON (search_history.userid=borrowers.borrowernumber)
JOIN branches ON (borrowers.branchcode=branches.branchcode)
WHERE borrowers.branchcode=<<
SELECT Library|branches>>
AND search_history.time BETWEEN <<SEARCH history TIMESTAMP BETWEEN (yyyy-mm-dd)|date>> AND <<AND (yyyy-mm-dd)|date>>
Muito obrigado Ingrid.
Essa segunda opção já nos deu um resultado.
Agora vou trabalhar os ajustes por aqui.
Obg.