Home Forum Download/Upload Links Search

NetTalk User Group

NetTalk User Group Meeting!
Live Webinar!
Saturday Nov. 16 
7am PST
Click Here To Register!
Home arrow Forum arrow NetTalk Web Serverarrow Web Server - Ask For Helparrow NetWebService - incorrect sort order for VIEW results
NetTalk Central
October 19, 2017, 09:07:58 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Welcome to the NetTalk Central Forums!
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: NetWebService - incorrect sort order for VIEW results  (Read 53 times)
Thys
Full Member
***
Posts: 224



View Profile WWW Email
« on: October 06, 2017, 04:05:14 AM »

Hi,

When returning a VIEW parameter in a web method on a TPS file, there is no way to override the sort order in which data is returned. In fact, even the default of the PK is not used for the results. I looked at both the JSON and XML portions in the code, there is a PROP:ORDER set to the PK column, but the results are not correct. Is there another way to specify the required order?

Thys
Logged
Thys
Full Member
***
Posts: 224



View Profile WWW Email
« Reply #1 on: October 06, 2017, 06:17:29 AM »

Hi,

I did see that prop:order gets or sets a string, but the template generates the column name without the string quotation characters. After changing source to use a string instead of the column name, the sort order is now correct.

But there is still the question on how to override the sorting order for the result.

Thys
Logged
Thys
Full Member
***
Posts: 224



View Profile WWW Email
« Reply #2 on: October 06, 2017, 06:24:18 AM »

Hi,

Second iteration and my problem is solved. In the template dialogue there is a field "Order By" and there was already a column name without quotes. Looks like when you press the button next to it and mistakenly select a sort column from the table (instead of a string variable that contains the required sort columns), the template doesn't warn you and result in a possible incorrect sort order.

Thys
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!

Login Form

Welcome Guest.






Lost Password?
No account yet? Register
home contact search contact search