Skip to main content
S
sbt15-Moonstone
15-Moonstone
March 12, 2018
Solved

NAN when used in the mashup grid widget with GetPropertyValuesAsMultiRowTable.

  • March 12, 2018
  • 1 reply
  • 2079 views

Hello ,

I have a thing template, where i have written a service to get the property value in the MultiRowTable format using "GetPropertyValuesAsMultiRowTable" and used Query to filter out certain properties.

I have thing which uses this template, when i run the service in the composer from the Thing i see the values coming in.

But when i use the same service in the mashup i see the value NAN.

Note: i have used dynamic thing template and passed the thing name to the EntityName.

Not sure what am i missing.

 

Thanks

Sunay

Best answer by mnarang

That's great if it worked out ,can you please accept the solution and mark it as correct
Thanks 

1 reply

M
mnarang5-Regular Member
5-Regular Member
March 12, 2018

Hello,

 

Instead of directly using the generic ThingTemplate service "GetPropertyValuesAsMultiRowTable",create your own service in ThingTemplate with any name and in the code use the same service like this - 

// result: INFOTABLE dataShape: "undefined"
var result = me.GetPropertyValuesAsMultiRowTable();

 

This service will result an infotable as output of the service ,create a data shape having fields matching your output of "GetPropertyValuesAsMultiRowTable" .So basically now we have a custom service containing the same functionality as you are doing directly with an infotable output .Use this service in mashup as you were doing before (dynamic and on mashup load if you want ) .After this map the output of this service to a grid and pass the entity name as thing name .You will see values there .Do let me know if this is not clear .

S
sbt15-MoonstoneAuthor
15-Moonstone
March 13, 2018

Yes i have created my own service and used "GetPropertyValuesAsMultiRowTable" inside the service.

I got the solution, the reason was the value column datatype was wrong.

Thanks

M
mnarang5-Regular MemberAnswer
5-Regular Member
March 13, 2018

That's great if it worked out ,can you please accept the solution and mark it as correct
Thanks 

Terms & ConditionsAccessibility statement