I tried to create a custom portlet which fetches cost plan details. I want to display the time period ( like if period type is "Monthly", then fields time period needs to appear as Jan 17, Feb 17....against the cost for each month) . How could I display that time period (i.e. based on period type) in a custom portlet?
Thank you in advance.
You would need to use slice tables to get the data: daily/weekly/monthly etc
Its difficult to answer your question in any detail, but if you are using a stock data provider to drive your portlet then you would manipulate the time-scaled-value settings that the stock-provider gives you and if you were coding a NSQL query to drive the portlet then you would need to look at the appropriate slice tables (like NJ says).
There is info on the financial plan timescaled data in odf_sl tables.
If the links work see
Missing Documentation for ODF_SL* and ODF_SLL* tables
If not search the community, documentation and the KB articles.
There are many posts on the timescaled portlets
One of the m is
Search for more.