Clarity

  • Private Community

  • 1.  Is there a way to use the time-scaled data type into a portlet with NSQL query as data source?

    Posted Dec 07, 2018 04:36 AM

    Hi Everyone,

    Is there a way to use the time-scaled data type into a portlet with NSQL query as data source?

    It looks like NSQL does not allow dynamic time-scale data types.

    We are now using version 15.4 and I wonder if this feature is already available. 



  • 2.  Re: Is there a way to use the time-scaled data type into a portlet with NSQL query as data source?

    Posted Dec 07, 2018 05:13 AM

    Check these

     

    To create a Time Scale Value when the source is a NSQL?

    https://communities.ca.com/message/16319289  

     

    How to build custom grid portlet with time-scaled values? 

    https://communities.ca.com/message/2284026 

     

     

     

    NJ



  • 3.  Re: Is there a way to use the time-scaled data type into a portlet with NSQL query as data source?
    Best Answer

    Posted Dec 07, 2018 05:31 AM

    You are correct when saying
    NSQL does not allow dynamic time-scale data types.

    What a user can do is to use the team allocation system data provider like in Weekly Detail and Resource Workloads portlets. If you need columns that are not provided you are out of luck.

    Then you have to use NSQL and pull the data from the time slices and make your query to manipulate the data the it is displayed in a manner similar to TSV data.



  • 4.  Re: Is there a way to use the time-scaled data type into a portlet with NSQL query as data source?

    Posted Dec 11, 2018 07:11 AM

    Thanks for your quick responses.  I'll consider these inputs and also try to come up with other workarounds. 

    Hope to get back here with positive news!