Time  Nick          Message
06:36 alex_a        Bonjour
06:38 reiveune      hello
06:59 TimothyAlexis Instead of me developing a custom solution to filter the #checkoutst table on opac-user.pl, I would much rather receive help to implement the standard solution described here: https://wiki.koha-community.org/wiki/DataTables_HowTo#Adding_by-column_filtering . I have followed the instructions to the best of my ability and have reached a stop.
07:00 TimothyAlexis Is there anyone here who understands how it works? I think it looks simple enough.
07:00 TimothyAlexis So really clueless as to why it doesn't work.
07:11 fridolin      hi there
07:11 * fridolin    is back full time o/
07:14 davewood      hello everyone. im tasked with doing some development for koha and would like to know whats the recommended branch to base new development on.
07:15 magnuse       welcome back fridolin
07:15 magnuse       davewood: master
07:15 cait1         davewood: what magnuse said :)
07:15 cait1         on the wiki there should be helpful info on all that
07:16 cait1         you'll also want to look at the coding guidelines
07:16 magnuse       https://wiki.koha-community.org/wiki/Developer_handbook
07:17 magnuse       here's hoping someone can be provoked to expand on this: https://wiki.koha-community.org/wiki/Translating_plugins ;-)
07:18 fridolin      magnuse: thanks ;) i'm a lot rusty
07:18 magnuse       hehe, you'll figure it out :-)
07:22 fridolin      magnuse: what do you mean ? whats missing ?
07:25 ashimema      TimothyAlexis: You've probably picked one of the more complicated tables to work with as a first try..
07:26 TimothyAlexis ::D
07:27 TimothyAlexis I don't know, it looks very simple to me. 3 steps really.
07:27 ashimema      if memory serves.. it's both an AJAX table and has a bunch of additional customisation added on top to do grouping
07:27 TimothyAlexis Add <input type="text" class="filter" data-column_num="1" placeholder="Search on 2nd column" />
07:27 ashimema      so.. where are you stuck?
07:27 TimothyAlexis Put the table in a variable
07:27 TimothyAlexis Use that variable (replace my_table) and put this after the dataTable call: my_table.fnAddFilters("filter", 500);    // 2nd parameter is optional
07:28 TimothyAlexis Works fine in other pages.
07:28 ashimema      bug 15235
07:28 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15235 enhancement, P5 - low, ---, julian.maurice, Failed QA , Add column filters to checkouts table
07:29 ashimema      bug 24533
07:29 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24533 enhancement, P5 - low, ---, martin.renvoize, Failed QA , Improved sorting in checkouts table
07:29 ashimema      those two bugs already look at affecting the filtering and ordering of that table..
07:29 davewood      2 GB git repo, thats quite some data!
07:30 ashimema      that's tiny compared to a couple of weeks back davewood ;)
07:30 ashimema      We've recently squashed and cleaned
07:30 ashimema      it was upto somthing mad like 7!
07:30 davewood      good timing
07:30 ashimema      once we have a new server it'll shrink a little more too we hope..
07:31 ashimema      the process was run on a rather old version of git in our central repo
07:31 davewood      has anyone made an attempt to run koha with docker instead of vagrant?
07:31 ashimema      nice to have you aboard btw.. always nice to see new faces :)
07:31 ashimema      koha-testing-docker ;)
07:31 ashimema      https://gitlab.com/koha-community/koha-testing-docker
07:32 ashimema      an nice simple, developer focused, docker environment
07:32 ashimema      I believe there are a few production focused efforts going on too
07:33 ashimema      TimothyAlexis.. how far have you gotten through your attempts?
07:33 ashimema      Would you like me to raise jajm to rebase bug 15235 ?  I'm not sure how much he's still looking after that bug, but I'm sure he'd appreciate some testing.
07:33 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15235 enhancement, P5 - low, ---, julian.maurice, Failed QA , Add column filters to checkouts table
07:33 TimothyAlexis It works fine as implemented in aqbudgets.tt, shelves.tt, claims.tt and some other. Looking at the code there and looking at the instructions on the wiki, making those 3 lines of additions to the code should be enough.
07:34 ashimema      have you tried?
07:35 TimothyAlexis Yes, I've tried putting the input field in different places, inside the table, outside the table, in the tfoot. I've also tried setting the data-column_num to different numbers.
07:36 TimothyAlexis I tried defining the code for the #checkedoutst table separately (It's included in a loop)
07:36 TimothyAlexis Sorry, #checkoutst
07:38 TimothyAlexis The field is there but when editing it, nothing happens with the table. So one thing I've been thinking is if the fnAddFilters function requires anything additional to work.
07:38 TimothyAlexis I mean, anything additional besides the [% INCLUDE 'datatables.inc' %] which is already there.
07:40 ashimema      hmm
07:40 ashimema      checkoutst.. where is that..
07:40 ashimema      I think I'm looking at the wrong page
07:40 TimothyAlexis opac-user.tt
07:41 ashimema      oapc
07:41 ashimema      doh!
07:41 ashimema      I was thinking staff
07:41 TimothyAlexis :)
07:41 ashimema      bug 15235
07:41 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15235 enhancement, P5 - low, ---, julian.maurice, Failed QA , Add column filters to checkouts table
07:42 ashimema      interestingly.. he seems to do staff and opac
07:43 ashimema      oh no he doesn't
07:45 TimothyAlexis I added this as line 198 (below the table caption) > 198   data-column_num="1" placeholder="Search on 2nd column" />
07:45 ashimema      ok.. so have you got yourself a bugzilla account and added a bug to show your intention to work on this?
07:45 TimothyAlexis The dataTable call is around line 800
07:46 TimothyAlexis So I changed that call to define a variable: var bTable = $(this).dataTable($.extend(true, {},
07:46 TimothyAlexis And then after the call I added this line: bTable.fnAddFilters("filter", 500);
07:47 TimothyAlexis That's all there seems to be to it. :D
07:48 TimothyAlexis Before I add a bug, I need to know if it's not me misunderstanding how to implement it.
07:48 ashimema      it sounds about right to me
07:48 ashimema      but to be honest it's been a while since I've added such a filter
07:50 ashimema      so your wanting to filter on 'title' right
07:50 TimothyAlexis Well, when I get it working I will filter on the renew column.
07:53 ashimema      ok.. looks like all the tables are instantiated under one variable..
07:53 ashimema      weird
07:55 ashimema      there's some interesting code in the instantiation loop
07:55 ashimema      seems we disable searching on anything that's not sortable
07:58 TimothyAlexis this? { "targets": [ "nosort" ],"sortable": false,"searchable": false },
07:58 ashimema      indeed
07:59 ashimema      right..
07:59 ashimema      you variable definition there is out of whack
07:59 ashimema      look at the code.. it's a loop
07:59 ashimema      so.. bTable will be getting redifined with each iteration of the loop
08:00 TimothyAlexis I tried extracting #checkoutst from the loop.
08:00 ashimema      I think if you want to treat this table differently you'll need to take it out of the loop
08:01 TimothyAlexis :\
08:05 TimothyAlexis Hmm...
08:05 ashimema      any console errors ?
08:05 TimothyAlexis The fnAddFilters is in the intranet-tmpl/prog/js/datatables.js file
08:07 TimothyAlexis But not in opac-tmpl/bootstrap/js/datatables.js
08:07 TimothyAlexis That's probably it
08:07 ashimema      yup
08:07 ashimema      I was just about to say the same
08:08 ashimema      perhaps we use different datatables versions in the opac
08:08 ashimema      I'll check for you
08:11 TimothyAlexis Thank you :)
08:17 ashimema      brb.. just need a coffee ;)
08:19 TimothyAlexis I quit coffee after I found this: https://translate.google.com/translate?sl=sv&tl=en&u=http%3A%2F%2Ffreealization.com%2Fpresentation%2Falkaloider.html
08:19 TimothyAlexis That's some scary stuff considering so many are addicted to it... :/
08:45 ashimema      hmm.. are you likely to be around later today TimothyAlexis ?
08:45 ashimema      I think oleonard is your best bet for help on this
08:48 ashimema      they do appear to be different datatables versions.. with different sets of kohja customisations
08:51 ashimema      aha
08:51 ashimema      fnFilter(string, column_index)
08:51 TimothyAlexis Yeah I see that too. I could add "Allow filtering in opac jQuery datatables" to bugzilla.
08:52 ashimema      see opac-account.tt for some filtering that happens in the opac already.. that's a hard coded filter.. but passing the variable from an input should work similarly
08:52 ashimema      lines 99 - 111
08:52 ashimema      hope it helps
08:53 TimothyAlexis Thank you ashimema.
08:54 TimothyAlexis I will look at it after lunch.
08:56 TimothyAlexis ashimema, thank you for the help, it really made my day a better experience.
08:56 ashimema      indeed.. it would be even nicer to add a generic filtering function like that in intranet to the opac so adding filters is simpler in the future
08:56 ashimema      I imagine it would be very similar to the one in intranet-tmpl/prog/js/datatables.js
08:57 ashimema      :)
08:57 ashimema      no worries
09:31 magnuse       ashimema++
11:07 oleonard      Hi #koha
11:12 magnuse       hiya oleonard
11:50 caroline      cait: I am QAing, just very much after the fact, hehe!
11:50 caroline      Pootle just makes it very obvious since it's just the sentence and nothing else
11:54 tcohen        morning
12:06 oleonard      Hi tcohen
12:12 TimothyAlexis Which component, in Bugzilla, would be the correct choice for "Allow the datatables filtering functions from intranet to also function in OPAC"
12:15 cait          TimothyAlexis: they do
12:15 cait          wll we chose not to allow the options for users as it's mostly used by the library to define columns... but the libraris shoudl be there?
12:15 cait          othewise i'd select OPAC or templates
12:16 oleonard      TimothyAlexis do you mean the form fields at the top of table columns that allow you to search the contents of that column?
12:16 cait          thx oleonard - i had a long presentation this morning, I am probably not making much sense :)
12:17 oleonard      cait I read a little of the previous conversation so I think that's what we're talking about
12:17 TimothyAlexis oleonard: Yeah the fnAddFilters function described here: https://wiki.koha-community.org/wiki/DataTables_HowTo#Adding_by-column_filtering
12:17 cait          which table are you thinking of?
12:18 oleonard      TimothyAlexis are you preparing a patch? If so please incorporate a way to make the feature optional for libraries
12:18 TimothyAlexis cait: The table showing checked out items.
12:19 cait          are you aware that there already are tables in the opac that can be column configured? just the choiceoption for users is missing
12:20 oleonard      TimothyAlexis I would also consider whether column-specific filtering is required or whether a single search form would be adequate. I would find that to be acceptable non-optional change since it doesn't introduce a lot of new complexity for the user.
12:22 cait          i can imagine th eprint and download might be nice on the checkouts table
12:22 cait          but not usre how dependent all that is on each other
12:22 oleonard      cait I agree
12:22 TimothyAlexis I agree.
12:23 TimothyAlexis It would be best to keep it simple and standard.
12:23 TimothyAlexis The specific situation is with the table showing checked out items for patrons. We have some who have hundreds of checked out items and it could be convenient to filter the list.
12:25 TimothyAlexis The simplest we could do is to allow sorting on the "Renew" column. That was the initial suggestion we got. Then it was proposed that allowing a filter could be even more convenient.
12:26 oleonard      What would sorting on the "renew" column sort by?
12:26 TimothyAlexis Number of renewals left.
12:27 oleonard      That could be done too. We'd need to sort by some hidden data but it would be doable.
12:28 TimothyAlexis I think it would be easier.
12:29 TimothyAlexis simply removing the "nosort" on that column allows for a standard sorting.
12:29 TimothyAlexis We have this kind of info in that column "Automatic renewal (1 of 5 renewals remaining)"
12:35 oleonard      TimothyAlexis I encourage you to file separate enhancement bugs for the OPAC for the two ideas: table filtering and renewal sorting.
12:42 TimothyAlexis oleonard or let it go, it seems to currently be a a lot of work for a minor, supposed benefit.
12:44 TimothyAlexis The main benefit here is to group items by that column, which is actually achieved when removing class="nosort" on our specific installation.
12:46 TimothyAlexis Which is very simple.
12:48 cait          TimothyAlexis: i thnk the ideas have merit and you should file th bugs
12:48 cait          and if it gets into Koha... you will have one less customization to think about
12:48 cait          you can file a bug without having to provide a patch - you can also log ideas
12:50 TimothyAlexis I like how ashimema put it "[10:56] <ashimema> indeed.. it would be even nicer to add a generic filtering function like that in intranet to the opac so adding filters is simpler in the future"
12:51 oleonard      I think it's a very special case where a column-specific filter is required, and most tables don't fit that requirement.
12:53 TimothyAlexis I'm thinking an enhancement is only an enhancement if it actually makes real sense in real situations.
12:55 TimothyAlexis If we're talking about this specific situation we are talking about a "perhaps it would be nice to have" for a few patrons in one library.
12:56 oleonard      andreashm is in whatever altered state did was in the other day
12:56 oleonard      Unstuck in time
13:23 TimothyAlexis Thanks for the help today, wishing bliss to you all.
14:02 Joubu         bug 25570 needs QA
14:02 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25570 normal, P5 - low, ---, tomascohen, Signed Off , Listing requests should be paginated by default
14:22 andreashm     oleonard: haha.
14:22 andreashm     weird, wonder what happened to my irc client earlier.
15:12 reiveune      bye
15:49 tcohen        anyone with CCL searching experience?
15:53 tcohen        c'mon, we are the biggest project in the workd using Zebra
15:54 tcohen        :-D
15:54 oleonard      @seen jcamins
15:54 huginn        oleonard: jcamins was last seen in #koha 2 years, 2 weeks, 5 days, 17 hours, 3 minutes, and 38 seconds ago: <jcamins> cait: probably 561.
15:54 oleonard      ;)
15:54 caroline      tcohen, what're looking to know? One of my colleagues is very well versed in zebra
15:56 tcohen        I'm performing a really simple search
15:56 tcohen        and cannot get results
15:57 J-D           Hi people :) I just volunteered to help a very small non-public library doing an inventory. I have a few simple questions about LMS and couldn't find actual answers during the last 2 hours :)
15:58 pastebot      "tcohen" at 127.0.0.1 pasted "caroline: what's wrong with this search?" (29 lines) at http://paste.koha-community.org/22747
15:59 oleonard      Ask away J-D
15:59 J-D           First : please pardon my use of English, I happen to be French ;)
16:00 oleonard      Some of us happen to be French, German, Canadian, Argentinian, Norwegian...
16:01 J-D           The more, the merrier ;)
16:01 caroline      francophone here, if you don't know the specific terms
16:01 oleonard      ...American, British, Australian, New Zealander, Dutch, Swedish, Czech...
16:01 oleonard      ...bot...
16:01 J-D           It's a small library of about 4000 books, very old, I think a third of the whole library dates before 1900
16:02 J-D           Lately, the owners decided to do the inventory and asked for volunteers who started with the newest books and created simple XML files
16:02 J-D           With no rules whatsoever about the way they recorded the books...
16:03 oleonard      So kind of like MARC XD...
16:03 J-D           As I was the only guy crazy enough to record the oldest books, I jumped into the jungle
16:03 J-D           I wish to make things clearer
16:04 J-D           I thought it would be a good idea to use a software that would call directly to ressources, like the National Library
16:05 J-D           I know there are softwares that will do that
16:05 J-D           My questions are then :
16:05 J-D           1/ For such a simple use, is it a good idea to try Koha ? (won't I get into a lot of unnecessary trouble ?)
16:06 J-D           2/ Will I be able to export the list of books into a XML at some point ?
16:06 caroline      1/ I think Koha might be a bit overkill
16:07 caroline      2/ Yes, Koha supports exports in XML
16:07 J-D           I'm more than OK with learning a lot, but there is some extent to my curiosity. Setting up a server with a database is not a problem.
16:09 J-D           back to 1/ What would be the main obstacle ?
16:09 caroline      I've worked with non-librarians/library techs trying to use Koha for their small library and unless they are comfortable with computers and technology, I would avoid making things more complicated than they need it
16:10 caroline      (We support some genealogy societies using Koha and, not to be prejudiced, but they are mostly staffed with volunteers of a certain age and it can be quite a challenge)
16:10 cait          I feel the librarianese is probably worse than the setup - MARC especially
16:10 caroline      I agree with cait
16:11 cait          installing Koha is reasonable easy these days
16:11 cait          but cataloguing to librarian standards in MARC is a bit specific
16:11 cait          to be nice about MARC :)
16:11 J-D           I understand. If I may be precise : I'd be the only one using Koha, no other volunteers would be trying it. But I believe this library has such value that it may someday be of interest to a "real" library with "real" librarians
16:11 caroline      if the books aren't too rare, they could derive using Z39.50
16:11 cait          i think you said old books - i missed the beginning of your text
16:11 cait          how old?
16:12 cait          no IBSN old? :)
16:12 J-D           So far, I recorded about 200 books from 1600 and 1700
16:13 cait          i have to admit  - i don't know when isbn was invented, but that osunds a bit too old
16:13 caroline      long term, it's for sure a good idea I think
16:13 cait          it can be challenging finding old or rare material in other catalogs to reuse, but probably possible
16:13 cait          reuse their records htat is
16:14 oleonard      I'm pretty sure ISBN was invented after 1700
16:14 J-D           Some of those books are not referenced in the French National Library
16:14 caroline      If you document the cataloging process really well, eventually they could use it without you
16:15 * oleonard    pictures Johannes Gutenberg carefully printing "ISBN: 1"
16:16 cait          lol
16:16 J-D           Ahah :p
16:16 caroline      XD
16:17 J-D           Right now, I'm searching the National Library catalog and when I find my reference, I copy each element into a XML
16:18 J-D           Will this be of any use for another library ?
16:18 J-D           I mean... Can that be imported into another database ?
16:19 oleonard      If your XML structure is unique to your library it would be difficult
16:19 cait          libraries usually use standard for data exchange
16:19 J-D           -_-
16:19 cait          MARC21 being a common one, probably used by the national library - or UNIMARC (not sure about natinal library in france)
16:19 J-D           Well, I kept to author, title, edition, date
16:20 cait          it dpeends maybe on what you wan tto do - it could serve as a kind of inventory list - getting someone inerested to see the books
16:20 cait          but they might recatalog them
16:20 oleonard      Theoretically if your XML is valid, someone could map yours to standard MARC and apply a transform, but it would be extra work.
16:21 J-D           oleonard: That is what I try to avoid
16:21 cait          linking to authorities (records for the people involved), adding information about the binding, pages, physical appearance, series etc.
16:22 J-D           Koha would create such standard XML files ?
16:22 J-D           I mean, reusabled ones :)
16:22 oleonard      Koha would allow you to export records as MARCXML
16:22 J-D           ok
16:23 J-D           So if I understand you well :
16:23 J-D           It is a good idea to catalog as soon as possible in such format that libraries could use later-on
16:24 J-D           If I'm ok with the tech part, the cataloging will be challenging but not impossible for a new-comer ?
16:25 oleonard      J-D: Koha allows you to create your own MARC entry form with only the fields you need, so it's possible to make a simplified setup for newcomers
16:25 J-D           ok
16:26 caroline      definitely not impossible (e.g. my genealogy clients are definitely capable of cataloging, they just need very clear instructions)
16:27 J-D           In the end, I will be able to export to XML for the current owners (they are specific on that), but also to other common standards for libraries so that in the long-run my work is helping ?
16:28 cait          MARCXML is kinda both
16:28 cait          it's an XML presentaton of MARC
16:28 J-D           Ok
16:28 J-D           So definitely a good idea
16:28 cait          this is gemran, but it looks somewhat like this http://format.gbv.de/marc/xml
16:29 cait          245$a is the title in MARC, 245$b is the subtitle and so on... it's not very readable xml
16:29 caroline      If you are in France, they would probably prefer UNIMARC
16:30 cait          oh yes
16:30 caroline      rather than MARC21
16:30 J-D           That actually made some sense to me
16:30 cait          i am not sure if paul said that the national was using marc21.. weshould check that
16:30 J-D           I guess Koha will export easily to UNIMARC too
16:30 cait          you have to choose on installation time
16:30 cait          the formats are similar... but use different fields
16:30 J-D           And last question
16:31 J-D           Will I be able to create a very simple XML containing only basics : author, title, edition, date ?
16:31 cait          you can export to some other formats and make your own csv profiles... but you probably need to have some kind of conversion thing
16:31 caroline      I think BNF uses UNIMARC
16:32 cait          ah cool then
16:32 J-D           They use INTERMARC but offer UNIMARC too
16:32 cait          ah, maybe that was what i had in mind then
16:32 cait          makes total sense
16:32 cait          well kind of
16:32 cait          that they offer unimarc
16:33 J-D           Thanks for your answers :)
16:33 caroline      good luck!
16:33 J-D           I'll try to set up Koha and see if I get to work with a reasonable learning time
16:33 J-D           You are great !
16:34 J-D           Thanks :)
16:34 J-D           have a nice morning/day/evening/night (pick your next-to-come or favourite) !
16:34 J-D           Bye !
16:39 oleonard      "Your branch and 'origin/master' have diverged, and have 1 and 2104 different commits each, respectively."
16:39 * oleonard    blows the dust off
16:40 caroline      oh my!
16:52 oleonard      I was successful (I think) in reviving Bug 24625 so I thought I'd look at my list of other ancient shipwrecks
16:52 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24625 enhancement, P5 - low, ---, oleonard, Needs Signoff , Phase out jquery.cookie.js:  showLastPatron
17:21 ashimema      lol
17:33 oleonard      Why do we have OpacItemLocation and OPACItemsResultsDisplay
17:33 cait          i'll take historical reasons for 200
17:37 oleonard      Oh... probably because OPACItemsResultsDisplay only affects non-XSLT and whoever added OpacItemLocation didn't know that...
17:41 cait          so we can kill one? *hopeful*
17:42 oleonard      I'm tempted to simply kill OPACItemsResultsDisplay and not be concerned about reproducing its features precisely in XSLT
17:43 oleonard      (see Bug 5229)
17:43 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5229 normal, P5 - low, ---, oleonard, NEW , OPACItemsResultsDisplay preference does not work with XSLT results
17:43 cait          I can fully undersetand
17:43 cait          the xslt code there is scary at least
17:44 cait          does hea report a lot of use? if we can tell even?
17:45 oleonard      Hea shows 730 for OPACItemsResultsDisplay = 1, but you'd have to combine that number with the same libraries' XSLT use to really know
17:46 cait          it's still ont a lot
17:46 cait          out of 6300 now?
17:46 cait          and yeah, it might just have been toggled without any effect
17:46 cait          i say we try to kill it (/me is in that kind of mood)
17:52 ashimema      Kill it with fire
17:52 ashimema      Gets my vote
17:52 * ashimema    isn't sure what it does above and beyond the other one though..
17:53 cait          i did never know, we always used xslt
18:13 ashimema      Yup. Me too
19:26 oleonard      I was unsuccessful in raising the wreck of Bug 24352
19:26 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24352 normal, P5 - low, ---, oleonard, Failed QA , OpacItemLocation is buggy
19:26 oleonard      I don't know that cait and I ever saw the same output, patch or no patch
19:33 * oleonard    fixes Bug 5229 instead
19:33 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5229 normal, P5 - low, ---, oleonard, NEW , OPACItemsResultsDisplay preference does not work with XSLT results
19:59 oleonard      haha never mind, new patch submitted for Bug 24352
19:59 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24352 normal, P5 - low, ---, oleonard, Needs Signoff , OpacItemLocation is buggy
20:09 oleonard      I'm going to start selling a version of Koha with all my great patches applied to it and it'll be called Koha Ultra XXL
20:14 Michael_A     Hi all!
20:14 oleonard      Hi Michael_A
20:14 Michael_A     Quick reports question: how do I limit the number of decimal places displayed in a report? Say, for account lines, limit to 10.00 instead of 10.00000
20:15 oleonard      I would think something like this: https://www.w3resource.com/mysql/string-functions/mysql-format-function.php
20:18 oleonard      Look for instance at this report: https://wiki.koha-community.org/wiki/SQL_Reports_Library#List_patrons_detailed_information_of_fine_.28_including_title_info_for_each_item_.29
20:18 Michael_A     Perfect! Thank you Owen
20:59 caroline      Wow, I totally missed the conversation, but I usually use ROUND() in my reports, another option I guess
21:09 aleisha       hello
21:11 caroline      hi aleisha!
21:11 aleisha       hi caroline
21:30 oleonard      o/
22:04 koha-jenkins  Project Koha_20.05_D9_My8 build #4: FAILURE in 17 min: https://jenkins.koha-community.org/job/Koha_20.05_D9_My8/4/
22:05 koha-jenkins  Project Koha_20.05_U16 build #2: STILL FAILING in 49 sec: https://jenkins.koha-community.org/job/Koha_20.05_U16/2/
22:07 oleonard      Some new interest in Bug 7365... I wonder what kind of hints they're looking for
22:07 huginn        Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365 enhancement, P5 - low, ---, koha-bugs, NEW , Koha should support PostgreSQL
22:16 koha-jenkins  Project Koha_20.05_D9_My8 build #5: STILL FAILING in 11 min: https://jenkins.koha-community.org/job/Koha_20.05_D9_My8/5/
22:17 koha-jenkins  Project Koha_20.05_U16 build #3: STILL FAILING in 29 sec: https://jenkins.koha-community.org/job/Koha_20.05_U16/3/
22:30 koha-jenkins  Project Koha_20.05_D10 build #7: STILL UNSTABLE in 45 min: https://jenkins.koha-community.org/job/Koha_20.05_D10/7/
22:38 koha-jenkins  Project Koha_20.05_D9_My8 build #6: STILL FAILING in 21 min: https://jenkins.koha-community.org/job/Koha_20.05_D9_My8/6/
22:38 koha-jenkins  Project Koha_20.05_U16 build #4: STILL FAILING in 29 sec: https://jenkins.koha-community.org/job/Koha_20.05_U16/4/
22:40 koha-jenkins  Project Koha_20.05_U18 build #4: STILL UNSTABLE in 52 min: https://jenkins.koha-community.org/job/Koha_20.05_U18/4/
22:45 koha-jenkins  Project Koha_20.05_D9 build #8: STILL UNSTABLE in 58 min: https://jenkins.koha-community.org/job/Koha_20.05_D9/8/
22:54 koha-jenkins  Project Koha_20.05_D9_My8 build #7: STILL FAILING in 15 min: https://jenkins.koha-community.org/job/Koha_20.05_D9_My8/7/
23:14 koha-jenkins  Yippee, build fixed!
23:14 wahanui       Congratulations!
23:14 koha-jenkins  Project Koha_20.05_U20 build #3: FIXED in 44 min: https://jenkins.koha-community.org/job/Koha_20.05_U20/3/
23:28 koha-jenkins  Yippee, build fixed!
23:28 wahanui       Congratulations!
23:28 koha-jenkins  Project Koha_20.05_D11 build #15: FIXED in 48 min: https://jenkins.koha-community.org/job/Koha_20.05_D11/15/
23:41 koha-jenkins  Yippee, build fixed!
23:41 wahanui       Congratulations!
23:41 koha-jenkins  Project Koha_20.05_D10 build #8: FIXED in 55 min: https://jenkins.koha-community.org/job/Koha_20.05_D10/8/