{"id":3409,"date":"2019-03-25T17:44:09","date_gmt":"2019-03-25T20:44:09","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb65208-generating-monthly-reports-with-filters\/"},"modified":"2019-06-10T14:04:05","modified_gmt":"2019-06-10T17:04:05","slug":"kb65208-generating-monthly-reports-with-filters","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/","title":{"rendered":"KB-65208: Generating monthly reports with filters."},"content":{"rendered":"
\n

Question:<\/b><\/p>\n

How can I create a monthly report with filters related to the previous month (from 05\/01 to 05\/31, for example)?<\/p>\n

Solution:<\/b><\/p>\n

To do so, use a timer tag set up as 3-ttMonthly<\/b>, with its StartTime <\/b>parameter set up as the date when the OnPreset <\/i>event must be fired, as seen below:<\/p>\n

\"\"<\/div>\n

At the OnPreset <\/i>event, create a logic that sends the initial and final dates to the reports filters, as well as the action that must be deployed after the filter is over.<\/p>\n

For this, the script will check the month and the year when the Preset <\/i>event is taking place, and also in which month the report is being requested. After this, the initial and final dates to be presented by the report will be sent to the query via scripts.<\/p>\n

Attached to this article is a demo application that illustrates how this script works.<\/p>\n

Attachments:<\/h3>\n

KB-65208_en<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Question: How can I create a monthly report with filters related to the previous month (from 05\/01 to 05\/31, for example)? Solution: To do so, use a timer tag set…<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[761,763],"tags":[],"yoast_head":"\nKB-65208: Generating monthly reports with filters. - Elipse Knowledgebase<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-65208: Generating monthly reports with filters.\" \/>\n<meta property=\"og:description\" content=\"Question: How can I create a monthly report with filters related to the previous month (from 05\/01 to 05\/31, for example)? Solution: To do so, use a timer tag set…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:44:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-10T17:04:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5072EN\/Pic1.png\" \/>\n<meta name=\"author\" content=\"Luiz Fernando Freire\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luiz Fernando Freire\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/\"},\"author\":{\"name\":\"Luiz Fernando Freire\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/08861c3269f025e52ec10dbbad3036a9\"},\"headline\":\"KB-65208: Generating monthly reports with filters.\",\"datePublished\":\"2019-03-25T20:44:09+00:00\",\"dateModified\":\"2019-06-10T17:04:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/\"},\"wordCount\":156,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Reports\",\"Scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/\",\"name\":\"[:pt]KB-65208: Generating monthly reports with filters.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:44:09+00:00\",\"dateModified\":\"2019-06-10T17:04:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-65208: Generating monthly reports with filters.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/08861c3269f025e52ec10dbbad3036a9\",\"name\":\"Luiz Fernando Freire\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/17dffa843d3208118522366c0b8d1ace?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/17dffa843d3208118522366c0b8d1ace?s=96&d=mm&r=g\",\"caption\":\"Luiz Fernando Freire\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/fernando\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-65208: Generating monthly reports with filters. - Elipse Knowledgebase","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-65208: Generating monthly reports with filters.[:] - Elipse Knowledgebase","og_description":"Question: How can I create a monthly report with filters related to the previous month (from 05\/01 to 05\/31, for example)? Solution: To do so, use a timer tag set…","og_url":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:44:09+00:00","article_modified_time":"2019-06-10T17:04:05+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5072EN\/Pic1.png"}],"author":"Luiz Fernando Freire","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Luiz Fernando Freire","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/"},"author":{"name":"Luiz Fernando Freire","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/08861c3269f025e52ec10dbbad3036a9"},"headline":"KB-65208: Generating monthly reports with filters.","datePublished":"2019-03-25T20:44:09+00:00","dateModified":"2019-06-10T17:04:05+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/"},"wordCount":156,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Reports","Scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/","url":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/","name":"[:pt]KB-65208: Generating monthly reports with filters.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:44:09+00:00","dateModified":"2019-06-10T17:04:05+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/kb65208-generating-monthly-reports-with-filters\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-65208: Generating monthly reports with filters."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/08861c3269f025e52ec10dbbad3036a9","name":"Luiz Fernando Freire","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/17dffa843d3208118522366c0b8d1ace?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17dffa843d3208118522366c0b8d1ace?s=96&d=mm&r=g","caption":"Luiz Fernando Freire"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/fernando\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3409"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3409"}],"version-history":[{"count":2,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3409\/revisions"}],"predecessor-version":[{"id":4972,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3409\/revisions\/4972"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}