nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Help Setting Up a Date Search

heatherGrybas

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

Najděte více příspěvků označených jako

Accepted answers

rscheitlin

Heather,

You have to have a titlefield specified.

SearchWidget_DateEntered-1.txt.zip

All comments

heatherGrybas

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

Thank you for the help!

-Heather

rscheitlin

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:

rscheitlin

Heather,

You have to have a titlefield specified.

SearchWidget_DateEntered-1.txt.zip

heatherGrybas

Heather,

I need to see your SearchWidget.xml file then.

I attached a txt file

SearchWidget_DateEntered.txt.zip

rscheitlin

Heather,

I need to see your SearchWidget.xml file then.

heatherGrybas

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.

rscheitlin

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'

heatherGrybas

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

rscheitlin

Heather,

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

heatherGrybas

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

rscheitlin

Heather,

It would look like this:

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

for the OTB Search Widget expression

heatherGrybas

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%'

heatherGrybas

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

rscheitlin

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.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.