Tried NOT ('field1' LIKE "%/%") --no go
Tried (NOT ('field1' LIKE "%/%")) -- no go
I'll expand on my request a little.
I have a vendor form reading active directory thru LDAP. One of the user's
attributes is 'physicalDeliveryOfficeName' , some users have the value in this
field as ABC/123 or ABC or AAA-123\123. On this field, I only want to extract
what is to the left of the "/".
Therefore, I used the string:
SUBSTR($physicalDeliveryOfficeName$, 0, STRSTR($physicalDeliveryOfficeName$,
"/") - 1)
This query works fine, except when there is no "/" , then I don't get that
record.
Thanks everyone.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tommy Morris
Sent: Thursday, March 01, 2012 4:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: query help
Try it like this NOT ('field1' LIKE "%/%")
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Martinez, Marcelo A
Sent: Thursday, March 01, 2012 4:15 PM
To: arslist@ARSLIST.ORG
Subject: Re: query help
Thanks Axton. I've not used NOT before.
Your example does work querying the incident form, etc. But does not work on my
vendor form (I said view form before, that's incorrect, my fault). Also
'field1' is a character field...
'field1' LIKE "%/%" -- works and returns the expected results. But I want the
opposite.
NOT 'field1' LIKE "%/%" -- no entries are returned.
Anything else I could try?
Thanks - Marcelo
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Thursday, March 01, 2012 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: query help
NOT 'field1' LIKE "%/%"
On Thu, Mar 1, 2012 at 3:21 PM, Martinez, Marcelo A <marc...@cpchem.com> wrote:
> **
> I've drawn a blank.. need help creating a query.
>
> I have a field (field1) on a view form that I want to search for all
> records that do not contain symbol "/" (forward slash).
> Example of data in field:
> ABC/123
> ABB
> ABC/345
> DEF/555
> DEF
> XY
>
> I only need the query to return ABB, DEF, XY.
>
> I can do 'field1' LIKE "%/%" ---but how do I do the opposite?
>
> I've tried: 'field1' != "%/%" ---this does not work.
>
>
> Thanks for the help,
> Marcelo
>
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12
www.wwrug12.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12
www.wwrug12.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
