{"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> Cette colonne ne fonctionne que pour les exemplaires dont la cote de la holding et de type Dewey ou NLM. Les exemplaires ne remplissant pas ces conditions sont regroup\u00e9s derri\u00e8re la mention \u00ab\u00a0Non Dewey ou NLM\u00a0\u00bb<\/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}]}}