https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20067
--- Comment #18 from Jonathan Druart <jonathan.dru...@bugs.koha-community.org> --- Koha::MarcSubfieldStructures->search( { frameworkcode => '', kohafield => 'items.materials', -or => [ { authorised_value => { not => undef } }, { authorised_value => { '!=' => '' } } ] } ); will generate SELECT `me`.`tagfield`, `me`.`tagsubfield`, `me`.`liblibrarian`, `me`.`libopac`, `me`.`repeatable`, `me`.`mandatory`, `me`.`kohafield`, `me`.`tab`, `me`.`authorised_value`, `me`.`authtypecode`, `me`.`value_builder`, `me`.`isurl`, `me`.`hidden`, `me`.`frameworkcode`, `me`.`seealso`, `me`.`link`, `me`.`defaultvalue`, `me`.`maxlength` FROM `marc_subfield_structure` `me` WHERE ( ( ( `authorised_value` IS NOT NULL OR `authorised_value` != ? ) AND `frameworkcode` = ? AND `kohafield` = ? ) ): '', '', 'items.materials' Which is what we want. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/