Setting a DateTime for testing SQL statements

One of the tenets I teach about reporting in Maximo is to look for the exceptions in the data, not the data itself. Out of the box, Maximo has quite a few key reports included, one of them is the WO List report (wotrack.rptdesign). That report lists every work …

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 …

Top