troubleshoot why a db record not included in SearchWidget results

[AshleyOwens]

There is a record in our database that does not get returned as part of the SearchWidget results.
In case the number of included records was limited, I increased <maxrecordcount> in the proper .cfg files and restarted the SOM Service.
I debugged SearchWidget, and there is nothing I can see in the query or how results are processed that should prevent it from being included in the results.
On the other hand, the Identify widget returns the details of this record.
I hope my description isn't too vague, but does anyone have any troubleshooting tips for this type of issue?

[RobertScheitlin__GISP]

Ashley,

  Set up a SQL query that searches for that particular ObjectID.

[AshleyOwens]

OK, I can see what the OBJECTID is for that record in the database. What next?

[RobertScheitlin__GISP]

Ashley,

   What I meant was setup a layer expression in the SearchWidget.xml that is something like OBJECTID = 1

[AshleyOwens]

I added this custom WHERE clause to SearchWidget.xml:

objectid in (select objectid from ITS_SUBSTATIONS where name='WEST LYONS')

and it returned the record! Any idea why the record would be returned only when explicitly adding a WHERE clause for it??

[AshleyOwens]

Is there a limit in ArcGIS Server version 9.3 of 1,000 records that can show in a dropdown? What is the limit in version 10?

[RobertScheitlin__GISP]

Ashley,

  I believe it is 500 in 9.3 and has been bumped up to 1000 in 10 but both 9.3 and 10 allow that to be configurable on a individual map service basis. There are LOTS of forum posts about the 500 feature limit and what must be done to change that.

[AshleyOwens]

I think I know what you're talking about. We changed the <maxrecordcount> value from 2000 to 5000 in our cfg files and restarted services, but some records still don't show. We have less than 3,000 records in our database for this particular object, so I'm still not sure why not all are showing!

[RobertScheitlin__GISP]

Ashley,

  Strange... I would run a check geometry toolbox on the data and see if you have any issues with the data itself.

[AshleyOwens]

Sorry for the ignorance...how do you "check geometry toolbox on the data"?  What tool is used?