I have two workforce hosted layers that I need to join. Assignments layer has only workerID but no name. Worker layer has the name and the objectID is the workerID. So I connected to the layers in ArcMap and created a join to be able to show the name field. I tried publishing the MXD as a service, but I get the "SEVERITY STATUS CODE DESCRIPTION NAME TYPE DATA FRAME High Unresolved 00004 Layer's data source is not supported Assignments Layer Layers" error after analyzing. I tried converting the hosted layers to hosted views, but still got the same error. I then tried to publish the MXD as a service to my local server and still got the same error.
If this is not possible, how can I join those two layers and post them so people can see the fields needed?
Mind you, this data is updated in real time. I cannot create a new layer because it has to show actualized data.