![\"\"](\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2022\/05\/image004-600x51.png\")
<\/a><\/p>\n
\nSites and Shifts as Parameters in Calculation Functions<\/h2>\n
When using the ShiftStart(), ShiftEnd() and ShiftNumber() calculation functions, you now have the option of specifying a site and shift pattern to be used in the calculation.<\/p>\n
The site and shift patterns are optional inputs.\u00a0 If these parameters are not specified, then the Default Site and the Default Shift Pattern of that site will be used.\u00a0 This replicates the existing single configuration that existed previously.<\/p>\n
NOTE:<\/strong> Check that you have the correct Default Site, and Default Shift Pattern for that site, to ensure that existing calculations continue to function as they did in previous versions.<\/p>\nThe calculations can now be configured in the following format:<\/p>\n
ShiftStart(Time [,Site] [,ShiftPattern])<\/span><\/p>\nFor example, ShiftStart(Time(), 'Perth', 'Operations').<\/span><\/p>\nThis will use the shift configuration, Operations, from under the Perth site for this calculation.<\/p>\n
The most common use cases for these calculations are to combine them with other calculations to limit the date range to a shift.<\/p>\n
An example is to sum a value for the shift,<\/p>\n
Sum_Sampled({TruckLoadEvents}, ShiftStart(Time(), 'Perth', 'Operations'), ShiftEnd(Time(), 'Perth', 'Operations'))<\/code><\/p>\n
\nShort Datetime Format for Datetime Fields<\/h2>\n
A \u2018Short DateTime\u2019 formatting option has been added to datetime fields. The new format is dd\/mm\/yyyy HH:mm:ss.<\/p>\n
\nPI Adaptor Handling of Adaptive Raw Requests Enhanced<\/h2>\n
For data fetches using the Adaptive Raw sample method, the PI Adaptor will now invoke the PlotValues() function of the historian API instead of performing the default reduction on raw data. For larger fetch ranges this should significantly reduce the overhead involved in servicing Adaptive Raw requests.<\/p>\n
\nP2 Server Updated to Connect to ODBC Data Sources<\/h2>\n
The Relational Adaptor has supported getting Timeseries Data via ODBC, but as the Relational Adaptor is for timeseries data only, we have not been able to get Tabular (Dataset) data from ODBC.<\/p>\n
In this release the inbuilt Dataset Adaptors now have the capabilities to allow them to connect to a generic ODBC data source.<\/p>\n
This means that systems that have an ODBC interface where you want tabular data returned can now be connected to P2 Server.<\/p>\n","protected":false},"excerpt":{"rendered":"
Explorer 4.10.1 includes opening an entry dialog from an entry search result, opening the Table of Contents by selecting an entity from a page, and the ability to download the Explorer License Audit list of users.<\/p>\n
Read more<\/i><\/a><\/p>\n","protected":false},"author":29,"featured_media":54041,"parent":28831,"menu_order":62,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[7],"tags":[],"class_list":["post-54574","page","type-page","status-publish","has-post-thumbnail","hentry","category-release-notes","Version-4-10-1","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/54574","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\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=54574"}],"version-history":[{"count":9,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/54574\/revisions"}],"predecessor-version":[{"id":69407,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/54574\/revisions\/69407"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/28831"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/54041"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=54574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=54574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=54574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"P2_RGB](\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/P2_RGB-Explorer-Icon.png\"){kind=icon}
<\/p>\n![\"\"](\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2022\/05\/image001.png\")
<\/a><\/p>\n