topic Re: Attribute Query using Model Builder in ModelBuilder Questions

Attribute Query using Model Builder

akshayloya — Tue, 06 Sep 2016 17:38:16 GMT

Hi Everyone,

I want to create model in arcmap using model builder for select by attribute.

1) I want to create a dropdown list for columns fields of the selected feature class

2) Write a dynamic sql expression as in:

a) User will select column name from the drop down.

b) User enters a value in a value box

c) At a back end, SQL query is made based on above selection.

Example: Select Features from School feature class having objectid >= 6 AND objectid <= 15.

This is simply to make attribute query easy to use for the user. Any help will be greatly appreciated.

Thanks in Advance!

Re: Attribute Query using Model Builder

DarrenWiens2 — Tue, 06 Sep 2016 17:47:40 GMT

Your example (objectid >= 6 AND objectid <= 15) illustrates the problem with using rigid dropdown lists to build SQL queries. It includes (or could include) multiple fields, operators, and a condition. You could make dropdowns for all of those, but how is that any better than the out-of-the-box query builder within the Select Layer By Attribute tool?

Re: Attribute Query using Model Builder

akshayloya — Wed, 07 Sep 2016 03:01:52 GMT

There will be only one condition mentioned above (between) and the same operators will be used. So I don't want user to select all those options. He will simply select field from a dropdown and in to boxes he will enter the value.

Please refer to pic below.