Jump to content
Changes to the Jaspersoft community edition download ×

how can I get this Pol[i] into one list


mukeshnair18

Recommended Posts

I want to retrieve list of ABC and DEF in jasper report.Please help me out as I am not able to think of how I will be able to increment the POL node.

{  "CalcRespose":{    "xml":{       "Messages":[          {             "More":""        }     ],     "OUTPUT":{      "NODE1":"35.1",    "NODE2":"0.00",    "NODE3":"0.00",    "Pol1":{                 "ABC":"Red",               "DEF":"001"    },    "Pol2":{              "ABC":"BLUE",            "DEF":"002"    },    "Pol3":{              "ABC":"GREEN",            "DEF":"003"    },    "Pol4":{              "ABC":"YELLOW",            "DEF":"004"    }}}}}

This is the queryString in jasper.What I need is to display it in list,so is there any way to call POL instead of POL1

<queryString language="WebServiceQuery">        <![CDATA[{"getparameters" : { },"fields" : [ {"name" : "NODE1","expression" : "NODE1"}, {"name" : "ABC","expression" : "Pol1.ABC"}, {"name" : "DEF","expression" : "Pol1.DEF"} ],"options" : {"contentType" : "application/xml","rootPath" : "CalcRespose.xml.OUTPUT","baseUrl" : ""},"headersMap" : { },"queryData" : "{n  "CalcReq": {n    "xml": {n      "id": $P{CLIENT_ID}n    }n  }n}","GETParameters" : { }}]]>

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...