topic Re: Why won't Query Builder show up??? in Geoprocessing Questions

Why won't Query Builder show up???

JoshV — Mon, 20 Sep 2010 15:08:27 GMT

Hello All-

I made a simple model for Selecting by Attrubutes and it works fine in ArcMap. The main thing is that the user can click the calculator icon and get the Query Builder window to help them create the SQL statement. Why won't this show up in ArcGIS Server? The QueryBuilder.png shows my model and the other picture is what I see in ArcGIs Server Web App Thanks..

Re: Why won't Query Builder show up???

JoshV — Tue, 21 Sep 2010 18:25:45 GMT

Does anyone have any ideas?? It's quite aggravating.. I attached two screenshots that show the button and query builder window when using the SelectbyAttributes tool within model builder of ArcMap. ArcGIS Server does not show that button when I publish it as a service for some reason.

Ideas? Thoughts?

Hello All-

I made a simple model for Selecting by Attrubutes and it works fine in ArcMap. The main thing is that the user can click the calculator icon and get the Query Builder window to help them create the SQL statement. Why won't this show up in ArcGIS Server? The QueryBuilder.png shows my model and the other picture is what I see in ArcGIs Server Web App Thanks..

Re: Why won't Query Builder show up???

JoshV — Mon, 04 Oct 2010 19:59:32 GMT

Can someone please help me here?? I don't understand why the "Query Builder" won't show up when I publish the Toolbox to a service. That is pretty important to have so has ESRI not included that with ArcGIS Server? My users are asking for a SelectByAttribute type of tool in the Web Applications and my model works perfect in ArcMap because it allows users to use the "Query Builder" to create their SQL syntax but that Query Builder does Not show up in Web App after publishing that toolbox. Am I missing something??

Thanks..

Re: Why won't Query Builder show up???

Anonymous User — Mon, 04 Oct 2010 22:55:15 GMT

Original User: dmhoneycutt

Only certain GP datatypes are supported by web clients, as explained here: http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Input_and_output_data_types. The Query Builder is not one of these datatypes.

The reason for this is that geoprocessing services have to be able to run on thin clients (a web browser) without ArcGIS installed. See the section "Data types and capabilities of the client" in http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Key_concepts_for_geoprocessing_services for more details/explanation.

Any unsupported data type becomes a simple string on the client. So the users of your service will have to enter a query string w/o the benefit of the query builder. You can work around not having query builder by supplying structured queries. See the example service in: http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=GP_Service_example:_Selecting_data

Re: Why won't Query Builder show up???

JoshV — Tue, 05 Oct 2010 11:43:40 GMT

Thanks Dale. So in other words, the user will still have to type SQL in order to fill the SQL expression? I'm not sure if that will work for me 😞 Do you have any more suggestions? Thank you for your time Dale

Re: Why won't Query Builder show up???

Anonymous User — Thu, 07 Oct 2010 17:51:26 GMT

Original User: dmhoneycutt

Perhaps this .NET Web ADF sample will suit your needs: http://resources.arcgis.com/gallery/file/net-web-adf/details?entryID=1629E6A7-1422-2418-88F0-F6A8C07A0004

See also this documentation in the web adf documentation: http://help.arcgis.com/en/sdk/10.0/serveradf_net/conceptualhelp/index.html#//00020000005m000000

Re: Why won't Query Builder show up???

JoshV — Thu, 07 Oct 2010 20:08:37 GMT

Hi Dale-

Thanks for the post and I might go that route but I still have one more question on the Geoprocessing route. In the attached picture, I have two parameters. One is the Feature Layer and the other is a parameter called "Attributes" that is of type Field and it shows the Column Names of the Feature Layer chosen when I run the tool. My question is can I have a Third parameter that will show the Values of the Column Name chosen (IE show values of second parameter chosen)??? This should be possible so do you know what Type of parameter and how I can do this?

This would be a big help if I could add that third parameter to get the values. Thanks

Re: Why won't Query Builder show up???

Anonymous User — Wed, 13 Oct 2010 14:52:49 GMT

Original User: jvickrey79

Perhaps this .NET Web ADF sample will suit your needs: http://resources.arcgis.com/gallery/file/net-web-adf/details?entryID=1629E6A7-1422-2418-88F0-F6A8C07A0004

See also this documentation in the web adf documentation: http://help.arcgis.com/en/sdk/10.0/serveradf_net/conceptualhelp/index.html#//00020000005m000000

Hi Dale- After looking at the tool you mentioned and testing it out, I believe I will try that. The end result is a selection of the features returned in the TaskResults container so what steps would you suggest in getting that selection set exported to shapefiles? I'm drawing a blank on that..

Many Thanks Dale

Re: Why won't Query Builder show up???

Anonymous User — Wed, 13 Oct 2010 16:58:38 GMT

Original User: dmhoneycutt

As far as I know (and I may be wrong here) there's no client-side code to turn the selection into a shapefile. There's lots of ways to do it on the server with a model. For example, you could select the features using Select Layer By Attribute (using the query string built on the client) and then use Copy Features to copy to a shapefile. See http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/GP_service_example_Selecting_data/002v0000001n000000/ for an example -- scroll to the first model.