[Koha] Need reports help

[Elaine Bradtke]

Thanks,
I was patching together two reports into one and missed that crucial bit!
Elaine

On Mon, Jun 3, 2013 at 7:02 PM, Bernardo Gonzalez Kriegel <
bgkriegel at gmail.com> wrote:

> Elaine,
> I have the following report:
>
>>
>>
>> SELECT  biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated
>> FROM items LEFT JOIN biblioitems on
>> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
>> on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
>> items.homebranch='VWML' AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <=
>> biblio.datecreated
>>   ORDER BY biblio.title ASC
>>
>>
>> But it only returns information if there are item records attached,  what
>> I
>> really want is a list of everything catalogued.
>>
>
> It does that because you begin you query with items table.
> Perhaps this modified query could help you, but without homebranch
> information
>
> SELECT
>   biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated
> FROM
>   biblioitems
>   LEFT JOIN
>   biblio on (biblioitems.biblionumber=biblio.biblionumber)
> WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= biblio.datecreated
> ORDER BY biblio.title ASC;
>
> Regards,
> Bernardo
>



-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)