Can some one please provide me a query behind Unfilled Requirements portlet? I tried Sql trace but I am not able to extract the exact query out of that SQL trace file.
You can try doing an SQL trace
Have you checked this ?
Thanks for the response joshi.
Actually this unfilled requirements portlet is a system portlet and it exists in clarity application already. So instead of building the portlet from scratch I would like to see the NSQL Query behind this portlet so that i can do some customization according to my requirement.
I tried sql trace and in the trace output file actually there is a lot of information and i am not able to find the exact query.
Can someone please provide me the Query?
You have asked for the NSQL query behind this portlet - but there isn't any NSQL.
Portlets can have two types of a 'data provider' that are used to fetch the results for display. One is NSQL, the other is a System Data Provider.
Unfilled Requirements is based on a System Data Provider called Team Allocations.
System Data Providers are implemented in java within the Clarity application source code; they produce one set of results to the UI but could put that together from multiple queries or even mix in some coded logic in Java to influence the results before they are put to the screen. Often times, the System Data Provider will dynamically include/exclude (change) parts of the query in order to accommodate different requests - such as depending on which fields are selected or being used as a filter.
So whilst a SQL Trace might identify part of what a System Data Provider uses to generate the results, it won't be the full picture, sorry.
Thanks Nick. That's a good information to know.
One Question regarding this portlet is, it is displaying different results for different users. If I login to my clarity account i see a results of some 465. Other user login to his clarity account will see a result of 870. Can you please let me know what I should do to resolve this ambiguity?
Also When I filter the results on this portlet using investment type of 'idea' and primary product value of something it gives empty results.
Retrieving data ...