I have created an External Content Type and am connecting to a SQL table. I created a list and added a field of External Data. The filed works fine and shows a list of all the data in that table to choose from. However, I would like to filter that data based on the current user and only have them select from a subset of values that pertain to them. I am not seeing how to do this. Is there a way to pass the current user to the External Data type field to only show them the values I want them to see?
Thanks!
Benjamin