Using a field as a value in GeoEvent filter

[ElliottCarson]

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

[IrfanClemson · Accepted solution]

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.

[ElliottCarson]

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

[RJSunderman]

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 -

RJ

See Also:

• How to Create Temporal Filter in GeoEvent​
• Re: Filter out Time Anomalies​

[ElizabethDoran]

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