Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

DW Filter() OR Filter PFC service

5 posts in DataWindow Last posting was on 2009-04-30 14:06:09.0Z
AR Posted on 2009-04-30 02:22:17.0Z
Sender: 6ee3.49f90a64.1804289383@sybase.com
From: AR
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: DW Filter() OR Filter PFC service
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49f90b59.6ef8.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Apr 2009 19:22:17 -0700
X-Trace: forums-1-dub 1241058137 10.22.241.41 (29 Apr 2009 19:22:17 -0700)
X-Original-Trace: 29 Apr 2009 19:22:17 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89210
Article PK: 418462

I want to Filter certain records in a DW by allowing the
user to choose the operators like '=', 'has' & 'starts'
which in SQL language is similar to '=', 'like %x%', 'like
%x' respectively. Can i do this using the Filter method or
PFC DW Filter service., The only operators in the DW Filter
seems to be '=, >, <, >=, <=' This seems to work fine for
numbers. But does not work for Strings.
Any help would be appreciated.
Thnx
AR


Scott Morris Posted on 2009-04-30 12:01:48.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49f90b59.6ef8.1681692777@sybase.com>
Subject: Re: DW Filter() OR Filter PFC service
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49f9932c$2@forums-1-dub>
Date: 30 Apr 2009 05:01:48 -0700
X-Trace: forums-1-dub 1241092908 10.22.241.152 (30 Apr 2009 05:01:48 -0700)
X-Original-Trace: 30 Apr 2009 05:01:48 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89211
Article PK: 418463


<AR> wrote in message news:49f90b59.6ef8.1681692777@sybase.com...
>I want to Filter certain records in a DW by allowing the
> user to choose the operators like '=', 'has' & 'starts'
> which in SQL language is similar to '=', 'like %x%', 'like
> %x' respectively. Can i do this using the Filter method or
> PFC DW Filter service., The only operators in the DW Filter
> seems to be '=, >, <, >=, <=' This seems to work fine for
> numbers. But does not work for Strings.
> Any help would be appreciated.

The filter expression supports, AFAIK, any datawindow expression that
evaluates to a boolean value. Use the index in help and enter "like
operator" - you'll see many more options. The dialog simply gives you
direct access to the most commonly used ones.


Vipul Posted on 2009-04-30 13:23:30.0Z
Reply-To: "Vipul" <spam@myvisionexpress.com>
From: "Vipul" <spam@myvisionexpress.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49f90b59.6ef8.1681692777@sybase.com> <49f9932c$2@forums-1-dub>
In-Reply-To: <49f9932c$2@forums-1-dub>
Subject: Re: DW Filter() OR Filter PFC service
Lines: 21
Organization: Insight Software LLC
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49f9a652$1@forums-1-dub>
Date: 30 Apr 2009 06:23:30 -0700
X-Trace: forums-1-dub 1241097810 10.22.241.152 (30 Apr 2009 06:23:30 -0700)
X-Original-Trace: 30 Apr 2009 06:23:30 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89212
Article PK: 418464

FYI, we use http://www.dwcfilter.com/ - COOLEST DW FILTER

"Scott Morris" <bogus@bogus.com> wrote in message
news:49f9932c$2@forums-1-dub...
> <AR> wrote in message news:49f90b59.6ef8.1681692777@sybase.com...
>>I want to Filter certain records in a DW by allowing the
>> user to choose the operators like '=', 'has' & 'starts'
>> which in SQL language is similar to '=', 'like %x%', 'like
>> %x' respectively. Can i do this using the Filter method or
>> PFC DW Filter service., The only operators in the DW Filter
>> seems to be '=, >, <, >=, <=' This seems to work fine for
>> numbers. But does not work for Strings.
>> Any help would be appreciated.
>
> The filter expression supports, AFAIK, any datawindow expression that
> evaluates to a boolean value. Use the index in help and enter "like
> operator" - you'll see many more options. The dialog simply gives you
> direct access to the most commonly used ones.
>


AR Posted on 2009-04-30 14:06:09.0Z
Sender: 6ee3.49f90a64.1804289383@sybase.com
From: AR
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: DW Filter() OR Filter PFC service
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49f9b051.4cf.1681692777@sybase.com>
References: <49f9a652$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Apr 2009 07:06:09 -0700
X-Trace: forums-1-dub 1241100369 10.22.241.41 (30 Apr 2009 07:06:09 -0700)
X-Original-Trace: 30 Apr 2009 07:06:09 -0700, 10.22.241.41
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89214
Article PK: 418468

Thnx for the response. For now, the operators provided by DW
works for us.
I will look into the DWC Filter to see the features. looks
like a good one....
AR

> FYI, we use http://www.dwcfilter.com/ - COOLEST DW FILTER
>
>
> "Scott Morris" <bogus@bogus.com> wrote in message
> news:49f9932c$2@forums-1-dub...
> > <AR> wrote in message
> news:49f90b59.6ef8.1681692777@sybase.com... >>I want to
> Filter certain records in a DW by allowing the >> user to
> choose the operators like '=', 'has' & 'starts' >> which
> in SQL language is similar to '=', 'like %x%', 'like >>
> %x' respectively. Can i do this using the Filter method or
> >> PFC DW Filter service., The only operators in the DW
> Filter >> seems to be '=, >, <, >=, <=' This seems to work
> fine for >> numbers. But does not work for Strings.
> >> Any help would be appreciated.
> >
> > The filter expression supports, AFAIK, any datawindow
> > expression that evaluates to a boolean value. Use the
> > index in help and enter "like operator" - you'll see
> > many more options. The dialog simply gives you direct
> > access to the most commonly used ones.
>


AR Posted on 2009-04-30 14:05:02.0Z
Sender: 6ee3.49f90a64.1804289383@sybase.com
From: AR
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: DW Filter() OR Filter PFC service
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49f9b00e.4c0.1681692777@sybase.com>
References: <49f9932c$2@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Apr 2009 07:05:02 -0700
X-Trace: forums-1-dub 1241100302 10.22.241.41 (30 Apr 2009 07:05:02 -0700)
X-Original-Trace: 30 Apr 2009 07:05:02 -0700, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89213
Article PK: 418465

Excellent!!! Thank you very much!!!!
AR

> <AR> wrote in message
> news:49f90b59.6ef8.1681692777@sybase.com... >I want to
> > Filter certain records in a DW by allowing the user to
> > choose the operators like '=', 'has' & 'starts' which in
> > SQL language is similar to '=', 'like %x%', 'like %x'
> > respectively. Can i do this using the Filter method or
> PFC DW Filter service., The only operators in the DW
> > Filter seems to be '=, >, <, >=, <=' This seems to work
> > fine for numbers. But does not work for Strings.
> > Any help would be appreciated.
>
> The filter expression supports, AFAIK, any datawindow
> expression that evaluates to a boolean value. Use the
> index in help and enter "like operator" - you'll see many
> more options. The dialog simply gives you direct access
> to the most commonly used ones.
>
>