My requirements are:
- Serverside filtering on multiple columns/attributes
- Serverside sorting on multiple columns/attributes
- Serverside paging
Now I am using PI Web API with clientside filtering on columns/attributes, as PI Web API, as far as I can see, doesn't support searching/queries on attributes. But, loading 10.000+ event frames in to the web client is not an option.
So what will the best approach be to support searching on attributes?
- Wait on the announcement that PI OData is released soon?
- Wait on PI Web API to support searching for event frames on attributes?
- Write my own OData or REST endpoint supporting PI security based on?
- AF SDK?
- PI OLE DB?
I really need that OData