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
