Getting multiple records to show inline in BIRT

One of the first rules I learned when creating reports was to get your report's select statement to do as much of the work for you. When the select statement is properly formatted, the statement can do a lot of the functional work you'd have to setup in BIRT. This …

Common SQL Server Statements for Maximo

SQL Statements

This page was originally an article on the site to hold a list of common and unique SQL statements. This page is a more permanent spot to reference SQL statements related queries, searches, or reports in IBM Maximo. There are two types of statements listed:

  • SQL Server Function …

Using 'rank over partition' in BIRT reports

One of the common reporting requests I get is provide a list of the most recent set of records out a series of updates or changes. For example, provide a list of all inventory items that have been added/changed in the previous month or all work orders that were …

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 …

Top