eSearch - search condition

[PaulaAlmeida]

Hi,

it is possible to execute a query if the condition is depending of dropdown value, defined by userdomain, and the condition is an interval, only using the config xml file?

assuming that the layer X has the fields A, B and C, and  the layer contains numerical values ??????for each field, like this:

#   A    B    C
1   1     2    3
2   1     2    4
3   2     3    5


I want to make available a query, where the user, select each field want to know (in one dropdown), and select a interval of values in the second dropdown. something like this:

<expression textsearchlabel="">
<values>
<value prompt="Field" alias="FIELD" userlist="A,B,C>  </value>
</values>
<values>
<value prompt="Value" userlist="0-1, 1-3, >3"> [FIELD] > [value]</value>
</values>
</expression>


It is possible?

Thanks,
Paula

[RobertScheitlin__GISP]

Paula,

   No that is not exactly possible just using xml configuration. The big issue is the SQL expression... Can you write a SQL expression for a between two numbers in ArcMap? Maybe something like what I have below (untested).

What you would have to do is to define an expression for each of the fields.

            <expressions>
                <expression alias="Field A" textsearchlabel="Search by Field A:">
                    <values>
                        <value prompt="Exmaple: FIeld A Value" userlist="&lt;=1,&gt;1 AND &lt;=3,&gt;3">FIELDA '[value]'</value>
                    </values>
                </expression>
                <expression alias="FIeld B" textsearchlabel="Search by Field B:">
                    <values>
                        <value prompt="Example: FIeld B Value" userlist="&lt;=1,&gt;1 AND &lt;=3,&gt;3">FIELDB = [value]</value>
                    </values>
                </expression>
            </expressions>

Also All Flex Viewer/Widget question need to be asked in the Flex Viewer forum:
http://forums.arcgis.com/forums/111-ArcGIS-Viewer-for-Flex