How to construct a where clause in web service proxy for Vantag

Thanks Stephen,

This is extactly what I want!

Is this syntax is part of Progress query syntax?

--Charlie

--- In vantage@yahoogroups.com, "Stephen Edginton" <stephene@...>
wrote:
>
> How about MATCHES *west*
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of bw2868bond
> Sent: 04 September 2007 20:07
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: How to construct a where clause in web
service
> proxy for Vantage 8.0.3 ?
>
>
>
> AFAIK you can only use CONTAINS on fields that have a Word Index
> associated with them.
>
> You could create a WordIndex on the name field or you can return
the
> entire customer dataset and then use a .net string method to return
> names that have the desired search term in them...
>
> bw
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "cminglu" <cminglu@> wrote:
> >
> > Hi, All,
> >
> > I am new to this forum, I am trying to build a mobile solution
> (i.e.
> > web portal to access the Vantage Service 8.0.3 via web service
> adapter
> > calls).
> >
> > I am trying to query a list of customers by using the following
> code:
> >
> > returnVal = CustomerSearch.ExecuteMethod("GetList", new object
> [] {
> > whereClause, pageSize, absolutePage });
> >
> > What is the correct way to construct the whereClause?
> >
> > For example, I want to get a list of customers who's company name
> > contains 'West'.
> >
> > (1) where Company = 'VN10T' and (Name Begins 'West') -- works
> only
> > for customers whose name starts with 'West'.
> >
> > (2) where Company = 'VN10T' and (Name CONTAINS 'West') -- does
> not
> > work, with invalid query for the webservice error.
> >
> > (3) where Company = 'VN10T' and Name like '%West%' -- SQL like
> query
> > does not work either.
> >
> > Does this whereClause uses the Progress query syntax? Anybody has
> > examples that can share?
> >
> > Thanks in advance.
> >
> > --Charlie.
> >
>
>
>
> [Non-text portions of this message have been removed]
>
Hi, All,

I am new to this forum, I am trying to build a mobile solution (i.e.
web portal to access the Vantage Service 8.0.3 via web service adapter
calls).

I am trying to query a list of customers by using the following code:

returnVal = CustomerSearch.ExecuteMethod("GetList", new object[] {
whereClause, pageSize, absolutePage });

What is the correct way to construct the whereClause?

For example, I want to get a list of customers who's company name
contains 'West'.

(1) where Company = 'VN10T' and (Name Begins 'West') -- works only
for customers whose name starts with 'West'.

(2) where Company = 'VN10T' and (Name CONTAINS 'West') -- does not
work, with invalid query for the webservice error.

(3) where Company = 'VN10T' and Name like '%West%' -- SQL like query
does not work either.

Does this whereClause uses the Progress query syntax? Anybody has
examples that can share?

Thanks in advance.

--Charlie.
AFAIK you can only use CONTAINS on fields that have a Word Index
associated with them.

You could create a WordIndex on the name field or you can return the
entire customer dataset and then use a .net string method to return
names that have the desired search term in them...

bw


--- In vantage@yahoogroups.com, "cminglu" <cminglu@...> wrote:
>
> Hi, All,
>
> I am new to this forum, I am trying to build a mobile solution
(i.e.
> web portal to access the Vantage Service 8.0.3 via web service
adapter
> calls).
>
> I am trying to query a list of customers by using the following
code:
>
> returnVal = CustomerSearch.ExecuteMethod("GetList", new object
[] {
> whereClause, pageSize, absolutePage });
>
> What is the correct way to construct the whereClause?
>
> For example, I want to get a list of customers who's company name
> contains 'West'.
>
> (1) where Company = 'VN10T' and (Name Begins 'West') -- works
only
> for customers whose name starts with 'West'.
>
> (2) where Company = 'VN10T' and (Name CONTAINS 'West') -- does
not
> work, with invalid query for the webservice error.
>
> (3) where Company = 'VN10T' and Name like '%West%' -- SQL like
query
> does not work either.
>
> Does this whereClause uses the Progress query syntax? Anybody has
> examples that can share?
>
> Thanks in advance.
>
> --Charlie.
>
How about MATCHES *west*



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: 04 September 2007 20:07
To: vantage@yahoogroups.com
Subject: [Vantage] Re: How to construct a where clause in web service
proxy for Vantage 8.0.3 ?



AFAIK you can only use CONTAINS on fields that have a Word Index
associated with them.

You could create a WordIndex on the name field or you can return the
entire customer dataset and then use a .net string method to return
names that have the desired search term in them...

bw

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"cminglu" <cminglu@...> wrote:
>
> Hi, All,
>
> I am new to this forum, I am trying to build a mobile solution
(i.e.
> web portal to access the Vantage Service 8.0.3 via web service
adapter
> calls).
>
> I am trying to query a list of customers by using the following
code:
>
> returnVal = CustomerSearch.ExecuteMethod("GetList", new object
[] {
> whereClause, pageSize, absolutePage });
>
> What is the correct way to construct the whereClause?
>
> For example, I want to get a list of customers who's company name
> contains 'West'.
>
> (1) where Company = 'VN10T' and (Name Begins 'West') -- works
only
> for customers whose name starts with 'West'.
>
> (2) where Company = 'VN10T' and (Name CONTAINS 'West') -- does
not
> work, with invalid query for the webservice error.
>
> (3) where Company = 'VN10T' and Name like '%West%' -- SQL like
query
> does not work either.
>
> Does this whereClause uses the Progress query syntax? Anybody has
> examples that can share?
>
> Thanks in advance.
>
> --Charlie.
>



[Non-text portions of this message have been removed]