Add functionality to annotate AF Elements using Web API.

It would be great if as an addition to conventional documentation there was a SWAGGER page with short explanation of methods and parameters (including return types, etc.)

OMF 1.2 specification includes an enhancement to allow the use of propertyoverrides keyword in container messages.
Request is to add this functionality to Web API OMF endpoint specifically for the uom property

For example:
1. device configured with uom, OMF application creates a type specifying that uom.
2 new version of the device changes the uom. OMF application needs to create containers with the new uom, retaining other properties of the type.

Extend the capability of PI SQL Client to connect directly to PI Data Archive Server

In the https://pivision-us.oxy.com/piwebapi/admin/search/database.html page the Rebuild Index button does not work. It should allow the pi vision administrator to immediate re-indexing of individual AF database at the time without affecting the usability of the others.

A user tries to retrieve date with timestamp 03-Nov-2018 23:59:59 (1 second before Daylight Saving Time beginning) in PI SMT, but the returned event has a timestamp of 04-Nov-2018 00:59:59. This is because PISDK timezone design is such that it can only transition DST on minute granularity, and the Windows TZ info for Brazil says the transition is at 23:59:59 so PISDK truncates the seconds for the transition rule.

Currently the PIPointQuery cannot contain a filter condition with same filter name twice per AND condition of the query string.

PointId:>5 AND PointId:<10.

This would cause an error.

Therefore filtering for a certain range is annoying as both result lists then have to be compared for common elements, workaround for the AND in above condition.

Enhancement:

Introduce a "BETWEEN" operator for the filter condition.

Allow multiple use of filter names in the same AND condition.

Allow PI OLEDB Enterprise access to AF Tables.  The current workaround is to have the table live on a SQL database and then link to them from AF.

'Time Zone = Server' is available in PI OLEDB Provider, but has not been added to 'PI OLEDB Enterprise'.
We have PI Data Archives in multiple time zones and require the ability to select the data in the server time zone.

The UpdateValues method does not implement by itself the exception mechanism. Exception is applied on the client side, for instance by UniInt interfaces.

As a developer,  I would like this fact to be mentioned in the documentation to avoid confusion:
https://techsupport.osisoft.com/Documentation/PI-AF-SDK/html/MOSIsoftAFDataAFDataUpdateValues1.htm

The channel/websocket feature of PI Web API would be more useful if it was possible to subscribe/unsubscribe to attributes on an existing channel connection. Currently you have to open the connection with all the WebIds you want in the resource URL. If you want to change which values you are receiving, you would have to close the connection and open a new one. Adding this new feature would also solve issues with maximum URL length limitations.

When an element is copied as reference (parent-child) elsewhere in the tree it then has multiple parents. One of it is the primary parent. This information needs to be added to the hierarchy tables.

PI AF SDK - Search Query Syntax - Filters

Allow results to be ORed. Currently Results can only be ANDed.

When retrieving values for attributes, impersonating the user can enable the user of security at the data source level. For example, with a PI Point Data Reference attribute, it could allow the user's authorization to be user at the data archive rather than the PI SQL DAS (RTQP) service account doing the data retrieval.

As we know there are 2 major competitor for cloud technologies that is Microsoft and Linux destros. If we want to use Linux docker image or PCF Linux image to connect AF SDK, we don't have any provision for this as of now because AF SDK does not support Linux OS. If we support this then most of cloud customer attracts to use AF SDK in their organization.

Both AFImport.exe and ImportXml (AFSDK) have options to continue on error (like is something is checked out or if there is a duplicate element name). For some reason the PowerShell version doesn't. This should be added.

Add support for AFElement versions to PI Web API.
1. Create a new Element Version by defining the effective date and an optional version comment. 2. Add Get and Find methods which support querying AFElements by setting a QueryDate.
See also https://pisquare.osisoft.com/message/122510-re-how-to-create-a-new-af-element-version-with-pi-web-api and https://pisquare.osisoft.com/message/59027

The customer would like the ability to schedule crawls for a specific AF database (it's quite large), so that crawls don't interrupt users who need to access the elements in the PI Vision search during their working hours.

Currently when searching for event frames, a 400 error is returned if not all elements in the search exist.

piwebapi/eventFrames/search?databaseWebId=WebId&Element:IN("\server\AssetSwap\Site2\Asset1";"\server\AssetSwap\Site2\Asset2"

This is cumbersome especially in the case of asset swapping in PI Vision when parent elements could contain variable child elements. For any parent element that contains less than the max child elements, a 400 error will occur when searching for event frames for related parent elements.