topic Re: searching a date range in ArcGIS Viewer for Flex Questions

searching a date range

JamesArmstrong — Wed, 22 Feb 2012 14:32:46 GMT

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

Re: searching a date range

Anonymous User — Wed, 22 Feb 2012 15:09:45 GMT

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>

Re: searching a date range

JamesArmstrong — Wed, 22 Feb 2012 16:36:59 GMT

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

Re: searching a date range

Anonymous User — Wed, 22 Feb 2012 16:40:30 GMT

Original User: rscheitlin

James,

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

Re: searching a date range

JamesArmstrong — Wed, 22 Feb 2012 17:47:32 GMT

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

Re: searching a date range

Anonymous User — Wed, 22 Feb 2012 18:01:33 GMT

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>