{"id":410,"date":"2021-12-13T10:35:12","date_gmt":"2021-12-13T10:35:12","guid":{"rendered":"https:\/\/journalio.se\/?p=410"},"modified":"2021-12-13T10:35:13","modified_gmt":"2021-12-13T10:35:13","slug":"hur-soker-jag-efter-matvarden-inom-ett-specifikt-tidsintervall","status":"publish","type":"post","link":"https:\/\/avamonitoring.com\/en\/hur-soker-jag-efter-matvarden-inom-ett-specifikt-tidsintervall\/","title":{"rendered":"How do I search for values within a specific time interval?"},"content":{"rendered":"<p>Sometimes you want to display measurements for a period of time regardless of the date, for example, every day between 07: 00 \u2013 18:00. In this case, you can use the column \u201dTime of day\u201d instead of the column \u201dTime\u201d which includes dates. Normally, the column \u201dTime of day\u201d isn\u2019t displayed, but you may add it by clicking the \u201dselect columns\u201d above the table.<br>To enter the desired time interval, click the question mark to the left of the search field column \u201dTime of day\u201d. This opens the dialog for advanced options that make your job of building up the search string.<br>For example, to find out the range of 07: 00 \u2013 18:00, do the following:<br>1) Select the option \u201dnot before,\u201d and enter 7:00 into the text field and click the \u201dAnd\u201d<br>2) Select the \u201dnot after:\u201d and enter 18:00 into the text field and click the \u201dAnd\u201d<br>You have the following search string in the text field: &gt; = 07:00:00 &amp;&amp; &lt;= 18:00:00<br>Click \u201dSearch\u201d to execute the search. The dialog closes and the table is updated. You can see the search string in the search field for the column \u201dTime of day\u201d<\/p>\n\n\n\n<p>If you want to limit the search to be between certain dates, include the column \u201dTime\u201d and simply choose the desired dates.<\/p>","protected":false},"excerpt":{"rendered":"<p>Ibland kan det vara bra att kunna s\u00f6ka ut m\u00e4tv\u00e4rden f\u00f6r ett visst tidsintervall oavsett datum, t.ex varje dag mellan kl.07:00 \u2013 18:00. I detta fall f\u00e5r du anv\u00e4nda kolumnen \u201dTid p\u00e5 dygnet\u201d i st\u00e4llet f\u00f6r kolumnen \u201dTid\u201d vilken inkluderar datum. Vanligtvis visas inte kolumnen \u201dTid p\u00e5 dygnet\u201d utan du f\u00e5r l\u00e4gga till den genom [&hellip;]<\/p>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-410","post","type-post","status-publish","format-standard","hentry","category-faq","entry"],"_links":{"self":[{"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/posts\/410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/comments?post=410"}],"version-history":[{"count":1,"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/posts\/410\/revisions"}],"predecessor-version":[{"id":411,"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/posts\/410\/revisions\/411"}],"wp:attachment":[{"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/media?parent=410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/categories?post=410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/avamonitoring.com\/en\/wp-json\/wp\/v2\/tags?post=410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}