WebService and Sql filter

[Alberto]

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?

[Bruce]

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

[Alberto]

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.

[Bruce]

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

[Alberto]

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

[Bruce]

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

[Alberto]

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

[Bruce]

thanks - fixed for 11.16