Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.

Long Descriptions in Communication template

From: Pat Morrow (2013-10-15 15:53)

Create a relationship to the longdescription table from the application.
Reference the relationshipname and the field name
For example, I send the following information by email.
Priority :WOPRIORITY
Work Order :wonum
Description :description
Additional information :long.ldtext
Location :location
Asset (if applicable) :assetnum
Asset Description (if applicable) :asset.description
GL Account :glaccount
:WORKTYPE.wtypedesc (:worktype)
Whenever a high priority WO comes in from a certain area. :long.ldtext is the longdescription from the referenced workorder. The relationship is on the workorder table and had the name long. The child object is longdescription and the where clause is
ldownertable = 'WORKORDER' and ldownercol = 'DESCRIPTION' and ldkey = :workorderid
It takes about two minutes to set up and does not require a dbconfig.

Pat Morrow
pmorrow8@yahoo.com
On Tuesday, October 15, 2013 2:07 PM, Chris Lawless <lawlessc@gmail.com> wrote:

Have you tried :WORKORDER_LONGDESCRIPTION or equivalent?
On Oct 15, 2013, at 3:56 PM, Jagan Rajan <lensman511@yahoo.com> wrote:

>Hi all,
>can anyone help to add long description to communication table. we are using work flow to send an email out when a work is complete and add the log to the email. Any help is appreciated.
>thanks
>Jagan

From: Incomm Solutions Inc. (2013-10-17 07:53)

Try using :DESCRIPTION_LONGDESCRIPTION – I’ve used that syntax before and it works.

Shannon Rotz

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Pat Morrow
Sent: October-15-13 4:53 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Long Descriptions in Communication template

Create a relationship to the longdescription table from the application.
Reference the relationshipname and the field name

For example, I send the following information by email.

Priority :WOPRIORITY
Work Order :wonum
Description :description
Additional information :long.ldtext
Location :location
Asset (if applicable) :assetnum
Asset Description (if applicable) :asset.description
GL Account :glaccount
:WORKTYPE.wtypedesc (:worktype)

Whenever a high priority WO comes in from a certain area. :long.ldtext is the longdescription from the referenced workorder. The relationship is on the workorder table and had the name long. The child object is longdescription and the where clause is

ldownertable = 'WORKORDER' and ldownercol = 'DESCRIPTION' and ldkey = :workorderid

It takes about two minutes to set up and does not require a dbconfig.

Pat Morrow
pmorrow8@yahoo.com

On Tuesday, October 15, 2013 2:07 PM, Chris Lawless <lawlessc@gmail.com> wrote:

Have you tried :WORKORDER_LONGDESCRIPTION or equivalent?
On Oct 15, 2013, at 3:56 PM, Jagan Rajan <lensman511@yahoo.com> wrote:

Hi all,
can anyone help to add long description to communication table. we are using work flow to send an email out when a workhttp://geo.yahoo.com/serv?s=97359714/grpId=381828/grpspId=1705007389/msgId=59408/stime=1381808611 is complete and add the log to the email. Any help is appreciated.
thanks
Jagan

From: kermitlong (2013-10-17 15:50)

