Want to implement pagination & sorting , here I have added highlighted query for pagination & sorting but getting error
For TableSort input parameters, are you changed its property expand inline to yes?
you need to send column name into this parameter which you want to sort by.
Hi ,
I think Please try with NEXT keyword instead of NTEXT.I hope it will resolve your issue.Regards
--RJ--
As per this error message you are writing incorrect parameter name @qpinStartIndex which not exist into your input parameters
Yes This error meaning is that which you mentioned but I am using 'StartIndex' parameter
Are you passing testing values to your input parameters into test inputs tab?
After adding Test input this error coming ,
Hi @Mostafa Othman
Yes , Now its working fine
Thank you so much!
In browser I am facing this issue
Please start debugging and check values you send as input parameters to advanced sql. It seems one of these values is missing or incorrect.
Hello,
Check this post:
https://www.outsystems.com/forums/discussion/64754/sql-server-offset-fetch/
Hi @Fábio Vaz ,
Yes I did same but getting this error
Hi Preeti,
Service Studio tells you it is an incorrect syntax, just google "sql offset syntax" and you'll find you made 2 typo's in one single line.
Dorine