To get the data from the SQL DB depending on the logged in user RRS feed

  • Question

  • Hi,

    In our application,  we have created an External Content type for the each table in the DB and created the BCS list for each of these  External Content types. We are saving the the data from the UI and retrieving the data to the UI using the BCS list.

    The issue is that , the  threshold defined in our company is 20000 per list in Share point.  Our data is going above the defined threshold. We have to get the data to the BCS list from  the DB depending on the logged in user.

    Please let me know:

    1. how to filter the External Content type based on the logged in user? 

    2. how to give the logged in user input to the External content type.

    Thanks and Regards,


    Monday, August 19, 2019 9:32 AM


All replies