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.
Good Day Everyone,
I am attempting to create a couple SQL reports from the Maximo database.
We are running V4.1.1
I'm having trouble finding 2 columns.
On the Workorder / Quick reporting screen there is a field named "Remarks" and the is an additional field from there named "Long Description". Do any of you know which table these two fields live?
I thought about entering a string of tildes and then seeing if there is an sql querry I could run to find them. Is there a way to search all tables and columns in the entire database, and find a unique string?
Thanks in advance for you thoughts.
Glen
It has been a while since I used 4.1.1 but I'm pretty sure the remarks field is in the failureremarks table.
All long descriptions are in the longdesctiption table. ownertable = failureremarks and recordkey = wonum
V/R
Kevin
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of GlenR
Sent: Monday, January 21, 2013 9:30 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Hide and seek
Good Day Everyone,
I am attempting to create a couple SQL reports from the Maximo database.
We are running V4.1.1
I'm having trouble finding 2 columns.
On the Workorder / Quick reporting screen there is a field named "Remarks" and the is an additional field from there named "Long Description". Do any of you know which table these two fields live?
I thought about entering a string of tildes and then seeing if there is an sql querry I could run to find them. Is there a way to search all tables and columns in the entire database, and find a unique string?
Thanks in advance for you thoughts.
Glen
The table MAXSYSCOLUMNS contains all the meta data for all the columns in the application, so If you're looking for a field, this is a good place to start.
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Kevin Egolf
Sent: Monday, January 21, 2013 9:47 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Hide and seek
It has been a while since I used 4.1.1 but I'm pretty sure the remarks field is in the failureremarks table.
All long descriptions are in the longdesctiption table. ownertable = failureremarks and recordkey = wonum
V/R
Kevin
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of GlenR
Sent: Monday, January 21, 2013 9:30 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Hide and seek
Good Day Everyone,
I am attempting to create a couple SQL reports from the Maximo database.
We are running V4.1.1
I'm having trouble finding 2 columns.
On the Workorder / Quick reporting screen there is a field named "Remarks" and the is an additional field from there named "Long Description". Do any of you know which table these two fields live?
I thought about entering a string of tildes and then seeing if there is an sql querry I could run to find them. Is there a way to search all tables and columns in the entire database, and find a unique string?
Thanks in advance for you thoughts.
Glen
select * from maxsyscolscfg where tbname = 'WORKORDER' order by name;
select * from longdescription where ldownertable = 'WORKORDER' and ldownercol = 'DESCRIPTION'; -- the ldkey at this point will be the WoNum
Not sure what field you're using for "Remarks" unless it's the field on "Failure Reporting" tab - then it's the failureremark.description (FailureRemark table Description field <grin>) - press the F1 key and Maximo will (should) tell you what the table.field is for that field (and a short text on what the field is for (help))
We still support 4.1.1 if you guys ever need anything <smile>...
R/
Will
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Sean Clark-McCarthy
Sent: Tuesday, January 22, 2013 9:24 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Hide and seek
The table MAXSYSCOLUMNS contains all the meta data for all the columns in the application, so If you're looking for a field, this is a good place to start.
--- Sean Clark-McCarthy
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Kevin Egolf
Sent: Monday, January 21, 2013 9:47 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: RE: [MAXIMO List] Hide and seek
It has been a while since I used 4.1.1 but I'm pretty sure the remarks field is in the failureremarks table.
All long descriptions are in the longdesctiption table. ownertable = failureremarks and recordkey = wonum
V/R
Kevin
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of GlenR
Sent: Monday, January 21, 2013 9:30 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Hide and seek
Good Day Everyone,
I am attempting to create a couple SQL reports from the Maximo database.
We are running V4.1.1
I'm having trouble finding 2 columns.
On the Workorder / Quick reporting screen there is a field named "Remarks" and the is an additional field from there named "Long Description". Do any of you know which table these two fields live?
I thought about entering a string of tildes and then seeing if there is an sql querry I could run to find them. Is there a way to search all tables and columns in the entire database, and find a unique string?
Thanks in advance for you thoughts.
Glen