6 Replies Latest reply on May 29, 2017 2:07 AM by tguo RSS
    tguo Explorer

    How to use dropdown selection as input to get sql script output

    I want to use dropdown selection as input to get sql script output.

    1) I create a service using sql, the input is a string

    WeChat Image_20170528072015.png

    in SQL script, like this:

    WeChat Image_20170528072040.png

    2) In the mashup, there is a piechart to show the sql script result:

    WeChat Image_20170528072132.png

    3) The service is created successfully. The parameters are show in the service

    WeChat Image_20170528072148.png

    4) The dropdown menu service is like this, the 'name' is the input to the pie chart sql script

    WeChat Image_20170528072237.png

     

    I tried to drag the 'All Data' -> 'Name' or 'Selected Rows'->'Name' to match the input parameters 'BuildingName'. To get the pie chart input data. But failed.

    How can I manage to do this? Thank you!

    Sushant Pandey