{"id":28034,"date":"2017-06-16T15:06:45","date_gmt":"2017-06-16T07:06:45","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=28034"},"modified":"2024-08-15T10:31:31","modified_gmt":"2024-08-15T02:31:31","slug":"select","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/select\/","title":{"rendered":"Select()"},"content":{"rendered":"\n<h2>Format<\/h2>\n<p class=\"intro-text\"><strong>Select(Condition ,TrueValue ,FalseValue)<\/strong><\/p>\n<h2>Returns<\/h2>\n<p class=\"intro-text\">Returns all values within intervals between sample points from the \"true value\" or the \"false value\" parameter based on the value of the \"condition\" parameter.<\/p>\n<h2>Inputs<\/h2>\n<p class=\"intro-text\"><b>Condition: <\/b>The input Boolean value which controls whether the true value or the false value will be returned by the function for a given time period.<br \/>\n Behaviour: Required<br \/>\n Dimensions: Collection, SingleValue<br \/>\n Valid data types: Boolean<\/p>\n<p class=\"intro-text\"><b>TrueValue: <\/b>The value which will be returned when the condition is true.<br \/>\n Behaviour: Required<br \/>\n Dimensions: Expression<br \/>\n Valid data types: Expression<\/p>\n<p class=\"intro-text\"><b>FalseValue: <\/b>The value which will be returned when the condition is false.<br \/>\n Behaviour: Required<br \/>\n Dimensions: Expression<br \/>\n Valid data types: Expression<\/p>\n<p class=\"left-bar\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/calculation-syntax\/#Data_Type\">How to format data types<\/a><\/p>\n<h2>Examples<\/h2>\n<p class=\"intro-text\">Expression: Select({Tag1} &gt; 0, {Tag2}, {Tag3})<br \/>\n Result: Returns all values of {Tag2} for time periods where {Tag1} is greater than 0 and returns all values of {Tag2} for time periods where {Tag1} is 0 or less.<\/p>\n<p class=\"intro-text\">\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Returns all values within intervals between sample points from the \"true value\" or the \"false value\" parameter based on the value of the \"condition\" parameter.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/select\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":28084,"parent":3650,"menu_order":185,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[9],"tags":[100],"class_list":["post-28034","page","type-page","status-publish","has-post-thumbnail","hentry","category-tech-ref","tag-calculations","Version-4-5-1","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/28034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=28034"}],"version-history":[{"count":1,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/28034\/revisions"}],"predecessor-version":[{"id":46242,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/28034\/revisions\/46242"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3650"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/28084"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=28034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=28034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=28034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}