Topic Options
Rate This Topic
#94141 - 01/04/04 03:47 AM Search i diaryfield
lars pettersson Offline
Pooh-Bah

Registered: 06/12/01
Posts: 1888
Hi. I have found that % in diaryfield and searchmode only shows the requests
where "%" is stored in the diaryfield.
'Diaryfield' != $NULL$ shows me all requests where the field is not empty.
Is this something special for diaryfilds? Normally % is the same as !=$NULL$

5.1.2 client, 5.0.1 server, Oracle 8

Thanks..L ars




Top
#94142 - 01/04/04 06:25 AM Re: Search i diaryfield [Re: stephen lumini]
Jarl Groneng Offline
enthusiast

Registered: 03/10/05
Posts: 2371
Lars,

Take a look at this article:
http://www.remedy.com/customers/dht/archive/RxPressV9I12001A.htm


Regards,
Jarl

> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@ARSLIST.ORG]On Behalf Of
> lars.j.pettersson@VATTENFALL.COM
> Sent: 4. januar 2004 16:48
> To: ARSLIST@ARSLIST.ORG
> Subject: Search i diaryfield
>
>
> Hi. I have found that % in diaryfield and searchmode only
> shows the requests
> where "%" is stored in the diaryfield.
> 'Diaryfield' != $NULL$ shows me all requests where the field
> is not empty.
> Is this something special for diaryfilds? Normally % is the
> same as !=$NULL$
>
> 5.1.2 client, 5.0.1 server, Oracle 8
>
> Thanks..L ars
>
>
>
> UNSUBSCRIBE or access ARSList Archives at
> http://www.ARSLIST.org (Support: mailto:support@arslist.org )
> ARSList is hosted by QMX SUPPORT SERVICES at www.QMXS.com
>




Top


Moderator:  Matt Reinfeldt