Select to view content in your preferred language

SFV 1.3 Query builder Widget - Date field - underlying DBMS

3115
2
06-17-2010 08:52 AM
SusanMordy1
Deactivated User
Does anyone know what needs to be modified in the query builder widget code to work with Oracle SDE date fields in my map service?

The query Builder widget does not know what the DBMS management system is.  What is entered into the filter box is passed to the server as a request.  The server then passes that string to the DBMB and therefore needs to match the syntax requirements of the DBMS. 

When a user double clicks an esriFieldTypeDate field in my map service, I need code that creates the date syntax that the esriFieldTypeDate field (Orcale SDE) in my map service requires.

Thanks for your help,

Susan
Tags (2)
0 Kudos
2 Replies
DouglasGuess
Regular Contributor
Try this...

TO_CHAR(<your date field name>, 'MM/DD/YYYY')
0 Kudos
SusanMordy1
Deactivated User
Hi Doug,

Sorry, I am not sure how I would incorporate the above code into Querybuilderwidget.mxml..
0 Kudos