How to add Order By in query

Posted by anu31221@gmail.com on 10-Jan-2016 22:44

rbf_selectQuery("SELECT id, name, R115577424, days_after, R115577446, activity_priority#code, move_weekend#code, send_email_automated#code, include_signature#code, description, R121904036, R134815371, Attachment_Name, email_template_id FROM activity_template WHERE R115581422="+planId, 100, setGridValues);
}

How to add the oder by in the query

All Replies

Posted by anu31221@gmail.com on 11-Jan-2016 07:43

Any response?

Posted by jsniemi79 on 11-Jan-2016 08:10

I didn't run through your example, but I've done this before.  Try this below.

rbf_selectQuery("SELECT id, name, R115577424, days_after, R115577446, activity_priority#code, move_weekend#code, send_email_automated#code, include_signature#code, description, R121904036, R134815371, Attachment_Name, email_template_id FROM activity_template WHERE R115581422="+planId+" ORDER BY name DESC", 100, setGridValues);

Posted by anu31221@gmail.com on 11-Jan-2016 21:24

Big Thank you.

Yes it resolved it. This was very important for me to fix

Posted by Anoop Premachandran on 11-Jan-2016 23:33

Thanks Jason.

Here is the documentation of the subset of SQL constructs we support in select Query

documentation.progress.com/.../index.html

The documentation of AJAX API variant of this API is missing this info, We will fix this asap.

This thread is closed