Skip to main content
10-Marble
January 28, 2023
Solved

QueryNamedPropertyHistory does not show anything

  • January 28, 2023
  • 2 replies
  • 3531 views

I have a Thing with a ValueStream that shows perfectly into a mashup with QueryPropertyHistory.

 

I'm trying to do the same with QueryNamedPropertyHistory. I have defined a new property in the thing called "Output" (name, description) that I have correctly filled (it is shown in the center grid of mashup).

 

alcubierre_2-1674936841390.png

 

 

I bind this Infotable "Output" into "propertyNames" and I expert that services returns and show the data in the top grid, but nothing is shown.

 

What's wrong?

 

alcubierre_0-1674936281478.png

 

The top grid is the QueryNamedPropertyHistory (KO)

The middle grid is "Output" infotable (OK)

The bottom grid is QueryPropertyHistory (OK)

 

alcubierre_1-1674936715771.png

 

 

 

Best answer by M4RC

Hello,

in your picture with the mashup overview it looks like "QueryNamedPropertyHistory" would be executed before the service "GetProperties" has submitted the output.
Thus, the "QueryNamedPropertyHistory" service is executed without the PropertyNames input and, as you would expect, returns "No Data".

 

I recommend to bind the event "ServiceInvokeCompleted" from the "GetProperties" service to the "QueryNamendPropertyHistory".

 

Best regards

Marc

2 replies

22-Sapphire I
January 30, 2023

Looks like you are using 'GetProperties service to supply the names, however that service doesn't provide the property names in the correct format.

I recommend using a service that I think is called, GetLoggedProperties or something like that, that will specifically get you a list of only the properties that are logged and be in the correct format.

Then if you set that to a list or something like that, you can also do a selection on that which then you would use SelectedRows into your QueryNamedPropertyHistory

 

10-Marble
January 31, 2023

No way...

 

alcubierre_0-1675173425465.png

 

I was trying to play around with the possiblity of use QueryNamedProperties directly.... I supponse the better way, that I have already tested OK, y to make a custom service that selects only some poperties and returns an infotable (datashape with the only property that I need to be shown) with the result.

M4RC14-AlexandriteAnswer
14-Alexandrite
January 31, 2023

Hello,

in your picture with the mashup overview it looks like "QueryNamedPropertyHistory" would be executed before the service "GetProperties" has submitted the output.
Thus, the "QueryNamedPropertyHistory" service is executed without the PropertyNames input and, as you would expect, returns "No Data".

 

I recommend to bind the event "ServiceInvokeCompleted" from the "GetProperties" service to the "QueryNamendPropertyHistory".

 

Best regards

Marc

10-Marble
January 31, 2023

It works!!!

 

Thanks.... I have learned a new feature from your reply.

 

alcubierre_1-1675179320022.png