{"id":29178,"date":"2017-10-06T13:39:14","date_gmt":"2017-10-06T05:39:14","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=29178"},"modified":"2020-11-11T17:03:32","modified_gmt":"2020-11-11T09:03:32","slug":"writing-values","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/using-the-page-controls\/writing-values\/","title":{"rendered":"Writing Values"},"content":{"rendered":"<p class=\"left-bar\">This article applies to versions 4.5.3 and later of P2 Explorer.<\/p>\n<p class=\"intro-text\">If a datasource has been configured to allow writing to the database, right-clicking a component using that data allows you to update the tag\u2019s value at a point in time.<\/p>\n<p class=\"intro-text\">For example, right-clicking on a Data Label displays a\u00a0<strong>Write Value<\/strong>\u00a0option, which allows you to update the value of the data label at a point in time in the database, and the data type if needed.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/08\/right-click1.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30476\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/08\/right-click1.png\" alt=\"\" width=\"204\" height=\"189\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/08\/right-click1.png 204w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/08\/right-click1-150x139.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/08\/right-click1-24x22.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/08\/right-click1-36x33.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/08\/right-click1-48x44.png 48w\" sizes=\"auto, (max-width: 204px) 100vw, 204px\" \/><\/a><\/p>\n<p><em>Right-clicking on a label shows a menu containing various options.<\/em><\/p>\n<p class=\"intro-text\">When you select <strong>Write Value\u00a0<\/strong>from the right-click menu, a box appears where you can enter the new value.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/07\/write-tag-452.png\" rel=\"lightbox-1\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29121\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/07\/write-tag-452.png\" alt=\"\" width=\"342\" height=\"275\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/07\/write-tag-452.png 342w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/07\/write-tag-452-150x121.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/07\/write-tag-452-24x19.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/07\/write-tag-452-36x29.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/07\/write-tag-452-48x39.png 48w\" sizes=\"auto, (max-width: 342px) 100vw, 342px\" \/><\/a><\/p>\n<p class=\"intro-text\">The fields are as follows:<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc;\">\n<td class=\"intro-text\" style=\"padding-left: 5px;\"><strong>Tag<\/strong><\/td>\n<td class=\"intro-text\">The name of the tag in the database. This cannot be changed.<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td class=\"intro-text\" style=\"padding-left: 5px;\"><strong>Data Type<\/strong><\/td>\n<td class=\"intro-text\">The <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/primers\/data-types\/\">data type<\/a> of the tag in the database. If the data type is known, you will have the option of changing it to <em>Null<\/em>, if required.\u00a0This is useful in circumstances where a datum is not present at a point in time, and it is important to indicate so.<br \/>\n If the data type is detected to be <em>Decimal,<\/em> the options will be Decimal, Integer, and Null.<br \/>\n If the data type of the value is\u00a0<em>not\u00a0known,<\/em> it will show all data types in the drop-down list.<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td class=\"intro-text\" style=\"padding-left: 5px;\"><strong>Value<\/strong><\/td>\n<td class=\"intro-text\">Type the new value of the tag here. The entry box may change depending on the data type. For example, Boolean values will show a check box, and DateTime values will allow you to use a date or time picker.\u00a0<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc;\">\n<td class=\"intro-text\" style=\"padding-left: 5px;\"><strong>Timestamp<\/strong><\/td>\n<td class=\"intro-text\">This is the point in time for which you want to assign the new data value. Click the calendar icon to set a date and click the clock icon to set a time. \u00a0You also have the option of using the current date and time, by clicking <strong>Use Now<\/strong>.<\/p>\n<p class=\"intro-text\"><strong>Note<\/strong>: For some tags, it\u2019s possible to write values with a timestamp that is in the future. However Explorer cannot know in advance if the datasource will allow this.\u00a0Therefore, if you select a timestamp that\u2019s in the future, a warning is shown. You can still click OK, and if the datasource accepts the value a success message will appear, otherwise an error message will be shown.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"instruct\">When you have finished entering your value, click <strong>OK<\/strong>.<\/p>\n<hr \/>\n<h2 class=\"page-subheading\">Release History<\/h2>\n<ul class=\"intro-text\">\n<li>Write Value 4.5.3 (this release)\n<ul class=\"intro-text\">\n<li>Changed the behaviour of the drop-down list when the data type of the value is not known.<\/li>\n<\/ul>\n<\/li>\n<li>Write Value 4.5.2\n<ul class=\"intro-text\">\n<li>Added ability to set the data type<\/li>\n<\/ul>\n<\/li>\n<li>Write Value 4.4.6\n<ul class=\"intro-text\">\n<li>Initial release<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If a datasource has been configured to allow writing to the database, right-clicking a component using that data allows users to update the tag\u2019s value at a point in time.  This article explains how to update a tag's value in the database.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/using-the-page-controls\/writing-values\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":29180,"parent":4254,"menu_order":61,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[4],"tags":[175],"class_list":["post-29178","page","type-page","status-publish","has-post-thumbnail","hentry","category-explainer","tag-tags","Version-4-5-2","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/29178","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=29178"}],"version-history":[{"count":1,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/29178\/revisions"}],"predecessor-version":[{"id":46069,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/29178\/revisions\/46069"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/4254"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/29180"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=29178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=29178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=29178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}