What is the difference between addOrderBy and OrderBy glide record method.

[Veronica11]

What is the difference between addOrderBy and OrderBy glide record method.

[bardakov]

addOrderBy - Adds a column to order by in the query.

orderBy - Specifies an orderBy column and may be called more than once to order by multiple columns.

[Veronica11]

Viktor,

Could you please elaborate this with the help of example.

[Sujata Vishwak1 · Accepted solution]

Hi Jyoti,

addOrderBy(String column)

Adds a column to order by in the query.

Eg:

var gr = new GlideRecord('incident');

gr.addOrderBy('number');      -->Here, number column of incident will be placed in order.

gr.query();

orderBy(String column)

Specifies an orderBy column.

Eg:

var gr = new GlideRecord('incident');

gr.orderBy('number');     

gr.orderBy('sys_created_on');       -->Here, you can add multiple columns

gr.query();

Difference : "OrderBy" May be called more than once to order by multiple columns.

Thanks,

Sujata Vishwakarma

Please mark if this is helpful.

[Veronica11]

Thanks Sujata