Assignment Manager Queries

Hi all.
My name is Wayne.

I am an electrician using Maximo 8.1.

Need a little help if you can.

We are just now starting to implement and use Assignment Manager, and you have to create unique queries for that application. I.e. you can't just import your Work Order queries.
So I am trying to do this. I know very little about SQL, but normally with my Work Order queries, I could use Advanced Search, enter some parameters, and then open up the where clause and back-figure how to make a query that I want to make.

And I have done that a little with Assignment Manager.
So far these are the two queries I have made.

PM Query:
WHERE (status != 'CAN,!=CLOSE,!=COMP,!=RDYCOMP' and historyflag = 0 and siteid = 'BT' and assignstatus = 'WAITASGN' and worktype = 'PM')

And CM Query:
WHERE (status != 'CAN,!=CLOSE,!=COMP,!=RDYCOMP' and historyflag = 0 and siteid = 'BT' and assignstatus = 'WAITASGN' and worktype = 'CM')

But what I'd like to be able to do is add a field to that query that is not on the Advanced Search. The "Craft" field.
We have 4 crafts. Mech, Tech, Cont Labor & OT.
I'ld like to be able to incorporate that field into my queries, but when I try to add it to the clause, it gives me this error.

For this query:
WHERE (status != 'CAN,!=CLOSE,!=COMP,!=RDYCOMP'
and historyflag = 0
and siteid = 'BT'
and assignstatus = 'WAITASGN'
and worktype = 'CM')
and (1=1 and craft= 'TECH')

I get this error:
system#invalidcharqry

And I am not even sure what the "1=1" is for. It just pops up with the Craft = TECH when I search for it using the "Filter Work to Match Labor" button, so I assumed it needed to be there.

Can anyone tell me why I am getting this error, and help me with correcting my query?

Thanks so much in advance.

edit: Correction, I believe I actually have version 6.2 of Maximo.

Recent