Sorting in Data Table from instance Definition

SNOW User8 · ‎07-31-2018

Hi All,

Currently "Data table from Instance Definition" widget showing records in "Ascending" order. I want it to show the records in "Descending" order (Finally Created/Updated records first). How to implement that?

Please help me..

Thanks,

SNOW

VigneshMC · ‎07-31-2018

You can configure them in instance options, hold ctrl key and right click over the widget to access widget options, Then change order by field and order direction available under instance options.

Thanks

View solution in original post

SNOW User8 · ‎07-31-2018

Hi

Even I have checked with the Original "Data Table From Instance Definition" widget but still I can't see Order By & Order Direction fields

VigneshMC · ‎07-31-2018

I see it available under fields, can you post a screenshot on what you see when you click on instance options ?

Thanks

SNOW User8 · ‎07-31-2018

Yes. I can also see it under fields but it is not showing in instance option. I don't know why?

VigneshMC · ‎07-31-2018

Try add them to form through form layout available when hamburger icon is clicked.

Thanks

SNOW User8 · ‎07-31-2018

I can not see the Order By and Order Direction fields and I handled it by adding the condition "EQ^ORDERBYDESCnumber" in the Filter field.