Configuring Search Widget 2.0

2599
5
04-05-2016 06:43 AM
NatashaManzuiga
Occasional Contributor

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

0 Kudos
5 Replies
RobertScheitlin__GISP
MVP Esteemed Contributor

Naty,

  Have you contacted esri tech support to log a bug/enhancement request?

0 Kudos
NatashaManzuiga
Occasional Contributor

No, I have not...
Do I need some authorization to ask for this question?

0 Kudos
RobertScheitlin__GISP
MVP Esteemed Contributor

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.

0 Kudos
DaveOrlando
Occasional Contributor III

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

0 Kudos
DaveOrlando
Occasional Contributor III

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.

0 Kudos