Configuring Search Widget 2.0

Question

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'

or

WHERE UPPER (FIELDALIAS) LIKE '2345'

Can someone fix it?

Thanks,

Naty

DaveOrlando · Answer

I should note that the issue disappeared after changing my data and dataframe's projection from WKID 4326 to 3857

UTM Z11N (WKID 26911) also worked fine.

DaveOrlando · Answer

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

rscheitlin · Answer

Naty,

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.