Hi Joelle,
For the linking between borrower and borrower attributes you want to say
which borrower attribute you want via the code and you may want to specify
the value like this:
select b.cardnumber from borrowers b join borrower_attributes ba on
ba.borrowernumber = b.borrowernumber where ba.co
Hi James,
One simple way to handle it is with a case statement. The
following example has a static between filter for the dates but it
illustrates this approach. You can also do some cleaning to make sure there
aren't spaces in front and it assumes that all of your DDC numbers in fact
start with
You can just select the value then, take out the "and ba.attribute = 'YES'"
and add ba.attribute to your select statement.
On Fri, Mar 6, 2020 at 12:01 PM Joelle Hannert wrote:
> Sorry, I should have been more clear. I'm not trying to select on the
> BANNERHOLD status (YES/NO/blank), I just want
Hi James,
If I'm understanding correctly you want an additional row giving a sum of
all the numbers in addition to the per class one? The simplest way it
occurs to me to do that is with a UNION ALL statement. I've taken some
filters out for brevity but this illustrates the approach:
SELECT CON
Hi James,
The query I posted worked with my quick test. Could you post your query as
it is now?
On Sat, Mar 14, 2020 at 9:52 AM muiru james wrote:
> Hi Rogan and All,
>
> I cant thank you enough for the tremendous effort you have put towards
> helping me solve my problem.
>
> You do indeed u
Hi James,
A few thoughts from skimming it.
1) I don't see where you're using biblioitems anywhere in the report unless
I'm just not seeing it so you probably don't need it for a join. I don't
think it'll hurt anything other than slow the report less than you'll even
notice but still ... if not
Hi Lisa,
If you're just looking to use the branch column in statistics you can add
it to your select list and then to the group by. So the select line
would become something like this:
SELECT YEAR(statistics.datetime) AS Year, MONTH(statistics.datetime) AS
Month, DAY(statistics.datetime) AS Day,
So, just to make sure I understand, deleting all the bibs and associated
items but leaving everything else, right?
On Tue, Jul 7, 2020 at 9:40 AM Heinz-Jürgen Oertel
wrote:
> Hello
>
> I'm looking for a way to delete the complete content of a biblio instance,
> not
> the instance itself in order
Well, it depends.
If you only have bibs and items loaded this should work:
SET FOREIGN_KEY_CHECKS = 0;
truncate biblio;
truncate biblioitems;
truncate items;
truncate auth_header;
truncate sessions;
truncate zebraqueue;
truncate biblio_metadata;
SET FOREIGN_KEY_CHECKS = 1;
However, if you've ha
Those are commands to run from a MySQL command prompt.
SET FOREIGN_KEY_CHECKS = 0; basically turns off FK integrity so it should
always be used carefully and on a live system only as a last resort. The
truncates cleanout tables and the last one turns the FK checks back on.
Every rare now and the
Hi Heinrich,
You may be running into this issue:
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
On Tue, Jul 14, 2020 at 3:18 AM Heinrich Hartl wrote:
> From koha/about
>
>
> Problems found
>
> Patrons
> The following ids exist in both tables *borrowers* and *deletedborrowers*:
Same, I can't imagine anyone objecting to more useful stuff on the wiki.
On Thu, Nov 5, 2020 at 4:44 PM Michael Kuhn wrote:
> Hi Alvaro
>
> > Would it be possible to create a koha wiki for sharing scripts? Koha
> > has reports, css and js wikis for sharing them with the community. I
> > guess
Hello,
You're 99% of the way there already, you are already using the items table
so you just need to add "items.ccode,items.location," in the appropriate
place, like this:
SELECT items.Barcode,biblio.Author,biblio.Title AS
Titles,biblioitems.Pages,biblioitems.Editionstatement AS
Edition,biblio.
I don't have strong opinions about whether or not to change wiki softwares
but I do have quite a bit of experience in using DokuWiki and while it does
have its own syntax it's not burdensome or awkward. Most users use the
formatting toolbar options and don't worry about the syntax much.
On Wed,
Hi George,
I'm not familiar with any documentation but both schemas are public and as
someone who does migrations to both routinely I don't think migrating
between them would be problematic at all though it will require a
familiarity with both database structures.
On Tue, Jun 11, 2024 at 6:45 AM
Evergreen has tools both in the staff client and via command line to export
bibs with holdings embedded.
On Tue, Jun 11, 2024 at 8:36 AM Dr. Yesan S (DLIS)
wrote:
> Hi
> If the data is in excel sheet it can be easily migrated to koha. I think,
> in Evergreen there must be a way forward to export
16 matches
Mail list logo
