How do I have a ORDER BY clause in datalink (used for Subreport)

Permanently deleted user

February 24, 2016 22:21

When I try to add it to my query statement, Geocortex does not fetches anything. Removing ORDER BY from statement wokrs fine. 

 

So How can I have sorting or order by in my subreports ? 

 

Thanks

0

• 

  Permanently deleted user

  February 24, 2016 23:27

  Hey buddy, could you please test the SQL again and then paste the exact SQL tested here? Once we rule that out and assume GE can't do this then I would say your best bet is to order it at the database level or Arc Server.

  0
• 

  Permanently deleted user

  February 25, 2016 17:43

  Its fixed. Actually I was using ORDER BY clause before, WHERE clause, putting it after WHERE clasue fixed the issue. 

   

  My wrong statement was:

   

  SELECT cId, cmaterial, ndepth 

   

  FROM GW_DB_xxxxx 

   

  ORDER BY nepth ASC

   

  WHERE cId = @LPLink

   

  it was corrected by: 

   

  SELECT cId, cmaterial, ndepth 

   

  FROM GW_DB_xxxxx 

   

  WHERE cId = @LPLink

   

  ORDER BY nepth ASC

  0

Please sign in to leave a comment.