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.
Have you had any luck? How about trying a relationship similar to this?
:assetnum in (select assetnum from maximo.asset where cdu1 = :assetnum or cdu2 = :assetnum)
--- In MAXIMO@yahoogroups.com, "hankinskeith@..." <keith.d.hankins@...> wrote:
>
> Can anyone assist?
>
> I need the ability to create multiple relationships between assets in Maximo. For example, a server will have a Rack as a PARENT (no problem) but will also need to have a relationship to two CDU's (a primary and a secondary) both of which are assets in Maximo.
>
> I've created the attributes ASSET.CDU1 and ASSET.CDU2. The lookup for these attributes will be a Table Domain which I created and associated to the attributes in database config.
>
> In the application, I added VALUELIST to the lookup field. All working.
>
> I also created a relationship in the ASSET table to each attribute. (I'll just show one below)
> CHILDOBJECT = ASSET
> WHERECLAUSE = assetnum = :cdu1 and siteid = :siteid
>
> In my application, the lookup is working but when I select a record I get this error message...
>
> "You have encountered an implementation or customization problem. Please contact your system administrator to report this error. The system does not know which attribute(s) of the current object are the foreign key(s) to object ASSET. This information should be provided in MAXLOOKUPMAP table or in the field validation class of CDU1."
>
> So... I went to the MAXLOOKUP table and added the following:
> ALLOWNULL = '1' LOOKUPATTRIBUTE = 'ASSETNUM' MAXLOOKUPMAPID = '901' SEQNUM = '1' SOURCE = 'ASSET' SOURCEKEY = 'ASSETNUM' TARGET = 'ASSET' TARGETATT = 'CDU1'
>
> but still get the same error...
>
> Can anyone tell me what I'm doing wrong? Thanks in advance!
> Keith
>
We had to create another table, we used assetmaster, and linked a tabledomain to that in dbconfig. Took some work. I'll try to get the details on this and pass it back to everyone here, but it wasn't just a simple bam bam fix. Took a couple hours to configure.
Chad J. Stringer
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of albutlerbcf
Sent: Monday, June 27, 2011 11:08 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: HELP! Need to create relationship assetnum to assetnum - MAXLOOKUPMAP / Class
Have you had any luck? How about trying a relationship similar to this?
:assetnum in (select assetnum from maximo.asset where cdu1 = :assetnum or cdu2 = :assetnum)
--- In MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>, "hankinskeith@..." <keith.d.hankins@...> wrote:
>
> Can anyone assist?
>
> I need the ability to create multiple relationships between assets in Maximo. For example, a server will have a Rack as a PARENT (no problem) but will also need to have a relationship to two CDU's (a primary and a secondary) both of which are assets in Maximo.
>
> I've created the attributes ASSET.CDU1 and ASSET.CDU2. The lookup for these attributes will be a Table Domain which I created and associated to the attributes in database config.
>
> In the application, I added VALUELIST to the lookup field. All working.
>
> I also created a relationship in the ASSET table to each attribute. (I'll just show one below)
> CHILDOBJECT = ASSET
> WHERECLAUSE = assetnum = :cdu1 and siteid = :siteid
>
> In my application, the lookup is working but when I select a record I get this error message...
>
> "You have encountered an implementation or customization problem. Please contact your system administrator to report this error. The system does not know which attribute(s) of the current object are the foreign key(s) to object ASSET. This information should be provided in MAXLOOKUPMAP table or in the field validation class of CDU1."
>
> So... I went to the MAXLOOKUP table and added the following:
> ALLOWNULL = '1' LOOKUPATTRIBUTE = 'ASSETNUM' MAXLOOKUPMAPID = '901' SEQNUM = '1' SOURCE = 'ASSET' SOURCEKEY = 'ASSETNUM' TARGET = 'ASSET' TARGETATT = 'CDU1'
>
> but still get the same error...
>
> Can anyone tell me what I'm doing wrong? Thanks in advance!
> Keith
>