I have the following "requirement", We have a amount of requests that have a behavior weekly, so I need to show a line chart from a specific request to show their behavior. I think three options: - The first option is to create a porlet that receive the number of the request as a parameter,by clicking a link into the request, but the issue with that was that I couldn't create a data source that receive the request number as parameter, I think that in data sources I only can use "SYS." tokens. - The second option that I think to that requirement is that create a porlet that user has to "configure" the request that they want to see their behavior, but I don't know how to create a porlet like this. - The third option is to put the porlet into the request but I think that it is not possible.
Thank you very much for your response. Mahen our case is that we have a group of requests (more lest 400) and they want to see the behavior for each request into the line chart porlet, but they want to see one request at the time; so this is the reason that I thought the three scenarios: - The first to create a porlet that receive the request number by parameter. - The second to create a porlet that it could be configurable for the user that he could select the request that he wants to see the behavior. - The third is to "put" the porlet (the link or the graphic) into the request.
I'm attaching the sql from the DS. I hope I have explained better our case.
You could have a portlet that lists all of the requests you would be interested in. Set up your detailed portlet for a single request as a drill-down portlet, passing to it the request number from the selected line.