In order to represent a hierarchy of data in tree widget where should I fetch the service data? I tried to get a table from sql using select query but I was not able to display any runtime data in tree. How should I approach this to get output like the attachment?
You need to provide an infotable as input to the tree widget that has at least two columns, a parent ID and a sub-heading ID which you should define in your widget configuration in the mashup editor. The output from the SQL select query should work, maybe it is something in the configuration of the widget.
There is a video that can be found in the help file as well: https://www.youtube.com/watch?v=JHToI9VDZ78
Hope this helps,
Thanks for your swift response. I referred the video but they are using the network but I am using the database table. I have attached the property configuration that I have set and my grid data. Please tell me what changes I should be making to get the output.
I see it is a bit confusing how the input should look. It seems like it must be something like this:
and then your definitions under your tree widget must be:
where you have to define the RootParentID as a value in your selected ParentIDField as I did root in my first two rows. It is unclear from the video that this is required because the output from the GetNetworkConnections service has a value that is blank as below:
This means that your output from the SQL query you would have to restructure into an infotable similar in structure as above.
The result would then look something like this:
I hope this has given some more clarity.