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; } } }

searching a date range

JamesArmstrong

I am using the enhance serch widget from Robert. Outstanding!!

Is there a way to include a search by range - such as a date or price range? Such are sales date for parcels.

I suspect that this may be something that needs to be edited in the source code, but thought that there may be a query statement that could also be used.

Thanks in advance

James

QQ??????20120222180342.png

QQ??????20120222180355.png

Find more posts tagged with

Accepted answers

Anonymous User

Original User: rscheitlin

James,

OK than try this:

<expression alias="Date Search"                            textsearchlabel="Search by Typing Full SQL  example:[ SALE_DATE &gt;= '04/03/2011' AND SALE_DATE &lt;= '07/01/2011'  ]...">[value]</expression>

All comments

Anonymous User

Original User: rscheitlin

James,

OK than try this:

<expression alias="Date Search"                            textsearchlabel="Search by Typing Full SQL  example:[ SALE_DATE &gt;= '04/03/2011' AND SALE_DATE &lt;= '07/01/2011'  ]...">[value]</expression>

JamesArmstrong

yes I am using the lates version.

I now dont think the issue is with the single quottons marks. Instead, it seems the issue centers on the <= sign. I have removed it, or used just the = sign and even the > and the parsing error is not thrown. With that sign (or even =<) the parsing error is thrown.

James

Anonymous User

Original User: rscheitlin

James,

Are you using version 2.5.1.3? If not that that is the problem.

JamesArmstrong

the actual query work great, though one issue. This is the code I put into the xml.

<expression alias="Date Search"
textsearchlabel="Search by Typing Full SQL example:[ SALE_DATE >= '04/03/2011' AND SALE_DATE <= '07/01/2011' ]...">[value]</expression>

as you can see I did change the data format a bit, but it does seem to work (I am using a SDE database) when I use the SALE_DATE >= '04/03/2011' AND SALE_DATE <= '07/01/2011' in the entry box.

This issue is that there is a parseing error if the SALE_DATE >= '04/03/2011' AND SALE_DATE <= '07/01/2011' is left in as the example string. If part of it is removed, there is no problem. I thought it may have something to do with the quotation marks around the date, but when removed, the same parsing erro happens.

JAMES

Anonymous User

Original User: rscheitlin

James,

It can be done in a Query but..... As multiple field queries are not supported in the eSearch expressions in the same way that others are you have to do a workaround.

The Query would look like this assuming you are using SDE and not a file GDB:

SALE_DATE >= '2010-03-03 00:00:00' AND SALE_DATE <= '2012-03-03 00:00:00'

You would have to manually type this in the TextBox of the eSearchWidget when you choose this expression in the dropdown:

<expression alias="Open SQL" textsearchlabel="Search by Typing Full SQL example:[ SALE_DATE >= '2010-03-03 00:00:00' AND SALE_DATE <= '2012-03-03 00:00:00' ]...">[value]</expression>

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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