<expression alias="Database" textsearchlabel="Search Projects:" isvaluerequired="true"> <values> <value prompt="Project Name" isvaluerequired="false" operator="AND" autosubmit="false">upper(Project_Name) LIKE upper('%[value]%')</value> <value prompt="Project Number" isvaluerequired="false" operator="AND" autosubmit="false">Contract_Number LIKE '%[value]%'</value> <value prompt="Detailed Job Type" isvaluerequired="false" userlist="Administration,Geosciences,Geostructural,all" autosubmit="false">Department = '[value]'</value> </values> </expression>
Jay,
If you are going to have multiple value tags for one particular expression parent than you need to think of them as you would any SQL statement in ArcMap. For example you first value needs an operator like AND, also each subsequent value needs an operator except for the last value in your values parent.<expression alias="Database" textsearchlabel="Search Projects:" isvaluerequired="true"> <values> <value prompt="Project Name" isvaluerequired="false" operator="AND" autosubmit="false">upper(Project_Name) LIKE upper('%[value]%')</value> <value prompt="Project Number" isvaluerequired="false" operator="AND" autosubmit="false">Contract_Number LIKE '%[value]%'</value> <value prompt="Detailed Job Type" isvaluerequired="false" userlist="Administration,Geosciences,Geostructural,all" autosubmit="false">Department = '[value]'</value> </values> </expression>
Jay,
are you sure you are using a version that supports the autosubmit attribute? It was introduced in Version 3.1.8 - 2/5/2013.
Suely,
Searching a related table is supported but it is not currently supported to select the related features in the map for the table that is searched. This enhancement is being looked at though.
Suely,
Actually since I responded to your post I have released a newer version that supports selecting related features on the map from a table.