Thu, 24 Sep 2026
Login

Order by query in datalist by two columns

Confluence User - 13 Jul, 2019

Hi experts,

I need to sort my list using order by based on two column. My query works when i run in mysql tool but prompt error 'Failed to retrieve column' when run in Joget. I also know that we can set order by column in datalist properties but it only allows sorting by 1 column only.

My query is as below:

SELECT app_fd_candidateData.id, c_req_id, c_name, c_course, c_cgpa, c_department, c_experience, c_resume, c_status FROM app_fd_candidateData
JOIN app_fd_candidateEvent
ON app_fd_candidateEvent.c_eventName = app_fd_candidateData.c_eventName
WHERE (app_fd_candidateData.c_status = 'Interview In Progress' OR app_fd_candidateData.c_status = 'Waiting to be Interview')
AND app_fd_candidateEvent.c_eventStatus = 'Active'
ORDER BY c_status ASC, c_req_id ASC

Is it possible to run this query in Joget datalist?

datalists;orderby;sort;column;jdbc

2

Confluence User •
13 Jul, 2019 •
confluenceUser •
1 •
confluenceUser •

Hi all, this problem already solved. Just need to use different syntax for Joget v6.

SELECT app_fd_candidateData.id, c_req_id, c_name, c_course, c_cgpa, c_department, c_experience, c_resume, c_status,
ROW_NUMBER() OVER (ORDER BY c_status ASC, c_req_id ASC) AS No
FROM app_fd_candidateData
JOIN app_fd_candidateEvent
ON app_fd_candidateEvent.c_eventName = app_fd_candidateData.c_eventName
WHERE (app_fd_candidateData.c_status = 'Interview In Progress' OR app_fd_candidateData.c_status = 'Waiting to be Interview')
AND app_fd_candidateEvent.c_eventStatus = 'Active'

Confluence User •
16 Oct, 2020 •
confluenceUser •
•
confluenceUser •

hye.. 

may i ask, if i want to sort by dateCreated..

original : select * from app_fd_document where c_division = 'HR' ORDER BY dateCreated ASC.

ive got a message that said cannot retrieve column..

Then, what should i change in my query?

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
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 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.
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?
I Want to Add , Add to Cart functionality like Swiggy or Zomato This is possible in joget?
List Question
Create Folder on the Home Page
Async search list with ajax
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print