topic Re: querywidget in ArcGIS Viewer for Flex Questions

querywidget

HendrikBritz — Mon, 09 Feb 2015 15:33:26 GMT

Hi All

My Querywidget worked fine but somehow don't anymore. There is something wrong with my sql statement.

I can access the layer via the browser, The one on the right handside works fine.

I get an RPC Fault faultString="Failed to execute query." faultcode="400" faultdetail="" error in flexviewer

Please help

Dont Work	Work
<?xml version="1.0" ?> <configuration> <layer>http:// ??/arcgis/rest/services/Sasol/SASOL/MapServer/3</layer> <query>AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI between 30 and 50 </query> <titlefield></titlefield> <linkfield/> <refreshrate/> <zoomscale/> <shareresults>false</shareresults> <orderbyfields></orderbyfields> <fields all="false"> <field name="AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI" alias="Surf_VCI" /> </fields> <symbols> <simplelinesymbol color="0xFF0000" width="5" alpha="0.8" /> </symbols> </configuration>	<?xml version="1.0" ?> <configuration> <layer>http://??/arcgis/rest/services/Sasol/SASOL/MapServer/3</layer> <query>AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI > 85</query> <titlefield></titlefield> <linkfield/> <refreshrate/> <zoomscale/> <shareresults>false</shareresults> <orderbyfields></orderbyfields> <fields all="false"> <field name="AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI" alias="Surf_VCI" /> </fields> <symbols> <simplelinesymbol color="0x00FFFF" width="5" alpha="0.8" /> </symbols> </configuration>

Dont Work

Work

<?xml version="1.0" ?>

<layer>http:// ??/arcgis/rest/services/Sasol/SASOL/MapServer/3</layer>

<query>AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI between 30 and 50 </query>

<shareresults>false</shareresults>

</fields>

</symbols>

</configuration>

<?xml version="1.0" ?>

<layer>http://??/arcgis/rest/services/Sasol/SASOL/MapServer/3</layer>

<query>AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI > 85</query>

<shareresults>false</shareresults>

</fields>

</symbols>

</configuration>

Re: querywidget

RobertScheitlin__GISP — Mon, 09 Feb 2015 16:05:19 GMT

Hennie,

Try:

AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI > 30 and AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI < 50

Re: querywidget

HendrikBritz — Mon, 09 Feb 2015 16:27:12 GMT

Hi Robert

Thank you, that fixed it,

Regards

Re: querywidget

RobertScheitlin__GISP — Mon, 09 Feb 2015 16:35:17 GMT

Hennie,

Glad to help. Now it is your turn to help the community by marking this question as answered. All you have to do is click the "Correct Answer" link (the one with the little green star) on the post that provided the answer for you. If the answer was not provided by one of the responders then you can mark any of the replies that you received as helpful by clicking on the "Actions" menu and choosing "Mark as Helpful"