NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Alberto on July 10, 2019, 07:22:27 AM

Title: WebService and Sql filter
Post by: Alberto on July 10, 2019, 07:22:27 AM

I tried to use te Sql Filter in the Web service pethod but it does nothng.
I had to use SQL() in the normal filter.
Ive search the docs fos sql filter and found nothing.
What is it for?

Title: Re: WebService and Sql filter
Post by: Bruce on July 10, 2019, 11:32:45 PM

It sets the prop:SqlFilter property for the View.
I recommend putting something in there, then right-click on the procedure, view the embeditor (source) and search for your filter.

cheers
Bruce

Title: Re: WebService and Sql filter
Post by: Alberto on July 12, 2019, 07:05:21 AM

Using the filter:

        loc:filter.Cat('art:Activo_Ventas=1 and SQL(isnull(GuidBlob,'''')='''') ')
        view_arts_sin_foto{prop:filter} = loc:Filter.GetValue()

Using Sql filter:

        view_arts_sin_foto{prop:filter} = loc:Filter.GetValue()

Theres no loc:filter setting.

Title: Re: WebService and Sql filter
Post by: Bruce on July 14, 2019, 11:01:47 PM

In an app here I added yyy as the filter and xxx as the SQL Filter.
I see the following in the generated code;

        loc:Filter.SetValue('')
        loc:Filter.Cat(yyy)
        view_5{prop:filter} = loc:Filter.GetValue()
        view_5{prop:sqlfilter} = '+' & xxx

If you're not seeing that I guess I need an example to see what's going on.

Cheers
Bruce

Title: Re: WebService and Sql filter
Post by: Alberto on July 15, 2019, 07:00:06 AM

I see this:

        ! End of "Before Populating Result"
        loc:filter.Cat(yyy)
        view_arts_sin_foto{prop:filter} = loc:Filter.GetValue()
        xml.start()

NT11.15

Title: Re: WebService and Sql filter
Post by: Bruce on July 16, 2019, 04:11:11 AM

I guess I need an example app to see what's going on Alberto?

Title: Re: WebService and Sql filter
Post by: Alberto on July 16, 2019, 04:19:39 AM

here it goes... just an app and dct
the proc is
samiApiDatosArticulos

Title: Re: WebService and Sql filter
Post by: Bruce on July 17, 2019, 06:24:40 AM

thanks - fixed for 11.16