How to set Variable Attributes(How to make sys_created_on descending)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2024 07:58 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2024 08:55 PM
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.