AnsweredAssumed Answered

How to use PIBatchDB.Search(bStrQuery)

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

Hi,

 

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.

Outcomes