[Koha] Sorting by acquisition date

[Alex Bernier]

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