Referencing related data in Conditional Expressions

I was recently working with a power user at one of our sites and I was asked why a conditional expression they had created wasn't working. The user had previously used the SQL statement in a query, but now wanted to use it as a restriction for the purchase requests …

Schedule a Maximo Escalation from 6am to 6pm

One of the best features of Maximo is the Escalations app. An Escalation basically looks at conditions of a record in Maximo on a regular interval and if the condition(s) are met, triggers a notification or action to be fired off. The amount of heavy lifting that Escalations can …

Building your own 'special' Maximo query

One of the top prizes for any Maximo users is having that "special" query that they know will absolutely find everything they are looking for. Recently I was asked to get a list of every PM in part of the a plant. The Maintenance Manager wanted the list to include …

Javascript Date Functions in BIRT

One of the common tasks a report writer can be asked to do is sort or limit information based on certain dates or date ranges. They could use SQL functions like:

matusetrans.actualdate >= dateadd(day, -7, convert(varchar, getdate(), 101))
workorder.reportdate >= getdate() - 7
po.followupdate - getdate() >= 0
matusetrans.actualdate …
Top