Query Boolean Property History Working different among things

[JK_10744682]

Hi all,

I am experiencing strange behavior using QueryBooleanPropertyHistory among nearly identical things.

If I specify start and end date I see data on both things, as expected:

However, if I only specify end date, on one thing I get data but on the other I do not:

Why would there be different behavior for one versus the other? The things are created identically from the same template. Version 10.0.0. 

[Surya_Tiwari]

Hi @JK_10744682  

 Can you take a look at the article below?

https://www.ptc.com/en/support/article/cs226000

[JK_10744682]

This does not detail my issue. It actually says the issue I am having should not occur as leaving startDate/endDate empy should result in data based off the oldestFirst property.

[nmutter]

I assume that you have some filter applied in your query (which you blacked out)? If you do not have a filter - ignore the rest

With this query filtering the issue is that TWX will

1. fetch maxItems with the start/end date settings

2. on this result it applies the query

3. result is returned

So it most likely finds 500 entries, applies your query which filters out all 500 and you are left with 0 rows. You could verify this by making maxItems very big and see if you get some results at one point.

https://support.ptc.com/help/thingworx/platform/r9.6/en/index.html#page/ThingWorx/Help/Composer/DataStorage/ValueStreams/UsingTheQueryPropertyHistoryService.html "What happens Post-Processing?"

[JK_10744682]

I do not use a query here, so I don't believe that is the issue 

[nmutter]

yep. should be some other issue mh

[slangley]

Hi @JK_10744682 

It may be best to open a case for this so the engineer can meet and view your configurations.  If you would like me to open one on your behalf, please let me know.

Regards.

--Sharon