topic Re: NOT "FIELD" in App Development

NOT "FIELD"

Mon, 13 Jun 2016 11:39:25 GMT

Hello,

I try to write this condition :

FIELD1 équal 'AM' and FIELD2 without 'TERA'

So i tried to write :

[FIELD1] = 'AM' and [FIELD2] <> 'TERA'

But it doesn't work

Someone know how to do a NOT in a condition ?

Thanks in advance !!

Re: NOT "FIELD"

swuehl — Mon, 13 Jun 2016 11:49:19 GMT

[FIELD1] = 'AM' and NOT [FIELD2] = 'TERA'

but I would have assumed your expression to work also. How do your field values look like and in which context are you using this expression?

Re: NOT "FIELD"

Mon, 13 Jun 2016 12:10:01 GMT

My complete sentence is

OSW = TAI with 0 time left - AM without TERA - MQ - CO

So i try to write

if([TAI Restant (h)]='0,0000' (OR Type = 'QN-AM' AND NOT [Statut Utilisateur] like '*TERA*' ) AND NOT Type like 'LP-MQ' AND NOT Type like 'CO-CO' ,'OSW')

But it doesn't work do you have a better solution ?

Re: NOT "FIELD"

sunny_talwar — Mon, 13 Jun 2016 12:29:17 GMT

Would you be able share few rows of data to see what exactly you are trying to do with the logic above?

Re: NOT "FIELD"

swuehl — Mon, 13 Jun 2016 13:04:04 GMT

I don't think the first part is correct syntax (or you may need to change the parentheses:

if( [TAI Restant (h)]='0,0000' OR ( Type = 'QN-AM' AND NOT [Statut Utilisateur] like '*TERA*' )...

or maybe

if( ( [TAI Restant (h)]='0,0000' OR ( Type = 'QN-AM' AND NOT [Statut Utilisateur] like '*TERA*' ) )...

or something else