AnsweredAssumed Answered

wrong result of find tool

Question asked by geonetadmin on Nov 1, 2012
Latest reply on Nov 2, 2012 by recurvata
Original User: OlegG

I've got a trouble with the Find tool.
The result of search is incorrect.
I have a text field with the value 'agreement from 08/05/11'.
When i use the Find tool with the search text 'from 08/05/11' i've got a result - 1 row. That's ok.
But if I type the search text as '08/05/11' i've got empty result - 0 rows.
Extra params: search in ALL fields. P.S. If i define this field, the search result is ok.

What i see in the sde log:
SDE_Oracle Error: 932  ORA-00932: inconsistent datatypes: expected DATE got NUMBER

As I understand my search text is treated as date and converted to milliseconds and there is a problem with a search.

I need to force find tool to work ALWAYS without WORK AROUNDS.