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
A quick question RE sending communication Emails when USERID does not equal PERSONID.
Create a relationship from the user table to the person table (likely already exists in the system).Create a role that references this relationship in the value field (i.e. :LEAD.PERSON.EMAIL.emailaddress)Use the role in the communication template.
Pat Morrow
pmorrow8@yahoo.com
From: "Michael Stringer michael.stringer@cdhb.health.nz [MAXIMO]" <MAXIMO@yahoogroups.com>
To: "'MAXIMO@yahoogroups.com'" <MAXIMO@yahoogroups.com>
Sent: Thursday, October 15, 2015 9:50 PM
Subject: [MAXIMO List] Email Messages When USERID Does not equal PersonID
Hi All
A quick question RE sending communication Emails when USERID does not equal PERSONID.
Hi Pat
Thank you for the response.
Your email pointed me in the right direction – in the end it was the relationship between ASSET and MAXUSER that I needed.
Seem to be in action now – thank you.
Mike
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Friday, 16 October 2015 5:56 p.m.
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Email Messages When USERID Does not equal PersonID
Create a relationship from the user table to the person table (likely already exists in the system).Create a role that references this relationship in the value field (i.e. :LEAD.PERSON.EMAIL.emailaddress)Use the role in the communication template.
Pat Morrow
pmorrow8@yahoo.com
From: "Michael Stringer michael.stringer@cdhb.health.nz [MAXIMO]" <MAXIMO@yahoogroups.com>
To: "'MAXIMO@yahoogroups.com'" <MAXIMO@yahoogroups.com>
Sent: Thursday, October 15, 2015 9:50 PM
Subject: [MAXIMO List] Email Messages When USERID Does not equal PersonID
Hi All
A quick question RE sending communication Emails when USERID does not equal PERSONID.
Hello Michael, I know your post is almost a year old now, but I am working on a similar escalation where I want to get a notification when anyone changes a Company record.
I am simply trying to key on the Changedate, but can't seem to get it to run.
I'm using the string COMPANIES.CHANGEDATE = GETDATE() and ORGID ='XXX'.
I am running on a sql server on v7.6.
Would you be able to share your Condition statement?
Thanks,
Randy
Hi Randy
I think you would be tripping up on using the = changedate. The as changedate includes the date and time.
I use a >= statement
The below example is detecting when the person entering an asset neglects to add a classification.
Here I am limiting the change date to after 26-07-2015 - so it does not send notifications for earlier data errors. Then I am also allowing a ¼ hour grace period to give the user the chance to correct the error without getting the message - if they are still working on the record.
((classstructureid is null) and changedate >= { ts '2015-07-26 12:30:00.000' } and changedate <= dateadd(hour, -0.25, getdate()))
Hopefully this gives you something to try.
Regards
Michael
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Friday, 2 September 2016 9:03 a.m.
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Email Messages When USERID Does not equal PersonID
Hello Michael, I know your post is almost a year old now, but I am working on a similar escalation where I want to get a notification when anyone changes a Company record.
I am simply trying to key on the Changedate, but can't seem to get it to run.
I'm using the string COMPANIES.CHANGEDATE = GETDATE() and ORGID ='XXX'.
I am running on a sql server on v7.6.
Would you be able to share your Condition statement?
Thanks,
Randy