Unsolved
4 Posts
0
720
September 10th, 2019 07:00
Query Expression Filters
Hello,
I am trying to obtain hundreds CLIPs based on a start date and time (2019-08-12 14: 22: 31.355) and an end date and time (2019-08-12 14: 24: 30.255).
I also have a STORAGE_ID (F1SH832AR1DI8e7GDF1QVQ7E1DAG41DI2LOQ6C0B4F4DRMT83N1JA).
In my java code:
// Define query expression, start and end times in GMT.
fpQueryExpression.setStartTime (startTime);
fpQueryExpression.setEndTime (endTime);
//fpQueryExpression.selectField(storageID);
I think it is clear that the time filter does it correctly, but to filter by STORAGE_ID the commented line is necessary?
If I add that line the results seem exactly the same as if I leave it commented and the only difference is that at a given moment of execution the following error occurs:
Centera SDK Error: Premature end of packet (transid = 'IS97530X312613P / 596 / QUERY') (- 10101)
If I leave the line commented the process ends successfully although the results obtained I think are not correct.
Some help? Thanks in advance
jmmoraj
4 Posts
0
September 12th, 2019 01:00
Hello, I have finally decided to use FPClip.Exists (thePool, clipID) to collect only in CLIP in particular that I need. I have put aside FPQueryExpression since it did not give me the expected results and I don't really know why.