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

タグ付けされた投稿をもっと見る

Accepted answers

RobertScheitlin__GISP

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

RobertScheitlin__GISP

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:

RobertScheitlin__GISP

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

RobertScheitlin__GISP

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.

RobertScheitlin__GISP

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?

RobertScheitlin__GISP

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.

RobertScheitlin__GISP

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

RobertScheitlin__GISP

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.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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