Maximo Open Forum

Hi,

Does anyone know of a way to place the system date or current date into the subject line of a recurring report?

Example: Daily PM Work Order Generation Report - 3/15/24

I've tried :&DATE: and :DATE and :SYSDATE with no luck.

Hi,

Does anyone know of a way to place the system date or current date into the subject line of a recurring report?

Example: Daily PM Work Order Generation Report - 3/15/24

I've tried :&DATE: and :DATE and :SYSDATE with no luck.

Hi Stevie - I hope you are doing well!

I think that I would try the following, which should provide you the standard bind functionality that you are looking for in your Scheduled Report (for both Subject and Message) using :&DATE&, as an example:

from psdi.mbo import SqlFormatdef getResolvedField(m, field):        sqlf = SqlFormat(m, m.getString(field))    sqlf.setIgnoreUnresolved(True)    return sqlf.resolveContent()def main():        if interactive:        return        mbo.setValue("EMAILSUBJECT",  getResolvedField(mbo, "EMAILSUBJECT"))    mbo.setValue("EMAILCOMMENTS", getResolvedField(mbo, "EMAILCOMMENTS"))    main()

I created this with an Object Launch Point, on Initialize Value against the REPORTSCHED Object.

Good luck!

Hi,

Does anyone know of a way to place the system date or current date into the subject line of a recurring report?

Example: Daily PM Work Order Generation Report - 3/15/24

I've tried :&DATE: and :DATE and :SYSDATE with no luck.

Hi Aaron,

I'm doing well. Thank you. How are you?

I try this out and report the result. Is this Jython or Python?

Hi Stevie - I hope you are doing well!

I think that I would try the following, which should provide you the standard bind functionality that you are looking for in your Scheduled Report (for both Subject and Message) using :&DATE&, as an example:

from psdi.mbo import SqlFormatdef getResolvedField(m, field):        sqlf = SqlFormat(m, m.getString(field))    sqlf.setIgnoreUnresolved(True)    return sqlf.resolveContent()def main():        if interactive:        return        mbo.setValue("EMAILSUBJECT",  getResolvedField(mbo, "EMAILSUBJECT"))    mbo.setValue("EMAILCOMMENTS", getResolvedField(mbo, "EMAILCOMMENTS"))    main()

I created this with an Object Launch Point, on Initialize Value against the REPORTSCHED Object.

Good luck!

Hi,

Does anyone know of a way to place the system date or current date into the subject line of a recurring report?

Example: Daily PM Work Order Generation Report - 3/15/24

I've tried :&DATE: and :DATE and :SYSDATE with no luck.