cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

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

G_U
11-Garnet
11-Garnet
‎Mar 31, 2022 07:00 AM
‎Mar 31, 2022 07:00 AM

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

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.

 

 

 

 

Labels:
0 Kudos
Notify Moderator
5 REPLIES 5
PaiChung
22-Sapphire I
22-Sapphire I
(To:G_U)
‎Mar 31, 2022 08:43 AM
‎Mar 31, 2022 08:43 AM

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.

 

Notify Moderator
G_U
11-Garnet
11-Garnet
(To:PaiChung)
‎Mar 31, 2022 09:17 AM
‎Mar 31, 2022 09:17 AM

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.

 

 

Notify Moderator
PaiChung
22-Sapphire I
22-Sapphire I
(To:G_U)
‎Mar 31, 2022 09:26 AM
‎Mar 31, 2022 09:26 AM

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

Notify Moderator
G_U
11-Garnet
11-Garnet
(To:PaiChung)
‎Mar 31, 2022 09:35 AM
‎Mar 31, 2022 09:35 AM

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

Answer: No, I dont see any field name.

 

As per your suggestion i have tried the same and also tried to create new service with new datashape, but still facing same issue.

 

G_U_1-1648739132077.png

 

0 Kudos
Notify Moderator
PEHOWE
16-Pearl
16-Pearl
(To:G_U)
‎Apr 04, 2022 04:36 PM
‎Apr 04, 2022 04:36 PM

@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

0 Kudos
Notify Moderator
Top Tags