I am new to Smart Notifications and need some help.

I have an infoset based on an Oracle view which has a date field. In my infoset (Define Infoset step) this field shows a date type field with a format of 02/16/1968 and I define it as a 'measure' field type.

In the notification, select range of facts screen, the field appears under Measures with 5 check boxes: Total, Average, Min, max and Count with Total checked by default.

I was hoping to have a condition on this date field such as 'greater than today' and have the notification show each record with that condition with a red button.

What do I have to do to accomplish this?

I am on version 3.2

Thanks

SmartNotes is not the best tool to do intensive business logic such as comparative dates. The catch 22 is that you can only create a condition off a measure but a measure has to be aggregated. If you can, id do the date comparison in your SQL statement, if you cant do that then make sure your infoset has only the fields you need for the notification youre writing. Then in the notification, be sure to select ALL the items (non-measure). Keep your date as a measure and in the notification section you can check any one of the option, it wont matter since there will only be one line. Then in the condition you will need to use the date format procedures defined on page 217 of the SN user guide. as you can see its pretty tricky and thats why i suggest doing date validation in step one of the infoset creation.

hth
matt

Thanks. That was the way we went with it.