Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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