Create external content type based on SQL query from PWA database. RRS feed

  • Question

  • Hi,

    I want to create a dashboard in Project Page in PWA or Project site which will give information about the project.

    I want to create a list which will have data from SQL server PWA DB with 'where clause'.

    So I want to pass project ID to that external list and get the relevant data from SQL.

    My question is :

    1. How can I get project ID in project site.

    2. How can I create ReadList or ReadItem operation on external list where my SQL query contains where clause.

    Thanks in advance

    Thursday, October 29, 2015 8:36 AM