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.