{"id":23952,"date":"2025-07-17T16:21:38","date_gmt":"2025-07-17T14:21:38","guid":{"rendered":"https:\/\/rebub.u-bordeaux.fr\/?page_id=23952"},"modified":"2025-07-18T13:37:53","modified_gmt":"2025-07-18T11:37:53","slug":"regroupement-et-filtre-des-exemplaires-selon-les-indices-des-coteqs-dewey-ou-nlm","status":"publish","type":"page","link":"http:\/\/rebub.u-bordeaux.fr\/index.php\/statistiques\/donnees-statistiques\/les-rapports-et-les-indicateurs\/dedinition-des-indicateurs\/regroupement-et-filtre-des-exemplaires-selon-les-indices-des-coteqs-dewey-ou-nlm\/","title":{"rendered":"Regroupement et filtre des exemplaires selon les indices des cotes DEWEY ou NLM"},"content":{"rendered":"
<\/span><\/div><\/div>

<\/p>\n

\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Attention !<\/strong> Suite \u00e0 une anomalie, cette fonctionnalit\u00e9 a \u00e9t\u00e9 d\u00e9sactiv\u00e9e. Un ticket avec Ex Libris est en cours \u00e0 ce sujet. Nous esp\u00e9rons qu’elle pourra \u00eatre red\u00e9ploy\u00e9e rapidement.<\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n

Si le type de cote est NLM <\/strong>alors on extrait tous les caract\u00e8res depuis le d\u00e9but de la cha\u00eene jusqu’au premier espace qui suit un chiffre et qui est pr\u00e9c\u00e9d\u00e9 par une lettre. Les points sont remplac\u00e9s par des virgules pour faciliter le tri des donn\u00e9es.<\/p>\n\n\n\n

Si le type de cote est Dewey <\/strong>on extrait les caract\u00e8res \u00e0 partir du premier chiffre jusqu’au premier espace qui suit un chiffre et qui est pr\u00e9c\u00e9d\u00e9 par une lettre. Les points sont remplac\u00e9s par des virgules pour faciliter le tri des donn\u00e9es.<\/p>\n\n\n\n

Dans les autres cas <\/strong> on affecte la valeur \u00ab\u00a0Non Dewey ou NLM\u00a0\u00bb<\/strong><\/p>\n\n\n\n

Requ\u00eate SQL pour la cr\u00e9ation de l’invite<\/h2>\n\n\n\n
SELECT<\/span><\/div>
\u00a0 \u00a0 <\/span>CASE<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 <\/span>WHEN<\/span> <\/span>\"Holdings Details\"<\/span>.<\/span>\"Permanent Call Number Type\"<\/span> <\/span>=<\/span> <\/span>'National Library of Medicine classification'<\/span> <\/span>THEN<\/span> <\/span>IFNULL<\/span> (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 EVALUATE (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'regexp_replace(%1,%2,%3)'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>IFNULL<\/span> (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 EVALUATE (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'regexp_replace(%1,%2,%3)'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 EVALUATE (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'regexp_replace(%1,%2,%3)'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>\"Holding Details\"<\/span>.<\/span>\"Permanent Call Number\"<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'\\('<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>' '<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ),<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'^(.*?[0-9\\.]+?)\\s.*$'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'\\1'<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ),<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>0<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ),<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'\\.'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>','<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ),<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>0<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 )<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 <\/span>WHEN<\/span> <\/span>\"Holdings Details\"<\/span>.<\/span>\"Permanent Call Number Type\"<\/span> <\/span>=<\/span> <\/span>'Dewey Decimal classification'<\/span> <\/span>THEN<\/span> <\/span>IFNULL<\/span> (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 EVALUATE (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'regexp_replace(%1,%2,%3)'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>IFNULL<\/span> (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 EVALUATE (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'regexp_replace(%1,%2,%3)'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 EVALUATE (<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'regexp_replace(%1,%2,%3)'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>\"Holding Details\"<\/span>.<\/span>\"Permanent Call Number\"<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'\\('<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>' '<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ),<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'^.*?([0-9\\.]+?)\\s.*$'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'\\1'<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ),<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>0<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ),<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>'\\.'<\/span>,<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>','<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ),<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>0<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 )<\/span><\/div>
\u00a0 \u00a0 \u00a0 \u00a0 <\/span>ELSE<\/span> <\/span>'Non Dewey ou NLM'<\/span><\/div>
\u00a0 \u00a0 <\/span>END<\/span><\/div>
FROM<\/span><\/div>
\u00a0 \u00a0 <\/span>\"Physical Items\"<\/span><\/div>
FETCH<\/span> <\/span>FIRST<\/span><\/div>
\u00a0 \u00a0 <\/span>65001<\/span> <\/span>ROWS<\/span> ONLY<\/span><\/div><\/div><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Si le type de cote est NLM alors on extrait tous les caract\u00e8res depuis le d\u00e9but de la cha\u00eene jusqu’au premier espace qui suit un chiffre et qui est pr\u00e9c\u00e9d\u00e9 par une lettre. Les points sont remplac\u00e9s par des virgules…<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":23926,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"http:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages\/23952"}],"collection":[{"href":"http:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/comments?post=23952"}],"version-history":[{"count":2,"href":"http:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages\/23952\/revisions"}],"predecessor-version":[{"id":23955,"href":"http:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages\/23952\/revisions\/23955"}],"up":[{"embeddable":true,"href":"http:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages\/23926"}],"wp:attachment":[{"href":"http:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/media?parent=23952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}