I am using the :DESCRIPTION_LONGDESCRIPTION Also...
What about getting the last memo into a Communication Template?
-ken
--- In MAXIMO@yahoogroups.com, "Incomm Solutions Inc." <shannonrotz@...> wrote:
>
> Try using :DESCRIPTION_LONGDESCRIPTION â" Iâve used that syntax before and it works.
>
>
>
>
>
>
>
> Shannon Rotz
>
>
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Pat Morrow
> Sent: October-15-13 4:53 PM
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Long Descriptions in Communication template
>
>
>
>
>
> Create a relationship to the longdescription table from the application.
>
> Reference the relationshipname and the field name
>
>
>
> For example, I send the following information by email.
>
>
>
> Priority :WOPRIORITY
>
> Work Order :wonum
>
> Description :description
>
> Additional information :long.ldtext
>
> Location :location
>
> Asset (if applicable) :assetnum
>
> Asset Description (if applicable) :asset.description
>
> GL Account :glaccount
>
> :WORKTYPE.wtypedesc (:worktype)
>
>
>
> Whenever a high priority WO comes in from a certain area. :long.ldtext is the longdescription from the referenced workorder. The relationship is on the workorder table and had the name long. The child object is longdescription and the where clause is
>
>
>
> ldownertable = 'WORKORDER' and ldownercol = 'DESCRIPTION' and ldkey = :workorderid
>
>
>
> It takes about two minutes to set up and does not require a dbconfig.
>
>
>
>
>
> Pat Morrow
> pmorrow8@...
>
>
>
> On Tuesday, October 15, 2013 2:07 PM, Chris Lawless <lawlessc@...> wrote:
>
>
>
> Have you tried :WORKORDER_LONGDESCRIPTION or equivalent?
>
>
> On Oct 15, 2013, at 3:56 PM, Jagan Rajan <lensman511@...> wrote:
>
>
>
> Hi all,
>
> can anyone help to add long description to communication table. we are using work flow to send an email out when a workhttp://geo.yahoo.com/serv?s=97359714/grpId=381828/grpspId=1705007389/msgId=59408/stime=1381808611 is complete and add the log to the email. Any help is appreciated.
>
> thanks
>
> Jagan
>
>
>
>
>
>
>
>
>

From: (2013-10-18 19:04)

What issue you are facing in that? I believe you are on M 7.5. Select LDTEXT column from longdescription table using relationship between worklog and longdescription table in comm template and since Maximo 7.5 supports RTF, you should get worklog column.

---In MAXIMO@yahoogroups.com, <maximo@yahoogroups.com> wrote:

Hi all,
can anyone help to add long description to communication table. we are using work flow to send an email out when a work is complete and add the log to the email. Any help is appreciated.
thanks
Jagan

From: Incomm Solutions Inc. (2013-10-19 10:29)

I think that’s just :LASTMEMO …

Shannon

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of kermitlong
Sent: October-17-13 8:50 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Long Descriptions in Communication template

I am using the :DESCRIPTION_LONGDESCRIPTION Also...
What about getting the last memo into a Communication Template?
-ken
--- In MAXIMO@yahoogroups.com, "Incomm Solutions Inc." <shannonrotz@...> wrote:
>
> Try using :DESCRIPTION_LONGDESCRIPTION â€" Iâ€™ve used that syntax before and it works.
>
>
>
>
>
>
>
> Shannon Rotz
>
>
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Pat Morrow
> Sent: October-15-13 4:53 PM
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Long Descriptions in Communication template
>
>
>
>
>
> Create a relationship to the longdescription table from the application.
>
> Reference the relationshipname and the field name
>
>
>
> For example, I send the following information by email.
>
>
>
> Priority :WOPRIORITY
>
> Work Order :wonum
>
> Description :description
>
> Additional information :long.ldtext
>
> Location :location
>
> Asset (if applicable) :assetnum
>
> Asset Description (if applicable) :asset.description
>
> GL Account :glaccount
>
> :WORKTYPE.wtypedesc (:worktype)
>
>
>
> Whenever a high priority WO comes in from a certain area. :long.ldtext is the longdescription from the referenced workorder. The relationship is on the workorder table and had the name long. The child object is longdescription and the where clause is
>
>
>
> ldownertable = 'WORKORDER' and ldownercol = 'DESCRIPTION' and ldkey = :workorderid
>
>
>
> It takes about two minutes to set up and does not require a dbconfig.
>
>
>
>
>
> Pat Morrow
> pmorrow8@...
>
>
>
> On Tuesday, October 15, 2013 2:07 PM, Chris Lawless <lawlessc@...> wrote:
>
>
>
> Have you tried :WORKORDER_LONGDESCRIPTION or equivalent?
>
>
> On Oct 15, 2013, at 3:56 PM, Jagan Rajan <lensman511@...> wrote:
>
>
>
> Hi all,
>
> can anyone help to add long description to communication table. we are using work flow to send an email out when a workhttp://geo.yahoo.com/serv?s=97359714/grpId=381828/grpspId=1705007389/msgId=59408/stime=1381808611 is complete and add the log to the email. Any help is appreciated.
>
> thanks
>
> Jagan
>
>
>
>
>
>
>
>
>