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 <[email protected]> a écrit : > > Hi Jonathan, > > No, it does not return anything. > > Regards > > > AK > > > On Wed, 2 Aug 2023 at 13:56, Jonathan Druart > <[email protected]> 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 <[email protected]> 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 >> > [email protected] >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
