Clarity

  • Private Community
 View Only

  • 1.  Display time period in Custom portlet

    Posted Mar 10, 2017 04:06 AM

    Hi,

     

    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.



  • 2.  Re: Display time period in Custom portlet

    Posted Mar 10, 2017 05:29 AM

    You would need to use slice tables to get the data: daily/weekly/monthly etc

     

    NJ



  • 3.  Re: Display time period in Custom portlet

    Posted Mar 10, 2017 08:17 AM

    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).



  • 4.  Re: Display time period in Custom portlet
    Best Answer

    Posted Mar 10, 2017 09:05 AM

    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

    https://communities.ca.com/message/101033107#comment-101033107 

    Search for more.