I'm currently creating a Document management system in On-prem SP 2013 to store documents with specific meta data terms so the document library is easily searchable/filtered.

We have an external DB that contains a view with all of our customers names, I have created a external content type from this and a picker in the Document library that allows you to choose a customer from the DB and assign its value to a External Data column.

The issue I'm now having is that I'm unable to find a way to filter by the customer name/external data column in the same way i'm able to with Meta data terms.

Any help with how to achieve this would be greatly appreciated. The only work around i currently have is to create each customer as a meta term, however as there is no option to sync terms with a DB this would be a nightmare to administer.


Screenshot of current layout

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.