Search Widget Question - Multiple Feature Selection

[GavinMayeda]

I am working on a project where I would like to have the search return multiple features based on the first 5 digits of a 12 digit string.  I suppose my first question is whether this is possible or not.  It is not feasible for me to use the Query and Filter function due to the number of records involved.
I have tried several expressions in the Search Widget in hopes of making this happen, but I am unable to produce any results.
If the 12 digit string is '123456789000' I would like the search widget to return all records beginning with '12345'
The expression that I would normally use would be - Left([value],5)

As always, any and all help is sincerely appreciated.

[RobertScheitlin__GISP]

Gavin,

   This is a basic SQL query that you are attempting and the expression would like very similar to what you would use in ArcMap.

yourfieldname LIKE '[value]%'

[GavinMayeda]

Thanks Robert,

That is what I'm looking for, but how do I get it to cull the results based on the first 5 digits of a given 12 digit string?  The end user will be providing 12 digits, but I need the results based on purely the first 5 of the 12.

Thanks again!

[RobertScheitlin__GISP]

Gavin,

   For that you would have to modify code and do a substring function in flex code.

[GavinMayeda]

Thank you Robert,

Not being a programmer, this is beyond my skillset.  If I am understanding you correctly, in order to have a search or query that will have multiple parameters I will need to add/change code in the Flex Viewer itself?  I do have a programmer that works in my department, but she is unfamiliar with the ESRI products. 

I suppose a secondary question, would be if the EWidgets have a search/query widget that can handle multiple parameters.  At this point, the feedback that I am receiving from staff is that there would be approximately 4 to 6 parameters based on fields within the data.

Thank you again for the help and guidance.

[RobertScheitlin__GISP]

Gavin,

   To search for just a portion of what the user entered like we have been discussing in the thread... That would require changing the code in the searchWidget.mxml. As far as searching multiple fields that is supported by the eSearch widget with not coding required.

[GavinMayeda]

Ok, Thanks Robert.

Sorry about the other items, too much going on today and not enough coffee.