How to set Variable Attributes(How to make sys_created_on descending)

Kentaro Numata
Tera Guru

Hello.

I created a Reference Variable that selects Incident records.

I want to display the items in order of newest sys_created_on.

I asked Chat GPT how to set Variable Attributes, but they all failed.

 

ref_ac_order_by=-sys_created_on

ref_ac_order_by=sys_created_on,orderbydesc=sys_created_on

 

Does anyone know how to achieve this?

1 REPLY 1

Hitoshi Ozawa
Giga Sage
Giga Sage

Maybe because there's no column name ="sys_created_on" in the incident table.

Column name of column "Created" is "created". If I set Variable attribute to "ref_ac_order_by=created" in my reference field, the records will appear sorted by Created column.

HitoshiOzawa_0-1729482898162.png

HitoshiOzawa_1-1729482918009.png