topic Re: Help Setting Up a Date Search in ArcGIS Viewer for Flex Questions

Help Setting Up a Date Search

heatherGrybas — Wed, 02 May 2012 12:08:29 GMT

Hi Everyone,

I'm kind of a flex viewer novice so I was hoping you would be able to help me out. I'm using the simple out-of-the-box Flexviewer application for a project where I work and I need to set up a date search. I have three data sets that are edited by outside users and each one has a date field that must be filled in when an edit is made. I would like it if someone could type a date into the search widget and receive a list, popup, etc. of the edits made on that date. My only problem is that I'm not familiar with how to set up a query expression in the XML file for the search widget. I would really appreciate the help if anyone knows how to do this.

As a side note: My data is stored in an ArcSDE database which stores date AND time together. I only want the user to have to type in a date and not the time (the time part is where I keep running into trouble but there is no way to eliminate it right now).

Thanks for the help!

-Heather

Re: Help Setting Up a Date Search

RobertScheitlin__GISP — Wed, 02 May 2012 12:14:49 GMT

Heather,

What is the DBMS that is used with SDE (i.e. Oracle, SQL Server)? That make a big difference in the Date Query String. Also you can easily figure this out on your end by opening ArcMap and doing a Attribute query for that field and using the get unique vales button to get the proper date SQL format.

Re: Help Setting Up a Date Search

heatherGrybas — Wed, 02 May 2012 12:28:10 GMT

I'm using SQL Server.

I didn't really think about using ArcMap to find the query expression. I'll give that a try.

Thanks

Re: Help Setting Up a Date Search

heatherGrybas — Wed, 02 May 2012 12:55:31 GMT

I've been playing around with the expressions in ArcMap but I can't seem to get any returns. The dates show up in my unique values list like this :

'2012-01-26 05:00:00'

But I only want someone to type in the date not the time. I've tested a number of expressions using the wildcard but I can't get any returns. ArcMap just tells me that there are no records. This the the expression I've been working with:

DateEntered LIKE '2012-01-26%'

Re: Help Setting Up a Date Search

RobertScheitlin__GISP — Wed, 02 May 2012 13:16:05 GMT

Heather,

It would look like this:

DateEntered = '[value] 00:00:00'

for the OTB Search Widget expression

Re: Help Setting Up a Date Search

heatherGrybas — Wed, 02 May 2012 13:47:12 GMT

Its not giving me any returns when I put in a date. I've used multiple date formats too.

Re: Help Setting Up a Date Search

RobertScheitlin__GISP — Wed, 02 May 2012 13:53:19 GMT

Heather,

the value that needs to be entered in the widget would be YYYY/MM/DD so 2012/01/26

Re: Help Setting Up a Date Search

heatherGrybas — Wed, 02 May 2012 14:04:26 GMT

I'm still not getting any returns. Is it a problem if there are null values in the date field?

Re: Help Setting Up a Date Search

RobertScheitlin__GISP — Wed, 02 May 2012 14:30:34 GMT

Heather,

back in ArcMap make sure that this returns result when doing an attribute query on that layer:

DateEntered = '2012/01/26 00:00:00'

Re: Help Setting Up a Date Search

heatherGrybas — Wed, 02 May 2012 15:40:43 GMT

It didn't select anything. It worked when I changed it to

DateEntered = '2012-01-26 05:00:00'

I changed the query expression in the xml file to

DateEntered = '[value] 05:00:00'

but I received the Error #1009 message.

Re: Help Setting Up a Date Search

RobertScheitlin__GISP — Wed, 02 May 2012 16:34:42 GMT

Heather,

I need to see your SearchWidget.xml file then.

Re: Help Setting Up a Date Search

heatherGrybas — Wed, 02 May 2012 16:39:00 GMT

Heather,

I need to see your SearchWidget.xml file then.

I attached a txt file

Re: Help Setting Up a Date Search

RobertScheitlin__GISP — Wed, 02 May 2012 17:03:58 GMT

Heather,

You have to have a titlefield specified.

Re: Help Setting Up a Date Search

RobertScheitlin__GISP — Wed, 02 May 2012 17:35:56 GMT

Heather,

Don't forget to click the Mark as answer check on this post and to click the top arrow (promote).
Follow the steps as shown in the below graphic:

Re: Help Setting Up a Date Search

heatherGrybas — Fri, 04 May 2012 12:17:21 GMT

Wow. I can't believe I over looked that.

Thank you for the help!

-Heather