Skip to main content
R
raj_selvaa501-Visitor
1-Visitor
July 17, 2018
Solved

List widget with Info table data shown as Blanks

  • July 17, 2018
  • 2 replies
  • 2147 views

Hi,

I have created a new Thing template service with return type as Info Table with data shape.

Created a new Thing and test service is returning expected values from SQL database.

 

 

 

When binding the data into List widget it only created 'N' number of empty rows based on number of rows from Service. I have already selected "DisplayField" and "ValueField" in List.

 

Kindly help me to sort out the problem.

 

Regards,

Selvakumar S

Best answer by mnarang

The Problem is the name of column in Data Shape does not match to the name of the actual column .Do one thing ,create a new data shape and a field with name "EquipmentName" .I think this is matching to the column name from DB .Attach this new data shape to the service result and detach the existing service from mashup attach it again so that on grid it will show "EquipmentName" .By this way you will see data in the mashup.

 

 

Thanks ,

Mukul Narang 

2 replies

M
mnarang5-Regular MemberAnswer
5-Regular Member
July 17, 2018

The Problem is the name of column in Data Shape does not match to the name of the actual column .Do one thing ,create a new data shape and a field with name "EquipmentName" .I think this is matching to the column name from DB .Attach this new data shape to the service result and detach the existing service from mashup attach it again so that on grid it will show "EquipmentName" .By this way you will see data in the mashup.

 

 

Thanks ,

Mukul Narang 

    R
    raj_selvaa501-VisitorAuthor
    1-Visitor
    July 18, 2018

    Thank you @mnarang 🙂

     

    I am new to Thingworx development, Spent more than 2 hours to address this issue on yesterday. 

    Glad you helped me out of this very soon.

     

    Regards,

    Selvakumar S

     

     

    Terms & ConditionsAccessibility statement