{"id":6840,"date":"2024-12-02T16:35:00","date_gmt":"2024-12-02T15:35:00","guid":{"rendered":"https:\/\/services.lib.uliege.be\/alma\/?p=6840"},"modified":"2024-12-02T16:35:00","modified_gmt":"2024-12-02T15:35:00","slug":"creer-une-invite-de-rapport-avec-une-liste-de-choix-dynamiques","status":"publish","type":"post","link":"https:\/\/services.lib.uliege.be\/alma\/creer-une-invite-de-rapport-avec-une-liste-de-choix-dynamiques\/","title":{"rendered":"Cr\u00e9er une invite de rapport avec une liste de choix dynamiques"},"content":{"rendered":"\n

Pour personnaliser l\u2019affichage des r\u00e9sultats d\u2019un rapport, il est possible d\u2019ajouter une invite qui permet \u00e0 l’utilisateur de s\u00e9lectionner, par exemple, une ou plusieurs ann\u00e9es de pr\u00eat.<\/p>\n\n\n\n

Approche statique :<\/strong><\/p>\n\n\n\n

L\u2019option \u00ab\u00a0Specific Column Values\u00a0\u00bb permet de d\u00e9finir manuellement les ann\u00e9es disponibles. <\/p>\n\n\n\n

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

Cependant, cette m\u00e9thode ne s\u2019adapte pas automatiquement au fil des ans. Si vous recherchez une solution dynamique, l\u2019approche SQL peut \u00eatre la solution.<\/p>\n\n\n\n

Approche dynamique avec SQL :<\/strong><\/p>\n\n\n\n

Voici la structure d’une requ\u00eate SQL :<\/p>\n\n\n\n

SELECT column_name(s)
FROM table_name
WHERE column_name(s) BETWEEN \/ > \/ >= \/ < \/ <= \/ LIKE\u2026
ORDER BY column_name(s) ASC \/ DESC<\/code><\/pre>\n\n\n\n
Si vous souhaitez limiter le choix aux ann\u00e9es post\u00e9rieures \u00e0 2015, voici comment l’adapter :<\/p>\n\n\n\n
SELECT \"Loan Date\".\"Loan Year\"
FROM \"Fulfillment\"
WHERE \"Loan Date\".\"Loan YEAR\" > 2015
ORDER BY \"Loan Date\".\"Loan Year\" ASC<\/code><\/pre>\n\n\n\n
Cette requ\u00eate extrait les ann\u00e9es de pr\u00eat sup\u00e9rieures \u00e0 2015, tri\u00e9es par ordre croissant.<\/p>\n\n\n\n
Afficher un intervalle dynamique<\/strong><\/p>\n\n\n\n
Si vous souhaitez proposer une plage d’ann\u00e9es, (ex : les 10 derni\u00e8res ann\u00e9es), voici comment l’adapter :<\/p>\n\n\n\n
SELECT \"Loan Date\".\"Loan Year\"
FROM \"Fulfillment\"
WHERE \"Loan Date\".\"Loan Date\" >= TIMESTAMPADD(SQL_TSI_YEAR, -9, CURRENT_DATE) and \"Loan Date\".\"Loan Date\" <= TIMESTAMPADD(SQL_TSI_YEAR, -0, CURRENT_DATE)
ORDER BY \"Loan Date\".\"Loan Year\" ASC<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
Pour personnaliser l\u2019affichage des r\u00e9sultats d\u2019un rapport, il est possible d\u2019ajouter une invite qui permet \u00e0 l’utilisateur de s\u00e9lectionner, par exemple, une ou plusieurs ann\u00e9es de pr\u00eat. Approche statique : L\u2019option \u00ab\u00a0Specific Column Values\u00a0\u00bb permet de d\u00e9finir manuellement les ann\u00e9es disponibles. Cependant, cette m\u00e9thode ne s\u2019adapte pas automatiquement au fil… Lire l'int\u00e9gralit\u00e9…Cr\u00e9er une invite de rapport avec une liste de choix dynamiques<\/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_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_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},"jetpack_post_was_ever_published":false},"categories":[3],"tags":[101,39],"class_list":["post-6840","post","type-post","status-publish","format-standard","hentry","category-analytics","tag-formules","tag-invite","content-layout-excerpt-thumb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7rJUv-1Mk","_links":{"self":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/6840","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=6840"}],"version-history":[{"count":7,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/6840\/revisions"}],"predecessor-version":[{"id":6849,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/posts\/6840\/revisions\/6849"}],"wp:attachment":[{"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/media?parent=6840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/categories?post=6840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/services.lib.uliege.be\/alma\/wp-json\/wp\/v2\/tags?post=6840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}