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.
I want to add a lookup to the field locations.changeby so that from Advanced Search you can choose a person from a list. And I thought you would be able to do this without a table domain. Where did I go wrong?
I found the lookup I wanted to use in the lookups.xml and applied that to the new textbox in the locations searchmore dialogue. Then add into the maxlookup:
Insert into maxlookupmap values('LOCATIONS','CHANGEBY','CHANGEBY','PERSONID',1,1,maxlookupmapseq.nextval,'PERSON',1);
But after restarting Maximo I got the invalid binding error.
I added a table domain to the field and it worked perfectly but do I really need it or should it work just with the maxlookup mapping?
Maximo 6.2.1 and Oracle.
Yes the domain attachment is required. Think of the domain as defining "what data do I want to see and validate against this field". The Maxlookupmap allows for you to map what fields from the lookup should come back and populate the field. The lookup itself is just presenting the data available in the domain.
Hope that helps.
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of my_maximo
Sent: Monday, August 27, 2012 1:57 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Adding a lookup to an existing field in advanced search
I want to add a lookup to the field locations.changeby so that from Advanced Search you can choose a person from a list. And I thought you would be able to do this without a table domain. Where did I go wrong?
I found the lookup I wanted to use in the lookups.xml and applied that to the new textbox in the locations searchmore dialogue. Then add into the maxlookup:
Insert into maxlookupmap values('LOCATIONS','CHANGEBY','CHANGEBY','PERSONID',1,1,maxlookupmapseq.nextval,'PERSON',1);
But after restarting Maximo I got the invalid binding error.
I added a table domain to the field and it worked perfectly but do I really need it or should it work just with the maxlookup mapping?
Maximo 6.2.1 and Oracle.