Hello, When I create a record, the columns biblio.datecreated and biblio.timestamp of the database are not copied in the subfield 099$c and 099$d of the MARC record. So, the sort by acquisition date doesn't work for new records. The database contains following information regarding 099$c and 099$d : CREATE TABLE `marc_subfield_structure` ( `tagfield` varchar(3) NOT NULL DEFAULT '', `tagsubfield` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `liblibrarian` varchar(255) NOT NULL DEFAULT '', `libopac` varchar(255) NOT NULL DEFAULT '', `repeatable` tinyint(4) NOT NULL DEFAULT '0', `mandatory` tinyint(4) NOT NULL DEFAULT '0', `kohafield` varchar(40) DEFAULT NULL, `tab` tinyint(1) DEFAULT NULL, `authorised_value` varchar(20) DEFAULT NULL, `authtypecode` varchar(20) DEFAULT NULL, `value_builder` varchar(80) DEFAULT NULL, `isurl` tinyint(1) DEFAULT NULL, `hidden` tinyint(1) DEFAULT NULL, `frameworkcode` varchar(4) NOT NULL DEFAULT '', `seealso` varchar(1100) DEFAULT NULL, `link` varchar(80) DEFAULT NULL, `defaultvalue` text, PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`), KEY `kohafield_2` (`kohafield`), KEY `tab` (`frameworkcode`,`tab`), KEY `kohafield` (`frameworkcode`,`kohafield`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `marc_subfield_structure` VALUES ('099','c','date création notice (koha)','date création notice (koha)',0,0,'biblio.datecreated',-1,'','','',0,0,'','','',NULL), ('099','d','date modification notice (koha)','date modification notice (koha)',0,0,'biblio.timestamp',-1,'','','',0,0,'','','',NULL), ('099','c','date création notice (koha)','date création notice (koha)',0,0,'biblio.datecreated',-1,'','','',NULL,0,'ARTI','',NULL,NULL), ('099','d','date modification notice (koha)','date modification notice (koha)',0,0,'biblio.timestamp',-1,'','','',NULL,0,'ARTI','',NULL,NULL), ('099','c','date création notice (koha)','date création notice (koha)',0,0,'biblio.datecreated',-1,'','','',NULL,0,'MULT','',NULL,NULL), ('099','d','date modification notice (koha)','date modification notice (koha)',0,0,'biblio.timestamp',-1,'','','',NULL,0,'MULT','',NULL,NULL), ('099','c','date création notice (koha)','date création notice (koha)',0,0,'biblio.datecreated',-1,'','','',NULL,0,'PERI','',NULL,NULL), ('099','d','date modification notice (koha)','date modification notice (koha)',0,0,'biblio.timestamp',-1,'','','',NULL,0,'PERI','',NULL,NULL), ('099','c','date création notice (koha)','date création notice (koha)',0,0,'biblio.datecreated',-1,'','','',NULL,0,'WEB','',NULL,NULL), ('099','d','date modification notice (koha)','date modification notice (koha)',0,0,'biblio.timestamp',-1,'','','',NULL,0,'WEB','',NULL,NULL) I use Koha 3.01.00.100; records in UNIMARC. Many thanks by advance for any hint. Best regards, Alex Bernier
participants (1)
-
Alex Bernier