[NXP-6098] Add a lastContributor field in dublincore - Nuxeo Issue Tracker

XML

Word

Printable

Impact type:

Content model Change
Upgrade notes:

Hide

VCS is now able to detect the new column and migrate data.

But, if needed, execute this query :

create temp table tmp_contributors as
select id, max(pos) as pos from dc_contributors group by id;

update dublincore set lastContributor = dc_c.item
from dublincore dc join tmp_contributors tmp on (dc.id = tmp.id)
join dc_contributors dc_c on (tmp.id = dc_c.id and tmp.pos = dc_c.pos);

drop table tmp_contributors;

Show
VCS is now able to detect the new column and migrate data. But, if needed, execute this query : create temp table tmp_contributors as select id, max(pos) as pos from dc_contributors group by id; update dublincore set lastContributor = dc_c.item from dublincore dc join tmp_contributors tmp on (dc.id = tmp.id) join dc_contributors dc_c on (tmp.id = dc_c.id and tmp.pos = dc_c.pos); drop table tmp_contributors;

Add a new field that represents the name of the last contributor on a document.

For compatibility, previous version without this field, it will be the last "different" contributor to be displayed until the document is edited.