Special Automation Scripts NEW, SAVE,DUPLICATE,AFTERDUPLICATE | Maximo

 <MBONAME>.NEW

 <MBONAME>.DUPLICATE

 <MBONAME>.SAVE

Introduced in 7613.

 <MBONAME>.AFTERDUPLICATE

IBM Maximo Autoscripting Guide – OBJECTNAME.DUPLICATE Script (ibm-maximo-dev.github.io)

Restrict a User to Delete an Attachment from an Approved PO | Maximo

The requirement is to lock the record so that nobody can delete a record if the purchase order is approved.

And the solution is with a small automation script on DOCLINKS object:

object: DOCLINKS

event: BEFORE SAVE

Type: Object Launch Point

Script: Jython

owner=mbo.getOwner()

if owner and owner.getName()=="PO" and owner.getInternalStatus()=="APPR" 

    service.error("","Purchase Order is approved. ")

Also ideal to control it via the signature option, create a new signature option from the application designer and grant access using the relevant security groups then just use it in your code. thanks to Steven Shull.

owner.sigopGranted("DELETEATTACH"): 

Add plus Sign and inverted comma (+") in each line in variable | BIRT

 for beginning of the line, Find and Replace as below:

^p

^p+"    

 for End of the line, Find and Replace as below:

^p

    "^p

Using DBC Scripts in Maximo in Windows environment

 DBC (Database Configuration) scripts are a powerful way to customize your system, such as adding new attributes to existing objects. In this post, we’ll walk through practical examples, including creating a custom attribute in the Asset object and generating DBC scripts from an autoscript

Example 1: Adding a Custom Attribute to the Asset Object

Suppose we want to add a Maintenance Cost attribute to the ASSET object. Here’s the step-by-step process:

1. Create a DBC Folder

Create a folder to store your DBC script:

mkdir D:\IBM\SMP\maximo\tools\maximo\en\aq

2. Create the DBC File

Create a new DBC file aq_add_cost_to_asset.dbc in the folder:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE script SYSTEM "script.dtd">
<script author="aq" scriptname="aq_add_cost_to_asset">
    <description>Adds Maintenance Cost to the Asset</description>
    <statements>
        <add_attributes object="ASSET">
            <attrdef
               attribute="ZZMAINTCOST"
               title="Maintenance Cost"
               maxtype="AMOUNT"
               remarks="Maintenance Cost for the Asset"
               persistent="true"
               required="false"/>
        </add_attributes>
    </statements>
</script>

Standalone Lookup Using Relationship - Birt Report Parameter (Without New Attribute) || Maximo

There was a requirement of Month Parameter to be added on report runtime. The Month was already handled in the report query but we need standalone lookup just for month selection. But Maximo didn't allowed standalone lookup without linking attribute to the parameter. 

So we ended up with the below solution to add add Standalone Lookup Using Relationship - Birt Report Parameter (Without New Attribute).

Steps:

• Add new ALN Domain with Month Values e.g. JAN, FEB, MAR....

• Add following new Lookup changes in LOOKUPS.XML file with where clause = "DOMAINID = 'ZZMONTH' "

Extract First or Last Date of the Week | Date functions in DAX | Power BI

 Extract the First Day of this Week

1. Go to DATA, Add new columns, 

Get Current Date Time

= TODAY()                        // current datetime

Get Current Day, Month, MonthName, Quarter, Year etc

= TODAY() // current datetime

= mytable[datecolumn].[Quarter]

= mytable[datecolumn].[Day]

= mytable[datecolumn].[Month]

= mytable[datecolumn].[Year]

Format a date using formula

todayname = format(today(),"dddd")            //format to extract the Name of the date.

Get a Week Number of a Date

weekDay= WEEKDAY(TODAY()) //return the day number, it can take 1,2,3 as parameter to start the count from saturday, sunday or monday.

Get the First Day of the Week

firstDayofThisWeek = today() - WEEKDAY(TODAY()) +1 //today - number of day +1

Get the Last Day of the Week

lastDayofThisWeek = today() - WEEKDAY(TODAY()) +7 //today - number of day +7

Get the First Day of the Month

firstDayofThisMonth = STARTOFMONTH(TODAY()) //START OF MONTH

Get the Last Day of the Month

lastDayofThisMonth = ENDOFMONTH(TODAY()) //END OF MONTH

Populate a table/column with dates in a range

ourdates = calendar(date(2022,01,01) , date(2022-01-31) ) //first and last day as parameter

Delete Outbound Error Messages from Message Reprocessing Application | IBM Maximo

Deleting error messages requires two actions. 

First the DELETEFLAG must be set to 1, then the status changed to RETRY. 

Both of these are done transparently when deleting a message in the Message Reprocessing application. In an escalation they must be done in the correct order.

Warning: Be very careful when using this escalation to delete held messages. If valid transactions are sent in while this escalation is active, and they fail due to a correctable error, they can be deleted.

In the Escalations application, create a new escalation.

Applies To: MAXINTERROR

Condition: status=status='HOLD' and queuename = 'jms/maximo/int/queues/sqout'

Add an escalation point and check the Repeat box.

Add an action. Use the lookup arrow to Go To the Actions app to create the Action.

Create a new Action with the following values:

Object: MAXINTERROR

Type: Set Value

Value: 1

Parameter/Attribute: DELETEFLAG

Save and Return with Value to the Escalations application.