{"id":1571,"date":"2016-11-08T16:28:11","date_gmt":"2016-11-08T15:28:11","guid":{"rendered":"https:\/\/app.lib.uliege.be\/alma\/?p=1571"},"modified":"2025-11-03T12:50:24","modified_gmt":"2025-11-03T11:50:24","slug":"utiliser-une-date-dynamique-dans-un-filtre","status":"publish","type":"post","link":"https:\/\/services.lib.uliege.be\/alma\/utiliser-une-date-dynamique-dans-un-filtre\/","title":{"rendered":"Utiliser une date dynamique dans un filtre"},"content":{"rendered":"

Ce tutoriel explique comment utiliser une date dynamique dans un filtre gr\u00e2ce au langage SQL.<\/p>\n

Pour une colonne contenant une info de type \u00ab\u00a0date\u00a0\u00bb (par exemple \u00ab\u00a0Return Date\u00a0\u00bb), cochez \u00ab\u00a0Convert this filter to SQL\u00a0\u00bb lorsque vous cr\u00e9ez le filtre.<\/p>\n

\"convert-to-sql\"<\/p>\n

La fen\u00eatre \u00ab\u00a0Advanced SQL Filter\u00a0\u00bb s’ouvre, pr\u00e9-remplie avec le nom de la donn\u00e9e et du dossier qui la contient :<\/p>\n

\"advancedsql\"<\/p>\n

Si par exemple on ne souhaite obtenir que les exemplaires rentr\u00e9s ces 30 derniers jours, il suffit de compl\u00e9ter la formule de la mani\u00e8re suivante :<\/p>\n

\u201cReturn Date\u201d.\u201cReturn Date\u201d >= timestampadd (SQL_TSI_DAY,-30, CURRENT_DATE).<\/p>\n

Notez que vous pouvez adapter les diff\u00e9rents \u00e9l\u00e9ments de la formule selon vos besoins. Notamment :<\/p>\n

– utiliser les signes >, <, >=, <=\u00a0 \u00e0 la place du signe =<\/p>\n

– utiliser \u00ab\u00a0MONTH\u00a0\u00bb, \u00ab\u00a0YEAR\u00a0\u00bb, \u00ab\u00a0HOUR\u00a0\u00bb (lorsque c’est applicable) \u00e0 la place de DAY dans la formule \u00ab\u00a0SQL_TSI_DAY\u00a0\u00bb.<\/p>\n

– indiquer le contenu d’une autre colonne \u00e0 la place de \u00ab\u00a0CURRENT-DATE\u00a0\u00bb<\/p>\n

Attention que la formule initiale travaille sur du date \u00e0 date. Pour obtenir un calcul sur des ann\u00e9es compl\u00e8tes avec YEAR, pensez \u00e0 encadrer vos formules avec YEAR(formule initiale). Voir exemple 2.<\/p>\n

Exemple 1 : si l’on souhaite obtenir tous les pr\u00eats rentr\u00e9s au moins 30 jours apr\u00e8s la date de retour pr\u00e9vue<\/strong>, on \u00e9crira :<\/p>\n

\u201cReturn Date\u201d.\u201cReturn Date\u201d >= timestampadd (SQL_TSI_DAY, +30, \u201cLoan Details\u201d.\u201cDue Date\u201d)<\/p>\n

Exemple 2 : si on souhaite obtenir tous les pr\u00eats effectu\u00e9s ces 10 derni\u00e8res ann\u00e9es, on \u00e9crira :<\/p>\n

YEAR(\u00ab\u00a0Loan Date\u00a0\u00bb.\u00a0\u00bbLoan Date\u00a0\u00bb) >= YEAR(timestampadd(SQL_TSI_YEAR, -9, CURRENT_DATE))<\/p>\n","protected":false},"excerpt":{"rendered":"

Ce tutoriel explique comment utiliser une date dynamique dans un filtre gr\u00e2ce au langage SQL. Pour une colonne contenant une info de type \u00ab\u00a0date\u00a0\u00bb (par exemple \u00ab\u00a0Return Date\u00a0\u00bb), cochez \u00ab\u00a0Convert this filter to SQL\u00a0\u00bb lorsque vous cr\u00e9ez le filtre. La fen\u00eatre \u00ab\u00a0Advanced SQL Filter\u00a0\u00bb s’ouvre, pr\u00e9-remplie avec le nom de… Lire l'int\u00e9gralit\u00e9…Utiliser une date dynamique dans un filtre<\/span><\/span><\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[101],"class_list":["post-1571","post","type-post","status-publish","format-standard","hentry","category-analytics","tag-formules","content-layout-excerpt-thumb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7rJUv-pl","_links":{"self":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/1571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/comments?post=1571"}],"version-history":[{"count":10,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/1571\/revisions"}],"predecessor-version":[{"id":7071,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/1571\/revisions\/7071"}],"wp:attachment":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/media?parent=1571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/categories?post=1571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/tags?post=1571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}