topic Re: Using a field as a value in GeoEvent filter in ArcGIS GeoEvent Server Questions

Using a field as a value in GeoEvent filter

ElliottCarson — Mon, 30 Nov 2015 09:04:11 GMT

Can anyone suggest how I might go about using a Field instead of a Value when creating a filter in the GeoEvent filter properties dialog?

I've successfully added static values to the Value box, however I would like the processor to check dynamically on the current date minus an hour.

Any suggestion that would solve my dilemma would be greatly appreciated.

Regards,

Elliott

Re: Using a field as a value in GeoEvent filter

IrfanClemson — Mon, 30 Nov 2015 19:13:15 GMT

Elliot,

There should be a 'Field' tab right besides the 'Value' tab but that is missing in your attached image? On my system the Field tab is present.

Re: Using a field as a value in GeoEvent filter

ElliottCarson — Tue, 01 Dec 2015 10:34:22 GMT

Thanks Meengla,

Identifying the definition in the drop down, initiated the Field tab to click on.

Also note that when comparing dates in a filter, I could only get them to work if I converted them to epoch values via a field calculator process before hand.

Regards,

Elliott

Re: Using a field as a value in GeoEvent filter

RJSunderman — Fri, 29 Jan 2016 02:00:13 GMT

Hello Elliott -

Creating a filter expression to compare two date values is difficult. The product team has an issue open in the product backlog to address this. For now, as you suggest, you could use a Field Calculator to "cast" the date/time from an event's Date field to a field whose type is Long, and then use a Filter to compare two long integer (epoch millisecond) values. You could also use date/time algebra notation supported by filter expressions ... please see the links below.

Hope this information helps -

Re: Using a field as a value in GeoEvent filter

ElizabethDoran — Wed, 27 Apr 2016 17:26:09 GMT

Hello-

How do you use the Field Calculator to "cast" the data/time from an event's Data field to a field whose type is Long?

Will the issue with comparing dates be fixed in the next release?

Thanks