I have a publicly shared feature service published to Portal that includes a join through a read-only account to an SQL view in one database and a read-only account to our Roads layer in another database.
Meanwhile, while we try to access the layer through Explorer, we are getting the this error in the server log:
An invalid where clause or definition expression has been requested: "GIS_Data.A1.Roads.GlobalID,GIS_Data.A1.Roads.OBJECTID,GIS_Data.A1.Roads.ROAD_NAME,PW.PW_RO.%LatestPavementLiftVW.roadStatus,GIS_Data.A1.Roads.SHAPE
Thank you in advance for any insights on this! I have not posted to the forum before but did search for an answer and was unable to find anything specifically related to SQL views and viewing from Portal to AGOL. Apologies if I missed something.