GRAILS: createCriteria NAND

Question

I have a bunch of rows from my query in createCriteria, but some changes have to be made, I need to hide the rows with a 0 in a column and a letter A in other column, but i won't hide them if they have 0 and another letter , how can I make this in createCriteria? my only solution is using a NAND, but it doesn't exist I think...

             createCriteria.list{
                     nand{
                          eq('value',0)
                          eq('letter','A')  
                     }
             }


             TABLE
             VALUE          LETTER
             0              A                HIDE
             0              B                NOT HIDE
             1              A                NOT HIDE

any suggestion?

What are the condition in SQL format? SELECT * From MyEntity Where value==0 and letter<>'A' ? — Miguel Prz, Feb 05 '13 at 15:41

score 2 · Answer 1 · answered Feb 05 '13 at 15:58

2

You can use and and ne for:

createCriteria.list {
    and {
        ne 'value', 0
        ne 'letter', 'A'
    }
}

answered Feb 05 '13 at 15:58

doelleri

19,232
5
61
65

this one doesn't work, because it will not show those with A or 0 , I need both to exists in the same row to hide – user1698253 Feb 05 '13 at 16:14
This one has to work for you. You are doing something wrong if it doesn't. – James Kleeh Feb 06 '13 at 03:52

score 0 · Answer 2 · answered Feb 05 '13 at 15:55

0

try "ne", not - equal

createCriteria.list{
   and{
      eq('value',0)
      ne('letter','A')  
   }
}

answered Feb 05 '13 at 15:55

Miguel Prz

13,718
29
42

score 0 · Answer 3 · answered Feb 05 '13 at 16:00

0

Using HQL you can do:

def result = Object.executeQuery(
   "from Object o where o not in " +
       "(from Object o2 where o2.value = '0' and o2.letter = 'A')",
  )

answered Feb 05 '13 at 16:00

Benoit Wickramarachi

6,096
5
36
46

GRAILS: createCriteria NAND

3 Answers3