Question & Answer > View Question

Why I cannot use ORDER BY in system?

Confluence User - 19 Oct, 2020

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?

datalists;server;query

2

Confluence User •

19 Oct, 2020 •

confluenceUser •

1 •

confluenceUser •

Hi

What's the error?

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

Confluence User •

19 Oct, 2020 •

confluenceUser •

•

confluenceUser •

it works!! tq so much..

1

CSV | Excel | XML | PDF

RELATED QUESTIONS

i am building an app, and for some reason i am not able to open it anymore. All apps --> my app --> system error

Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor

How to Fix CSRF (j_spring_security_check after login) when doing Reverse Proxy Joget (tomcat) with Cloudflare (globally) ?

Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor

How to transfer all files and users data from on-premise to on-demand server?

How to customize datalist process formatter

Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.

Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.

how to generate the unique ID using textField

I want to have a visibility control for hyperlink based on the date in a list builder, what type of operator I should use and how?

1

CSV | Excel | XML | PDF

Your answer

Print