Maximo Wire - The IBM Maximo Help & Discussion Forum
May 23, 2012, 10:48:31 pm *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome to Maximo Wire, the IBM Maximo help forum. Feel free to register and ask any Maximo related questions you like.
 
  Home Help Search Login Register  
*
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Job Plan Task Description Text Query  (Read 632 times)
0 Members and 1 Guest are viewing this topic.
mikel
Newbie
*

Karma: 0
Posts: 2


View Profile
« on: June 23, 2011, 06:05:13 am »
Hi

I am struggling to get a query to work see below, I want to find all the job plans that do NOT have TMD in any of their tasks

WHERE  ( (exists (select jpnum from dbo.jobtask where ( not contains(description , '  FORMSOF(INFLECTIONAL,TMD)  ') ) ))) and ((status = 'ACTIVE'))

I am getting back mixed results  Cry with jobplan task actually containing the text TMD

Using 6.2.4 any help greatly appreciated....
Logged
craigmckay
Newbie
*

Karma: 0
Posts: 1



View Profile Email
« Reply #1 on: August 02, 2011, 03:45:13 pm »
You have said:
  "job plans which have tasks not containing TMS"

whereas what you want to say is:
  "job plans which do not have tasks containing TMS"

Move the "not" from before "contains" to before "exists" -- should do the trick.
Logged
Pages: [1]   Go Up
  Print  
Maximo Wire - The IBM Maximo Help & Discussion Forum > Maximo > Administration Tips & Tricks > Topic: Job Plan Task Description Text Query
 « previous next »
 
Jump to:  

Recent

TinyPortal v1.0 beta 4 © Bloc
Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!