NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Thys on May 15, 2018, 09:49:47 PM

Title: NetWebServiceMethod - PROP:SQLFilter
Post by: Thys on May 15, 2018, 09:49:47 PM

Hi,

I have problem to get the sort order correct of a response view (SQL) whenever the SQL filter is set.

I have a clause in the "Order By" field, typically a name column. When the "SQL Filter" value is empty, the response is sorted correctly. But when I add an SQL filter clause, the ordering in the response returns to the default order and not that which is in the "Order By" field. I can't do without the SQL Filter value because Clarion syntax does not address NULL values properly.

These two have seemingly nothing in common - filtering should not affect ordering. But I've found that it does. As there a solution to this please?

Thys

Title: Re: NetWebServiceMethod - PROP:SQLFilter
Post by: Alberto on May 16, 2018, 02:28:06 AM

Did you try using PROP:SQLorder ?

Title: Re: NetWebServiceMethod - PROP:SQLFilter
Post by: Thys on May 16, 2018, 04:58:46 AM

Yes, no difference. Whatever is in PROP:SQLOrder or PROP:Order gets negated in the JSON.Append method, whenever PROP:SQLFilter is set.

Title: Re: NetWebServiceMethod - PROP:SQLFilter
Post by: Bruce on May 16, 2018, 11:55:40 PM

I think I'd need to see some sample code to see what you are doing Thys...