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.
Dear all,
Again another question about Max 75 customapp, I have created 7 custapps
and none of them can directly find in search page. It always pointing to
unique column, let say: object SIMULATION has SIMULATIONID as a unique
column and i want to set REQNUM as primary key. But the problem is, if i
find directly (from the find text box), Maximo populates based on
SIMULATIONID not REQNUM.
Is there any missing setting on both dbdesigner or appdesigner or custom
class?
Many thanks & Best Regards,
Yudi Irianto
I'm going from memory here - as do not have a copy of the app in front of me, and it was developed more than 2 years ago. Lots of code and customization since then.
1. Add a unique index on the field(s) that will be used in your app for querying (reqnum and maybe siteid?)
2. Go to dbconfig and change the primary key from simulationid (will likely have a 1 in the field - change it to a null) to reqnum. This is easier to do if you do it from the database side. Update the maxattributecfg and the maxattribute tables if you do if from the database. If you are able to do it from the front end, then then need to run configdb before this will work.
This should now be able to be accessed.
For examples - take a look at po (ponum and siteid should be the primary key columns) and at poline (polineid should be the primary key column). Model your custom apps on po (or workorder) or any application that does not use the uid as the primary key.
I might be missing a step - might need to add something into maxlookupmap or lookups.xml.
I hope this gives you some hints to work on you applications.
Pat Morrow
pmorrow8@yahoo.com
________________________________
From: "yudi.irianto@ytljt.com" <yudi.irianto@ytljt.com>
To: MAXIMO@yahoogroups.com
Sent: Monday, January 23, 2012 8:59 PM
Subject: [MAXIMO List] Cannot find record in Max75 custom app
Dear all,
Again another question about Max 75 customapp, I have created 7 custapps
and none of them can directly find in search page. It always pointing to
unique column, let say: object SIMULATION has SIMULATIONID as a unique
column and i want to set REQNUM as primary key. But the problem is, if i
find directly (from the find text box), Maximo populates based on
SIMULATIONID not REQNUM.
Is there any missing setting on both dbdesigner or appdesigner or custom
class?
Many thanks & Best Regards,
Yudi Irianto
Hi Pat Morrow,
The problem is, once i created a new object than maximo will set unique
column = OBJECT+ID.
Let say:
objectname = SIMULATION
uniquecolumn = SIMULATIONID
By Default, attribute SIMULATIONID will set PRIMARYCOLUMN = 1
After dbconf, than all fields become readonly and cannot change.
For temporary solving, backdoor table maxattribute & maxattributecfg and
it works
Best Regards,
Yudi Irianto
Pat Morrow <pmorrow8@yahoo.com>
Sent by: MAXIMO@yahoogroups.com
24-01-2012 09:43
Please respond to
MAXIMO@yahoogroups.com
To
"MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
cc
Subject
Re: [MAXIMO List] Cannot find record in Max75 custom app
I'm going from memory here - as do not have a copy of the app in front of
me, and it was developed more than 2 years ago. Lots of code and
customization since then.
1. Add a unique index on the field(s) that will be used in your app for
querying (reqnum and maybe siteid?)
2. Go to dbconfig and change the primary key from simulationid (will
likely have a 1 in the field - change it to a null) to reqnum. This is
easier to do if you do it from the database side. Update the
maxattributecfg and the maxattribute tables if you do if from the
database. If you are able to do it from the front end, then then need to
run configdb before this will work.
This should now be able to be accessed.
For examples - take a look at po (ponum and siteid should be the primary
key columns) and at poline (polineid should be the primary key column).
Model your custom apps on po (or workorder) or any application that does
not use the uid as the primary key.
I might be missing a step - might need to add something into maxlookupmap
or lookups.xml.
I hope this gives you some hints to work on you applications.
Pat Morrow
pmorrow8@yahoo.com
________________________________
From: "yudi.irianto@ytljt.com" <yudi.irianto@ytljt.com>
To: MAXIMO@yahoogroups.com
Sent: Monday, January 23, 2012 8:59 PM
Subject: [MAXIMO List] Cannot find record in Max75 custom app
Dear all,
Again another question about Max 75 customapp, I have created 7 custapps
and none of them can directly find in search page. It always pointing to
unique column, let say: object SIMULATION has SIMULATIONID as a unique
column and i want to set REQNUM as primary key. But the problem is, if i
find directly (from the find text box), Maximo populates based on
SIMULATIONID not REQNUM.
Is there any missing setting on both dbdesigner or appdesigner or custom
class?
Many thanks & Best Regards,
Yudi Irianto
You need to set the MAXATTRIBUTE.PRIMARYKEYCOLSEQ field for your new table to match the index that uses REQNUM. Take a look at the WORKORDER table as an example.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of yudi.irianto@ytljt.com
Sent: January-23-12 7:47 PM
To: MAXIMO@yahoogroups.com
Cc: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Cannot find record in Max75 custom app
Hi Pat Morrow,
The problem is, once i created a new object than maximo will set unique
column = OBJECT+ID.
Let say:
objectname = SIMULATION
uniquecolumn = SIMULATIONID
By Default, attribute SIMULATIONID will set PRIMARYCOLUMN = 1
After dbconf, than all fields become readonly and cannot change.
For temporary solving, backdoor table maxattribute & maxattributecfg and
it works
Best Regards,
Yudi Irianto
Pat Morrow <pmorrow8@yahoo.com <mailto:pmorrow8%40yahoo.com> >
Sent by: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
24-01-2012 09:43
Please respond to
MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
To
"MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> " <MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> >
cc
Subject
Re: [MAXIMO List] Cannot find record in Max75 custom app
I'm going from memory here - as do not have a copy of the app in front of
me, and it was developed more than 2 years ago. Lots of code and
customization since then.
1. Add a unique index on the field(s) that will be used in your app for
querying (reqnum and maybe siteid?)
2. Go to dbconfig and change the primary key from simulationid (will
likely have a 1 in the field - change it to a null) to reqnum. This is
easier to do if you do it from the database side. Update the
maxattributecfg and the maxattribute tables if you do if from the
database. If you are able to do it from the front end, then then need to
run configdb before this will work.
This should now be able to be accessed.
For examples - take a look at po (ponum and siteid should be the primary
key columns) and at poline (polineid should be the primary key column).
Model your custom apps on po (or workorder) or any application that does
not use the uid as the primary key.
I might be missing a step - might need to add something into maxlookupmap
or lookups.xml.
I hope this gives you some hints to work on you applications.
Pat Morrow
pmorrow8@yahoo.com <mailto:pmorrow8%40yahoo.com>
________________________________
From: "yudi.irianto@ytljt.com <mailto:yudi.irianto%40ytljt.com> " <yudi.irianto@ytljt.com <mailto:yudi.irianto%40ytljt.com> >
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Sent: Monday, January 23, 2012 8:59 PM
Subject: [MAXIMO List] Cannot find record in Max75 custom app
Dear all,
Again another question about Max 75 customapp, I have created 7 custapps
and none of them can directly find in search page. It always pointing to
unique column, let say: object SIMULATION has SIMULATIONID as a unique
column and i want to set REQNUM as primary key. But the problem is, if i
find directly (from the find text box), Maximo populates based on
SIMULATIONID not REQNUM.
Is there any missing setting on both dbdesigner or appdesigner or custom
class?
Many thanks & Best Regards,
Yudi Irianto
Hi Shannon,
Yes, ur right, it has been done yesterday after backdoor
maxattribute.primarycolseq & maxattributecfg.primarycolseq (while cannot
update primarycolseq from screen).
Best Regards,
Yudi Irianto
"Shannon Rotz" <shannonrotz@yahoo.ca>
Sent by: MAXIMO@yahoogroups.com
25-01-2012 00:10
Please respond to
MAXIMO@yahoogroups.com
To
<MAXIMO@yahoogroups.com>
cc
Subject
RE: [MAXIMO List] Cannot find record in Max75 custom app
You need to set the MAXATTRIBUTE.PRIMARYKEYCOLSEQ field for your new table
to match the index that uses REQNUM. Take a look at the WORKORDER table as
an example.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
yudi.irianto@ytljt.com
Sent: January-23-12 7:47 PM
To: MAXIMO@yahoogroups.com
Cc: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Cannot find record in Max75 custom app
Hi Pat Morrow,
The problem is, once i created a new object than maximo will set unique
column = OBJECT+ID.
Let say:
objectname = SIMULATION
uniquecolumn = SIMULATIONID
By Default, attribute SIMULATIONID will set PRIMARYCOLUMN = 1
After dbconf, than all fields become readonly and cannot change.
For temporary solving, backdoor table maxattribute & maxattributecfg and
it works
Best Regards,
Yudi Irianto
Pat Morrow <pmorrow8@yahoo.com <mailto:pmorrow8%40yahoo.com> >
Sent by: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
24-01-2012 09:43
Please respond to
MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
To
"MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> " <
MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> >
cc
Subject
Re: [MAXIMO List] Cannot find record in Max75 custom app
I'm going from memory here - as do not have a copy of the app in front of
me, and it was developed more than 2 years ago. Lots of code and
customization since then.
1. Add a unique index on the field(s) that will be used in your app for
querying (reqnum and maybe siteid?)
2. Go to dbconfig and change the primary key from simulationid (will
likely have a 1 in the field - change it to a null) to reqnum. This is
easier to do if you do it from the database side. Update the
maxattributecfg and the maxattribute tables if you do if from the
database. If you are able to do it from the front end, then then need to
run configdb before this will work.
This should now be able to be accessed.
For examples - take a look at po (ponum and siteid should be the primary
key columns) and at poline (polineid should be the primary key column).
Model your custom apps on po (or workorder) or any application that does
not use the uid as the primary key.
I might be missing a step - might need to add something into maxlookupmap
or lookups.xml.
I hope this gives you some hints to work on you applications.
Pat Morrow
pmorrow8@yahoo.com <mailto:pmorrow8%40yahoo.com>
________________________________
From: "yudi.irianto@ytljt.com <mailto:yudi.irianto%40ytljt.com> " <
yudi.irianto@ytljt.com <mailto:yudi.irianto%40ytljt.com> >
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Sent: Monday, January 23, 2012 8:59 PM
Subject: [MAXIMO List] Cannot find record in Max75 custom app
Dear all,
Again another question about Max 75 customapp, I have created 7 custapps
and none of them can directly find in search page. It always pointing to
unique column, let say: object SIMULATION has SIMULATIONID as a unique
column and i want to set REQNUM as primary key. But the problem is, if i
find directly (from the find text box), Maximo populates based on
SIMULATIONID not REQNUM.
Is there any missing setting on both dbdesigner or appdesigner or custom
class?
Many thanks & Best Regards,
Yudi Irianto