Skip to main content
17-Peridot
March 3, 2017
Solved

Using "Sort" query on QueryPropertyHistory

  • March 3, 2017
  • 1 reply
  • 3767 views

I'm attempting to use the "sort" query with QueryPropertyHistory but it is returning:

Error Executing Service

Unable to Invoke Service QueryPropertyHistory on dataHubThing : null

My query is:

{"sorts": [ { "fieldName": "flowRate" } ] }

If I use a "filter" it works just fine.  As soon as I try a sort, it returns the above message.

Instance is: ThingWorx 7.2.5-b56

Best answer by PaiChung

It looks like this indeed isn't working, please submit this as a bug on support.ptc.com

in the mean time you can use the Sort function after you've done querypropertyhistory

1 reply

22-Sapphire I
March 3, 2017

What does the full script look like?

nmilleson17-PeridotAuthor
17-Peridot
March 3, 2017

I'm just testing the QueryPropertyHistory and manually entering the query into the "query" field.  No script. 

PaiChung22-Sapphire IAnswer
22-Sapphire I
March 6, 2017

It looks like this indeed isn't working, please submit this as a bug on support.ptc.com

in the mean time you can use the Sort function after you've done querypropertyhistory