AnsweredAssumed Answered

How to use PIBatchDB.Search(bStrQuery)

Question asked by KarstenS on Mar 25, 2020
Latest reply on Mar 25, 2020 by KarstenS



I want to create a query that finds batches that were started between X and Y, like in the query tool:



Unfortunately the PIBatchDB.PIBatchSearch() method does not make clear what varSearchStart and varSearchEnd mean in relation to the batch itself:


 So I was looking at the Search(bStrQuery) method because I'm quite good at SQL:

Unfortunately I cannot seem to find a documentation about the underlying database and the fieldnames to query for.

Is there any such documentation and additionally how to format a date/time field in your particular SQL syntax.


Thank you.