Community
Select to view content in your preferred language

querywidget

3973
3
02-09-2015 07:33 AM
HendrikBritz
by
Occasional Contributor
‎02-09-2015 07:33 AM

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 WorkWork

<?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 &gt; 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>

0 Kudos
3 Replies
RobertScheitlin__GISP
by MVP Emeritus
MVP Emeritus
‎02-09-2015 08:05 AM

Hennie,

  Try:

AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI &gt; 30 and AMMSTRAT.dbo.AssetRegisterLevels_RD_Surfaces.Surf_VCI &lt; 50

HendrikBritz
by
Occasional Contributor
‎02-09-2015 08:27 AM

Hi Robert

Thank you, that fixed it,

Regards

0 Kudos
RobertScheitlin__GISP
by MVP Emeritus
MVP Emeritus
‎02-09-2015 08:35 AM

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"