https://community.esri.com/t5/arcgis-online-questions/arcgis-server-json-queries-not-working-in-new/m-p/1111916#M42769 <P>I created a map in the classic mapviewer that references secured ArcGIS Server layers (credentials are not stored). One of the layers I was using is a spatial view in the SDE and another has related tables through a relationship class.</P><P>When I open the map in the new mapviewer the data in the layers isn't showing on the map (although I am able to open the attribute table and look at the data). When I look at the console I get the error <STRONG>"An SQL statement with comments and/or semicolon is invalid". </STRONG></P><P>I have tried to remake my map so that I can use it in the new ArcGIS Dashboards and the data shows up when it is just looking for the objectid, but as soon as I try to symbolize the data on a field I get the same error, or sometimes - an invalid SQL statement was used.</P><P>I checked my ArcGIS server logs and it is pretty much the same error:&nbsp;<SPAN>An invalid where clause or definition expression has been requested: followed by my fieldnames.</SPAN></P><P><SPAN>How did the way that the JSON query is made change in the new mapviewer, and how can I work around this issue?</SPAN></P><P>&nbsp;</P> Wed, 27 Oct 2021 22:17:18 GMT StefanieWenker 2021-10-27T22:17:18Z https://community.esri.com/t5/arcgis-online-questions/arcgis-server-json-queries-not-working-in-new/m-p/1111916#M42769 <P>I created a map in the classic mapviewer that references secured ArcGIS Server layers (credentials are not stored). One of the layers I was using is a spatial view in the SDE and another has related tables through a relationship class.</P><P>When I open the map in the new mapviewer the data in the layers isn't showing on the map (although I am able to open the attribute table and look at the data). When I look at the console I get the error <STRONG>"An SQL statement with comments and/or semicolon is invalid". </STRONG></P><P>I have tried to remake my map so that I can use it in the new ArcGIS Dashboards and the data shows up when it is just looking for the objectid, but as soon as I try to symbolize the data on a field I get the same error, or sometimes - an invalid SQL statement was used.</P><P>I checked my ArcGIS server logs and it is pretty much the same error:&nbsp;<SPAN>An invalid where clause or definition expression has been requested: followed by my fieldnames.</SPAN></P><P><SPAN>How did the way that the JSON query is made change in the new mapviewer, and how can I work around this issue?</SPAN></P><P>&nbsp;</P> Wed, 27 Oct 2021 22:17:18 GMT https://community.esri.com/t5/arcgis-online-questions/arcgis-server-json-queries-not-working-in-new/m-p/1111916#M42769 StefanieWenker 2021-10-27T22:17:18Z