topic Query Boolean Property History Working different among things in ThingWorx Developers

Query Boolean Property History Working different among things

JK_10744682 — Tue, 04 Nov 2025 16:01:31 GMT

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.

Re: Query Boolean Property History Working different among things

Surya_Tiwari — Wed, 05 Nov 2025 12:39:06 GMT

Hi @JK_10744682

Can you take a look at the article below?

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

Re: Query Boolean Property History Working different among things

JK_10744682 — Wed, 05 Nov 2025 13:10:23 GMT

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.

Re: Query Boolean Property History Working different among things

nmutter — Thu, 06 Nov 2025 17:27:14 GMT

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?"

Re: Query Boolean Property History Working different among things

JK_10744682 — Thu, 06 Nov 2025 17:35:16 GMT

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

Re: Query Boolean Property History Working different among things

nmutter — Thu, 06 Nov 2025 17:59:53 GMT

yep. should be some other issue mh

Re: Query Boolean Property History Working different among things

slangley — Thu, 13 Nov 2025 21:13:55 GMT

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