Hi, I see that there is a problem configuring the Search Widget with a Joined Table Field Search...
If I try to set the "Search Field" to a field of a joined table (ORACLE DB)...the widget doesnt work.
The problem is that the query
WHERE UPPER (SCHEMA.TABLE.FIELD) LIKE '2345'
to work with MapService should be:
WHERE UPPER ("SCHEMA.TABLE.FIELD") LIKE '2345'
WHERE UPPER (FIELDALIAS) LIKE '2345'
Can someone fix it?
This is the normal way to report a bug, by calling esri tech support. As long as you are under current maintenance with esri you or your organizations account manager will be able to call this in.
Was a bug ever reported?
Maybe this should go into a Server forum because I feel this is a server issue.
I've published the exact same service (a service with a simple table join, feature class and table in same file geodatabase) on 10.22, 10.41, 10.51 & 10.6 and the Query widget fails on all except for 10.22
Surely if a bug was reported after 10.22 it would have been fixed by now,.... right? haha