11-Garnet

Solved

How to bind infotable result from sql query to dropdown widget in mashup

Forum|Forum|4 years ago
March 31, 2022
1 reply
1996 views

Hello Experts,

I am trying to get data from Postgress DB and map this generated infotable result to dropdown widget in mashup, but after mapping i could not able to see anything for selection in Value field, display field.

Temporary i am binding separately created datashape to dropdown widget, which works, but further i want to update another dropdown depending on selection of first dropdown.

Please support.

Mashup-Widget

Best answer by PEHOWE

@G_U,

Can you please provide the version of ThingWorx which is being used? There was an issue with ThingWorx 9.0.0 and 9.1.1.

It was fixed in a maintenance release 9.0.8 and 9.1.3

There is also an Article - CS366692 - ThingWorx ability to bind to individual "values" is no longer working

Regards,

Peter

22-Sapphire I

Did you associate a datashape with your output result of basetype infotable of the service?

You will need that if you don't.

the nice thing is that you can click the 'create datashape from result' to create it but then you still have to associate it in the service.

Author

11-Garnet

Thank You for quick response.

Yes, I have associated datashape with result. But still i am not able to see fields in dropdown.

I have tried both way.

1. Create datashape first and then associate in service to infotable.

2. Create service then select output as infotable and associate (By creating new option) datashape from there only.

22-Sapphire I

When you look at your service in the mashup builder and expand alldata or selectedrow(s) do you see all the field names (columns)?

You may have to remove the service and re-add the service if you had it initially mapped to the mashup without a datashape and added it afterwards