[Koha] Acquisition module

[James Ghiorzi]

Hi Nicole,

Thanks for the correction :)

Respectfully,

James Ghiorzi
Library Assistant II
San Benito County Free Library
470 Fifth St.
Hollister, CA 95023
(831) 636-4107

________________________________
From: Nicole Engard [nengard at gmail.com]
Sent: Monday, November 07, 2011 9:52 AM
To: James Ghiorzi
Cc: Massimo Plevani; koha at lists.katipo.co.nz
Subject: Re: [Koha] Acquisition module

James,

That won't do the trick - but this will:

SELECT name from aqbooksellers order by name asc

And you're right about not being able to delete.

Nicole

2011/11/7 James Ghiorzi <JGhiorzi at lib.co.san-benito.ca.us<mailto:JGhiorzi at lib.co.san-benito.ca.us>>
Hi Massimo,

I believe that there is currently no way to delete a vendor using the client interface (there might be a way using SQL, but I wouldn't know how to do it).

The list of vendors here is my amateurish stab at it:


SELECT v.name<http://v.name> AS vendor
FROM aqorders o
Order by v.name<http://v.name> ASC

Hope that helps,

James Ghiorzi
Library Assistant II
San Benito County Free Library
470 Fifth ST.
Hollister, CA 95023



________________________________
From: koha-bounces at lists.katipo.co.nz<mailto:koha-bounces at lists.katipo.co.nz> [koha-bounces at lists.katipo.co.nz<mailto:koha-bounces at lists.katipo.co.nz>] On Behalf Of Massimo Plevani [max_pleva at hotmail.it<mailto:max_pleva at hotmail.it>]
Sent: Monday, November 07, 2011 8:19 AM
To: koha at lists.katipo.co.nz<mailto:koha at lists.katipo.co.nz>
Subject: [Koha] Acquisition module

Dear all,
I started to work with acquisition module. I have some questions:

1. How can I delete a vendors?
2. Can I see the list of vendors (e.g Alphabeticaly ordered)?

Thanks you for your help. All the best.

Massimo Plevani

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
http://lists.katipo.co.nz/mailman/listinfo/koha


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111107/1df4964c/attachment-0001.html>