Autocomplete Manager can pick data from SQL Server datasource (you can write any query).
To configure this mode:
1. Enable Autocomplete for this field.
2. Select “SQL Query” as data source.
| In Project Server 2010 | In Project Server 2013 |
 |
 |
3. Write connection string as follows:
Server=w2008r2ps;Database=ProjectServer_demo_reporting;Trusted_Connection=True
Instead of trusted connection, you can embed credentials, but it is not very secure.
You can use Test button to verify connection.
4. Write SQL Query statement:
Select projectname from MSP_EpmProject_UserView where (EnterpriseProjectTypeUID is not null)
You can write any query as long it is returning single value.
You can use Test button to verify your query.
| In Project Server 2010 | In Project Server 2013 |
 |
 |
5. Click Save - field configuration is completed.
6. Save edits to PDP.