Is it possible "Order By" clause in sub query (Advance Query)

Is it possible "Order By" clause in sub query (Advance Query)

  

Is it possible in "Order By" clause allowed in a subquery?

Our Scenario : I am fetching only top 10 record on preparation, after click on the pagination get another top 10 record based on two input parameter: 1. PageNo 2. Record Count.

But my problem is when i click sort data by column, data is not sorted.

Please find the screen shot for your reference....



Please help me....


Regards,

Amit Verma



Hi Amit,

Did you debug to check what value of the Order parameter is, and whether it's what you expect it to be?

Kilian Hekhuis wrote:

Hi Amit,

Did you debug to check what value of the Order parameter is, and whether it's what you expect it to be?


Thanks for reply.

I am passing order parameter like this 

EncodeSql(List_SortColumn_GetOrderBy(PaymentTable.Id,"[PoId]"))

Please suggest me how to do this.

Solution

Hi Amit,

What does the List_SortColumn_GetOrderBy return (when you're debugging)? Note that "[PoId]" here is the default value, the actual value is set by the List_SortColumn Widget. Also, dit you read the documentation (note, the "DefaultOrder:" isn't needed, but I'd advise you to add the Entity name as shown), and seen the training video?

Solution