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.
Hello
I am writing to see if someone could assist me with writing a query. I am currently utilizing Maximo 5.2 right now and we will be looking to upgrade to 7.5 over the next year but in the meantime I am having trouble with a report that I have and on the report the team is unassigned because I believe my administrator never assigned the work orders to a particular team on the work order in Maximo. So, we cannot figure out what work orders that the team/craft section is blank. Could someone assist me with writing a query that will pull up all the work orders where the team/craft section in blank? These are PM work orders!
Please let me know if you have any questions.
Thanks for your assistance
Best
Joe
Joe Rooney
Maintenance Systems Manager
Massachusetts Convention Center Authority
415 Summer Street, Boston MA 02210
Tel. 617-954-2465
massconvention.com<http://massconvention.com>
Joe: Go into the Work Order Tracking module and do your search with the Advanced Search tool with the required Asset or Location fields populated. This should bring up all work orders with or without the Team or Craft info. Export the result set to MS Excel and then filter out the one you need with the MS xls filter tool.
Dave Craigen
Maintenance Planner
Cenovus Energy Inc
Oil & Natural Gas Saskatchewan
Desk: 306-848-6169
Cell: 306-861-7299
david.craigen@cenovus.com
Cenovus offices are closed on the 1st and 3rd Friday each month.
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Rooney, Joe
Sent: Wednesday, December 04, 2013 2:08 PM
To: 'MAXIMO@yahoogroups.com'
Subject: [MAXIMO List] Query Assistance
Hello
I am writing to see if someone could assist me with writing a query. I am currently utilizing Maximo 5.2 right now and we will be looking to upgrade to 7.5 over the next year but in the meantime I am having trouble with a report that I have and on the report the team is unassigned because I believe my administrator never assigned the work orders to a particular team on the work order in Maximo. So, we cannot figure out what work orders that the team/craft section is blank. Could someone assist me with writing a query that will pull up all the work orders where the team/craft section in blank? These are PM work orders!
Please let me know if you have any questions.
Thanks for your assistance
Best
Joe
Joe Rooney
Maintenance Systems Manager
Massachusetts Convention Center Authority
415 Summer Street, Boston MA 02210
Tel. 617-954-2465
massconvention.com<http://massconvention.com>
This email communication and any files transmitted with it may contain
confidential and or proprietary information and is provided for the use of the
intended recipient only. Any review, retransmission or dissemination of this
information by anyone other than the intended recipient is prohibited. If you
receive this email in error, please contact the sender and delete this
communication and any copies immediately. Thank you.
http://www.cenovus.com
Select * from workorder
where pmnum is not null
and xxxx is null
and yyyy is null
Change xxxx and yyyy to whatever the name of the field(s) are that you are trying to search on.
If you are doing it from the front end, put everything after the word 'where' in the workorder query.
Pat Morrow
pmorrow8@yahoo.com
On Wednesday, December 4, 2013 1:19 PM, "Craigen, David A." <david.craigen@cenovus.com> wrote:
Joe: Go into the Work Order Tracking module and do your search with the Advanced Search tool with the required Asset or Location fields populated. This should bring up all work orders with or without the Team or Craft info. Export the result set to MS Excel and then filter out the one you need with the MS xls filter tool.
Dave Craigen
Maintenance Planner
Cenovus Energy Inc
Oil & Natural Gas Saskatchewan
Desk: 306-848-6169
Cell: 306-861-7299
david.craigen@cenovus.com
Cenovus offices are closed on the 1st and 3rd Friday each month.
From:MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Rooney, Joe
Sent: Wednesday, December 04, 2013 2:08 PM
To: 'MAXIMO@yahoogroups.com'
Subject: [MAXIMO List] Query Assistance
Hello
I am writing to see if someone could assist me with writing a query. I am currently utilizing Maximo 5.2 right now and we will be looking to upgrade to 7.5 over the next year but in the meantime I am having trouble with a report that I have and on the report the team is unassigned because I believe my administrator never assigned the work orders to a particular team on the work order in Maximo. So, we cannot figure out what work orders that the team/craft section is blank. Could someone assist me with writing a query that will pull up all the work orders where the team/craft section in blank? These are PM work orders!
Please let me know if you have any questions.
Thanks for your assistance
Best
Joe
JoeRooney
Maintenance Systems Manager
Massachusetts Convention Center Authority
415 Summer Street, Boston MA 02210
Tel. 617-954-2465
massconvention.com
This email communication and any files transmitted with it may contain confidential and or proprietary information and is provided for the use of the intended recipient only. Any review, retransmission or dissemination of this information by anyone other than the intended recipient is prohibited. If you receive this email in error, please contact the sender and delete this communication and any copies immediately. Thank you. http://www.cenovus.com
In 7.5 You can use ~null~ to find records with missing values. If you have access to search on team/craft within the application give it a try. Let us know if that syntax works in 5.2. If not, use Dave's advice or get your DBA to run a query for you.
John
> On Dec 4, 2013, at 2:19 PM, "Craigen, David A." <david.craigen@cenovus.com> wrote:
>
> Joe: Go into the Work Order Tracking module and do your search with the Advanced Search tool with the required Asset or Location fields populated. This should bring up all work orders with or without the Team or Craft info. Export the result set to MS Excel and then filter out the one you need with the MS xls filter tool.
>
>
>
> Dave Craigen
>
> Maintenance Planner
>
> Cenovus Energy Inc
>
> Oil & Natural Gas Saskatchewan
>
> Desk: 306-848-6169
>
> Cell: 306-861-7299
>
> david.craigen@cenovus.com
>
>
>
> Cenovus offices are closed on the 1st and 3rd Friday each month.
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Rooney, Joe
> Sent: Wednesday, December 04, 2013 2:08 PM
> To: 'MAXIMO@yahoogroups.com'
> Subject: [MAXIMO List] Query Assistance
>
>
>
>
>
> Hello
>
>
>
> I am writing to see if someone could assist me with writing a query. I am currently utilizing Maximo 5.2 right now and we will be looking to upgrade to 7.5 over the next year but in the meantime I am having trouble with a report that I have and on the report the team is unassigned because I believe my administrator never assigned the work orders to a particular team on the work order in Maximo. So, we cannot figure out what work orders that the team/craft section is blank. Could someone assist me with writing a query that will pull up all the work orders where the team/craft section in blank? These are PM work orders!
>
>
>
> Please let me know if you have any questions.
>
>
>
> Thanks for your assistance
>
>
>
> Best
>
> Joe
>
>
>
> Joe Rooney
>
> Maintenance Systems Manager
>
>
>
> Massachusetts Convention Center Authority
>
> 415 Summer Street, Boston MA 02210
>
> Tel. 617-954-2465
>
> massconvention.com
>
>
>
>
>
> This email communication and any files transmitted with it may contain
>
> confidential and or proprietary information and is provided for the use of the
>
> intended recipient only. Any review, retransmission or dissemination of this
>
> information by anyone other than the intended recipient is prohibited. If you
>
> receive this email in error, please contact the sender and delete this
>
> communication and any copies immediately. Thank you.
>
> http://www.cenovus.com
>