Why I cannot use ORDER BY in system?

 
1
0
-1

Hi Experts,


I want to arrange my data by using dateCreated in accending.

But when I am using the query: select * from app_fd_document where c_division = 'HR'  ORDER BY dateCreated ASC. 

I have tried in server.. it can run correctly. I got the message that the columns cannot retrieve.. may I know why and how can i solve it? 

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      Hi

      What's the error?

      why don't you use "order" and "order by" fields under Datalist Builder > Properties?

        CommentAdd your comment...
      1.  
        1
        0
        -1

        it works!! tq so much.. (big grin)

          CommentAdd your comment...