I’ve created custom lists in PWA that use the External Content Type ” PWA Project Lookup from Published DB (ProjectServer_Published) ” (I believe this is a built-in content type) to choose the Project Name in the entry form. However, when we click the “Select External Item” icon to choose a project, the dialog box that opens has this warning across the top of the list: Warning: Too many results have been returned. This result set may be incomplete or truncated. Note: we get the same error on all of the built-in External Content Types.
We’ve determined that it only shows 201 random Project Names. I say random because they’re not alphabetically ordered in any way. Our issue is that, right now we have 368 projects. If we try to search for a project that is not in this incomplete list of 201, no results are returned.
Is there a way to fix this lookup so that it will show ALL the projects we have in oour server?