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.
Hi All,
Wondering if anyone has figured out a work around for this issue. Maximo 7.5 - We want to send an email from Maximo with a list of values. Example, we want to send an email from workflow to the lead person of a work order. In that email we want to list all of the tasks for that work order. In the communication template I can select the WOACTIVITY object but only the first task will come in the email.
Thanks!
Glen VanDenBerg
Business Analyst
HermanMiller
I have used data from specifications in an e-mail template.
Here's an example:
:WORKORDERSPEC[0].alnvalue the list if a zero based list, so start with 0.
Haven't figured out a way to limit based on the number of specifications;
however, this was for a specific notification so it works for us.
On Tue, Jan 7, 2014 at 9:51 AM, Glen Vandenberg <
glen_vandenberg@hermanmiller.com> wrote:
>
>
> Hi All,
>
> Wondering if anyone has figured out a work around for this
> issue. Maximo 7.5 - We want to send an email from Maximo with a list of
> values. Example, we want to send an email from workflow to the lead person
> of a work order. In that email we want to list all of the tasks for that
> work order. In the communication template I can select the WOACTIVITY
> object but only the first task will come in the email.
>
>
>
>
>
>
>
>
>
> Thanks!
>
> *Glen VanDenBerg*
>
> Business Analyst
>
> *HermanMiller*
>
>
>
>
>
--
In a country well governed, poverty is something to be ashamed of.
In a country badly governed, wealth is something to be ashamed of.
Confucius
There really is no "official" way but there are a few options. The most
legitimate way in my opinion would be to use a tool such as dbNews instead
of communication templates, you can iterate through multiple records,
create tables, spreadsheet etc. If you want to do this purely within Maximo
there are two approaches I have used before but both are kind of kludgy.
The first is to create a view that calls a function that basically builds
your email body - then you include the "body" field in your template. The
second is to build the communication template completely using an
automation sctipt and iterating through your target records.
Chris.
On Tue, Jan 7, 2014 at 10:51 AM, Glen Vandenberg <
glen_vandenberg@hermanmiller.com> wrote:
>
>
> Hi All,
>
> Wondering if anyone has figured out a work around for this
> issue. Maximo 7.5 - We want to send an email from Maximo with a list of
> values. Example, we want to send an email from workflow to the lead person
> of a work order. In that email we want to list all of the tasks for that
> work order. In the communication template I can select the WOACTIVITY
> object but only the first task will come in the email.
>
>
>
>
>
>
>
>
>
> Thanks!
>
> *Glen VanDenBerg*
>
> Business Analyst
>
> *HermanMiller*
>
>
>
>
>
In Oracle, I've used the listagg function to display multiple rows into one row with a delimiter. Maybe the delimiter in your case could be a new line.
http://www.dba-oracle.com/t_display_multiple_column_values_same_rows.htm
SQL:Server can use XML PATH: http://stackoverflow.com/questions/15477743/listagg-in-sqlserver
Thank You! This works with some degree of success. The problem we run into with this solution is that the number of rows returned in the communication are not static.
Thanks!
Glen VanDenBerg
Business Analyst
hermanmiller.com<http://www.hermanmiller.com/>
616 654 3527
HermanMiller
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Paul E. Miller, Jr.
Sent: Tuesday, January 07, 2014 12:14 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Multiple rows of data in Maximo communication templates
I have used data from specifications in an e-mail template.
Here's an example:
:WORKORDERSPEC[0].alnvalue the list if a zero based list, so start with 0.
Haven't figured out a way to limit based on the number of specifications; however, this was for a specific notification so it works for us.
On Tue, Jan 7, 2014 at 9:51 AM, Glen Vandenberg <glen_vandenberg@hermanmiller.com<mailto:glen_vandenberg@hermanmiller.com>> wrote:
Hi All,
Wondering if anyone has figured out a work around for this issue. Maximo 7.5 - We want to send an email from Maximo with a list of values. Example, we want to send an email from workflow to the lead person of a work order. In that email we want to list all of the tasks for that work order. In the communication template I can select the WOACTIVITY object but only the first task will come in the email.
Thanks!
Glen VanDenBerg
Business Analyst
HermanMiller
--
In a country well governed, poverty is something to be ashamed of.
In a country badly governed, wealth is something to be ashamed of.
Confucius
Thanks for the response! We've looked into the dbNews option in the past but don't really want to integrate a third-party solution if we don't have to. We're looking into the feasibility of the view and auto script options.
Thanks!
Glen VanDenBerg
Business Analyst
hermanmiller.com<http://www.hermanmiller.com/>
616 654 3527
HermanMiller
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless
Sent: Tuesday, January 07, 2014 12:35 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Multiple rows of data in Maximo communication templates
There really is no "official" way but there are a few options. The most legitimate way in my opinion would be to use a tool such as dbNews instead of communication templates, you can iterate through multiple records, create tables, spreadsheet etc. If you want to do this purely within Maximo there are two approaches I have used before but both are kind of kludgy. The first is to create a view that calls a function that basically builds your email body - then you include the "body" field in your template. The second is to build the communication template completely using an automation sctipt and iterating through your target records.
Chris.
On Tue, Jan 7, 2014 at 10:51 AM, Glen Vandenberg <glen_vandenberg@hermanmiller.com<mailto:glen_vandenberg@hermanmiller.com>> wrote:
Hi All,
Wondering if anyone has figured out a work around for this issue. Maximo 7.5 - We want to send an email from Maximo with a list of values. Example, we want to send an email from workflow to the lead person of a work order. In that email we want to list all of the tasks for that work order. In the communication template I can select the WOACTIVITY object but only the first task will come in the email.
Thanks!
Glen VanDenBerg
Business Analyst
HermanMiller