I was wondering if anyone has any experience with SQL queries in Portfolio Server. I have created a custom field “Safety Approved” with a predefined list with only allow from this list enabled. I would like to query the DB for the custom field “Safety Approved” and return a list of assests that has information in that field as well as the username that has made the edit. Is this possible?
Current config is Portfolio server 10.1 and SQL2008