recopie champ date dans "intervention d’une institution"

[sardinecan]

l'ajout se fait au dessus et change la valeur des champs s'il y en a trois, il faut revérifier fiches (ça arrive rarement)

[sardinecan]

@todo penser à vérifier les anciennes fiches (la valeur était remplacée)

[emchateau]

Reste à revérifier les fiches (mais peut-être déjà contrôlé)

[sardinecan]

xquery version "3.1";
(:
 : author @sardinecan
 : 2021-04-01
 : check sentence
 : just run it !
:)
declare default element namespace "xpr" ;

declare
function local:test() {
  let $data := db:open('xpr')
  for $expertise in $data//expertise[descendant::sentence[fn:count(date) > 1][date[@when = following-sibling::date/@when]]]
  return
  <expertise>
      <id>{$expertise/@xml:id}</id>
      {$expertise//sentence[fn:count(date) > 1][date[@when = following-sibling::date/@when]]}
  </expertise>

};

local:test()

[sardinecan]

10 expertises à vérifier (au moins deux dates de sentence identiques)

<expertise xmlns="xpr">
  <id xml:id="z1j431d002"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>LC Chatelet</orgName>
    <date when="1696-01-04"/>
    <date when="1696-01-04"/>
  </sentence>
</expertise>
<expertise xmlns="xpr">
  <id xml:id="z1j433d132"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>Parlement de Paris</orgName>
    <date when="1696-05-12"/>
    <date when="1696-06-27"/>
    <date when="1696-06-27"/>
    <date when="1696-06-27"/>
  </sentence>
</expertise>
<expertise xmlns="xpr">
  <id xml:id="z1j435d042"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>Requêtes du Palais</orgName>
    <date when="1696-10-25"/>
    <date when="1696-11-28"/>
    <date when="1696-11-28"/>
  </sentence>
</expertise>
<expertise xmlns="xpr">
  <id xml:id="z1j828d002"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>Requêtes de l'hôtel du roi</orgName>
    <date when="1754-01-31"/>
    <date when="1753-04-13"/>
    <date when="1753-04-13"/>
    <date when="1753-04-13"/>
  </sentence>
</expertise>
<expertise xmlns="xpr">
  <id xml:id="z1j828d085"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>lieutenant civil</orgName>
    <date when="1756-03-17"/>
    <date when="1756-02-17"/>
    <date when="1756-02-17"/>
  </sentence>
</expertise>
<expertise xmlns="xpr">
  <id xml:id="z1j829d003"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>LC Chatelet</orgName>
    <date when="1756-11-06"/>
    <date when="1756-03-10"/>
    <date when="1756-03-10"/>
  </sentence>
</expertise>
<expertise xmlns="xpr">
  <id xml:id="z1j830d042"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>lieutenant civil</orgName>
    <date when="1754-08-27"/>
    <date when="1754-04-23"/>
    <date when="1754-04-23"/>
  </sentence>
</expertise>
<expertise xmlns="xpr">
  <id xml:id="z1j830d050"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>lieutenant civil</orgName>
    <date when="arrêt de la cour du 28/11/1754"/>
    <date when="1753-09-05"/>
    <date when="1753-09-05"/>
    <date when="1753-09-05"/>
  </sentence>
</expertise>
<expertise xmlns="xpr">
  <id xml:id="z1j999d012"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>Châtelet, lieutenant civil (sentence du 22 décembre 1775)</orgName>
    <date when="1775-12-22"/>
    <date when="1775-12-22"/>
    <date when="1774-07-18"/>
  </sentence>
</expertise>
<expertise xmlns="xpr">
  <id xml:id="z1j999d022"/>
  <sentence xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:rico="rico">
    <orgName>Châtelet, lieutenant civil (sentences des 13 septembre et 13 décembre 1775)</orgName>
    <date when="1775-12-13"/>
    <date when="1775-12-13"/>
  </sentence>
</expertise>