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

Vind meer berichten getagd met

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>

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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