How to modify column order in decision builder

[oneveu]

When in decision builder, you can modify the order of the rows but cannot figure out how to modify the order of the columns.

[DaveRead]

Hi oneveu,

Not sure if you had any luck with this but I was able to move the columns by editing the Order on the underlying 'Results' records [sys_decision_multi_result_element] - these records represent the Columns in the decision table

Interestingly there doesn't appear to be a direct reference to the decision table on these records, however the sys ID of your decision table will be in the 'Table' [name] column so you can search like so:

https://[instance].service-now.com/sys_decision_multi_result_element_list.do?sysparm_query=nameLIKE[decision_table_sys_id]

You can then add the Order column on the list view and edit accordingly.

One caveat - I'm not entirely sure in what scenario this occurs however I noticed a couple of our decision tables also had 'Delta Decision Tables' records [sys_decision_delta] - which doubled up the Results records. The Order will need to be changed for each equivalent entry, using the same Order for each Column of course.

There is a direct ref to the Decision table (via Parent field) so can just run below query and grab the Sys ID:

https://[instance_name].service-now.com/sys_decision_delta_list.do?sysparm_query=parent%3D[decision_table_sys_id]

I just added an Or condition to my Results query so I could see all the entries at once:

https://[instance_name].service-now.com/sys_decision_multi_result_element_list.do?sysparm_query=nameLIKE[decision_table_sys_id]%5EORnameLIKE[decision_delta_sys_id]



Hope that helps!

Thanks,

Dave

[Lisa Holenstein]

The order of the decision columns isn't relevant for the decision-making, since the whole row will be evaluated at once. Thus, there's no functional need to reorder.
If editing large tables becomes cumbersome, we've introduced a new feature in Yokohama to filter decision tables to only show the rows you're currently working on. Keep in mind that the rows are still there, just not shown as long as the filter is set.

Hope this helps,

Lisa

---

Have questions about Workflow Automation? Check out the Workflow Academy video series or the Workflow Automation - Center of Excellence