Weird ESS Behavior

[JHaughey]

This is freaking me out  - a little.

 

 I have a SQL ESS View with 15 fields in it. When I do a find in that table, it produces bizarre, wrong results.  For example if i do a CTRL + F find, and type "5" into a field, it produces multiple records where that value is something other than 5. Has anyone encountered this before?

 

I thought it might be an indexing problem, but I confirmed that the field I am using as an index does contain only unique values. The index field is a row number that gets assigned in the SQL query that produces the view. Is that an issue?
 

Any thoughts are appreciated.

[Trey Caliva]

What kind of data type is assigned in the SQL field?

[JHaughey]

Thanks, Trey. It's a number. (int) 

 

After boldly declaring that my key field was unique, of course it turned out not to be. Something about the way the joins were put together in the SQL query created a situation where in some odd cases duplicate values could be returned. I added a row_number to the view to guarantee a unique key.

 

If nothing else, I sure learned some SQL this week!