You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filter Expression

Summary: How to make a filter from an expression?


Content (required): Is it possible to make a filter for the following expression, which is basically the difference between creation date and the current date/time, i.e. how old it is? So the user can get the details of all incidents that have been open for a certain timeframe. This would include being able to ask for incidents that have been open between say 4 and 8 hours, for example.

date_diff(sysdate(),incidents.created)/3600


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!