Clarity

  • Private Community

  • 1.  How to display database data in a custom HTML portlet

    Posted Feb 23, 2017 03:58 AM

    I need to fetch some data from CA PPM database and display it in my custom HTML portlet. Invoking the XOG services via JavaScript will not do it unless I hardcode user credentials. Also, there is no way to access the sessionID cookie as it is protected with htmlOnly flag. Are the any other options to interact with the database from HTML? 



  • 2.  Re: How to display database data in a custom HTML portlet

    Posted Feb 23, 2017 04:03 AM

    You should be able to pull the session id from the environment.

     

    Have a search on here for "html portlet" and you will find some discussions, for example ; Displaying Database Content in HTML Portlets  which I think has an example attached.



  • 3.  Re: How to display database data in a custom HTML portlet

    Posted Feb 23, 2017 05:15 AM

    thank you, David.

     

    I am working on OnDemand PPM environment where the sessionID cookie is protected from JavaScript access. 



  • 4.  Re: How to display database data in a custom HTML portlet

    Posted Feb 23, 2017 05:32 AM

    There are some comments here about on-demand access (look for Gene's comment at the end)  ; HTML Portlet Hello World Example 



  • 5.  Re: How to display database data in a custom HTML portlet



  • 6.  Re: How to display database data in a custom HTML portlet

    Posted Mar 03, 2017 03:23 AM

    update!

    the session id is already here for you in JS. You can fetch the value from window.clarity.session.sesionID