{"id":2449,"date":"2015-03-16T21:11:39","date_gmt":"2015-03-16T13:11:39","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=2449"},"modified":"2022-09-15T11:36:53","modified_gmt":"2022-09-15T03:36:53","slug":"filter-column-and-filter-value","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/filter-column-and-filter-value\/","title":{"rendered":"Filter Column and Filter Value"},"content":{"rendered":"<p class=\"intro-text\">When using dataset data, many components\u00a0allow you to specify Filter Column, Filter Value, and Value Column fields. These are designed to be used together to act as a lookup table of sorts, in order to get the corresponding value from another column in the dataset. In some cases, only the Value Column is required.<\/p>\n<p class=\"intro-text\">The Filter Column and Filter Value fields are used together to enable the component\u00a0to select a specific cell from the dataset. It is often used in conjunction with an Value Column value.<\/p>\n<ul class=\"intro-text\">\n<li>The <strong>Value Column<\/strong> defines the column of the dataset that will be used to get the value for the component to display.<\/li>\n<li><strong>Filter Column<\/strong> expands this by allowing you to select a different column in the same dataset to use as a key to enable the selection of a specific cell from the Value Column. The system will look at the Filter Column values, and will go through each cell in that column until it finds one that matches the <strong>Filter Value<\/strong>.<\/li>\n<li>When it finds the first match for Filter Value, it then gets the value from the Value Column, from that same row, and returns that to the control as the value to use.<\/li>\n<\/ul>\n<p class=\"intro-text\">In the following example, a Data Label component shows how a hard-coded Filter Column and Filter Value affects the value shown by the Data Label.<\/p>\n<p class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/01\/filter-column-value.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-35181\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/01\/filter-column-value.png\" alt=\"\" width=\"1289\" height=\"339\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/01\/filter-column-value.png 1289w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/01\/filter-column-value-768x202.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/01\/filter-column-value-150x39.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/01\/filter-column-value-1280x337.png 1280w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/01\/filter-column-value-24x6.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/01\/filter-column-value-36x9.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2018\/01\/filter-column-value-48x13.png 48w\" sizes=\"auto, (max-width: 1289px) 100vw, 1289px\" \/><\/a><\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px; width: 120px;\"><strong>Value Column<\/strong><\/td>\n<td>The Value Column defines the column of the dataset that will be used to return the value used by the component, in the display.\u00a0 This can be used in conjunction with the Filter Column and the Filter Value settings to enable the selection of a single cell from that column.<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Filter Column<\/strong><\/td>\n<td>Defines the column of the dataset that, when combined with Filter Value, is used as a key to enable the selection of a specific cell from the Value Column.<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td style=\"padding-left: 5px;\"><strong>Filter Value<\/strong><\/td>\n<td>Defines the row of the dataset that, when combined with Filter Column, is used as a key to enable the selection of a specific cell from the Value Column.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h2 class=\"page-subheading\">Release History<\/h2>\n<ul class=\"intro-text\">\n<li class=\"overview\">Filter Column and Filter Value 4.4.0 (this release)\n<ul class=\"overview\">\n<li>Filtering is now done within the <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/\">Data Selector<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/filter-column-and-filter-value\/filter-column-and-filter-value-4-3\/\">Filter Column and Filter Value<\/a> (4.3.0)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Some components allow you to specify Filter Column and Filter Value fields. These are designed to be used together to act as a lookup table of sorts, in order to get the corresponding value from another column in the dataset. This article describes how filter columns and filter values work.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/filter-column-and-filter-value\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":4618,"parent":478,"menu_order":21,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[4],"tags":[514],"class_list":["post-2449","page","type-page","status-publish","has-post-thumbnail","hentry","category-explainer","tag-filter-column-and-filter-value","Version-4-5-0","Version-4-5-2","Version-4-5-3","Version-4-5-4","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/2449","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=2449"}],"version-history":[{"count":1,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/2449\/revisions"}],"predecessor-version":[{"id":46104,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/2449\/revisions\/46104"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/478"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/4618"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=2449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=2449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=2449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}