This still yields no results!🙆
On Wed, 2 Aug 2023 at 15:50, Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > What about this one? > SELECT frameworkcode, tagfield, tab, authorised_value FROM > marc_subfield_structure WHERE ( kohafield = "items.homebranch" OR > kohafield = "items.holdingbranch" ) AND ( authorised_value != > "branches" OR tab != 10 ); > > Le mer. 2 août 2023 à 14:53, Antony Kujenga <akuje...@gmail.com> a écrit : > > > > Hi Jonathan, > > > > No, it does not return anything. > > > > Regards > > > > > > AK > > > > > > On Wed, 2 Aug 2023 at 13:56, Jonathan Druart < > jonathan.dru...@bugs.koha-community.org> wrote: > >> > >> Does this SQL query return something? > >> > >> SELECT frameworkcode, tagfield, tab, authorised_value FROM > >> marc_subfield_structure WHERE ( kohafield = "items.homebranch" OR > >> kohafield = "items.holdingbranch" ) AND authorised_value != > >> "branches"; > >> > >> Le mer. 2 août 2023 à 11:25, Antony Kujenga <akuje...@gmail.com> a > écrit : > >> > > >> > Dear Community, > >> > > >> > I've been trying to edit some frameworks in our Koha 22.05.05.000 > instance > >> > running on Ubuntu 22.04. Upon running the framework test, I'm getting > this > >> > error report: > >> > > >> > homebranch NOT mapped the items.homebranch field MUST : > >> > > >> > - be mapped to a MARC subfield, > >> > - the corresponding subfield MUST have "Authorized value" set to > >> > "branches" > >> > > >> > holdingbranch NOT mapped the items.holdingbranch field MUST : > >> > > >> > - be mapped to a MARC subfield, > >> > - the corresponding subfield MUST have "Authorized value" set to > >> > "branches" > >> > > >> > > >> > I have tried changing the stated fields numerous times but the system > will > >> > not effect the changes. > >> > > >> > I tried running > >> > > >> > $ sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl > -c' > >> > your_koha_name > >> > > >> > with our instance name but it hasn't helped. > >> > > >> > Any urgent help would be most appreciated. > >> > > >> > Regards > >> > > >> > > >> > AK > >> > _______________________________________________ > >> > > >> > Koha mailing list http://koha-community.org > >> > Koha@lists.katipo.co.nz > >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha