{"id":2855,"date":"2019-03-25T17:41:32","date_gmt":"2019-03-25T20:41:32","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/"},"modified":"2019-11-27T13:19:23","modified_gmt":"2019-11-27T16:19:23","slug":"kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/","title":{"rendered":"KB-48067: Performing queries in Elipse SCADA with numeric or text filters."},"content":{"rendered":"<div style=\"text-align: justify;\">\n<p><span style=\"font-weight: bold;\">Question:<\/span><\/p>\n<p>How can I perform a query with numeric or text filters to an Elipse SCADA&#8217;s Historic?<\/p>\n<p><span style=\"font-weight: bold;\">Solution:<\/span><\/p>\n<p>By default, Elipse SCADA&#8217;s queries only allows date filters. However, to work around this limitation, these filters can be performed via scripts.<\/p>\n<p>To do so, you must create a secondary Historic, and also a RAM tag for each column in the main Historic. The script executing the filter must scan the main Historic, applying the desired filter to it. If the current line applies to the filter, it will be inserted in the secondary Historic. Thus, the secondary Historic will contain all data from the main Historic that satisfy the conditions of the applied filter.<\/p>\n<p>To perform a new query, you must first erase the secondary Historic, and only then repeat the procedure.<\/p>\n<p>Attached to this article is a sample application illustrating the procedure above.<\/p>\n<\/div>\n<div><\/div>\n<h3>Attachments:<\/h3>\n<p><a href=\"\/wp-content\/uploads\/2019\/03\/Sample-15-1.zip\">Sample.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Question: How can I perform a query with numeric or text filters to an Elipse SCADA&#8217;s Historic? Solution: By default, Elipse SCADA&#8217;s queries only allows date filters. However, to work&hellip;<\/p>\n","protected":false},"author":1,"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":[770,778],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB-48067: Performing queries in Elipse SCADA with numeric or text 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\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-48067: Performing queries in Elipse SCADA with numeric or text filters.\" \/>\n<meta property=\"og:description\" content=\"Question: How can I perform a query with numeric or text filters to an Elipse SCADA&#8217;s Historic? Solution: By default, Elipse SCADA&#8217;s queries only allows date filters. However, to work&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-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:41:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-27T16:19:23+00:00\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\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\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"KB-48067: Performing queries in Elipse SCADA with numeric or text filters.\",\"datePublished\":\"2019-03-25T20:41:32+00:00\",\"dateModified\":\"2019-11-27T16:19:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/\"},\"wordCount\":159,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Elipse Scada\",\"Historic\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/\",\"name\":\"[:pt]KB-48067: Performing queries in Elipse SCADA with numeric or text filters.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:41:32+00:00\",\"dateModified\":\"2019-11-27T16:19:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-48067: Performing queries in Elipse SCADA with numeric or text 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\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-48067: Performing queries in Elipse SCADA with numeric or text 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\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-48067: Performing queries in Elipse SCADA with numeric or text filters.[:] - Elipse Knowledgebase","og_description":"Question: How can I perform a query with numeric or text filters to an Elipse SCADA&#8217;s Historic? Solution: By default, Elipse SCADA&#8217;s queries only allows date filters. However, to work&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:41:32+00:00","article_modified_time":"2019-11-27T16:19:23+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"KB-48067: Performing queries in Elipse SCADA with numeric or text filters.","datePublished":"2019-03-25T20:41:32+00:00","dateModified":"2019-11-27T16:19:23+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/"},"wordCount":159,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Elipse Scada","Historic"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/","url":"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/","name":"[:pt]KB-48067: Performing queries in Elipse SCADA with numeric or text filters.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:41:32+00:00","dateModified":"2019-11-27T16:19:23+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/kb48067-performing-queries-in-elipse-scada-with-numeric-or-text-filters\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-48067: Performing queries in Elipse SCADA with numeric or text 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\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2855"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=2855"}],"version-history":[{"count":2,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2855\/revisions"}],"predecessor-version":[{"id":9515,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2855\/revisions\/9515"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=2855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=2855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=2855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}