The ArcGIS Online feature search configured for a map service fails to return results from a joined view if the view and the feature class reside in different geodatabases.
Duplicate of NIM097308: This was a duplicate of NIM097308:
Adding a spatial view to ArcMap as a Query Table adds a '%' sign on the table name. The '%' gets appended to any joins made to that table. If the document is published as a map service, the service layer cannot be queried from REST.
解决办法
When adding the view to ArcMap, do not drag and drop from the Catalog menu. This adds a % sign that causes the issue.Go to File > Add Data > Add Data > select the view. This allows users to create the MXD properly, and thus the service properly.