Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an issue with email notifications. If you notice you’re not receiving emails from the Community, please check your SPAM folder and release the emails. This should temporarily resolve the problem while we work behind the scenes to solve the larger issue with our mail sender. Thank you for your patience!

Alteryx Server Knowledge Base

Definitive answers from Server experts.

Gallery Schedule Sorting not sorting correctly

JamesHa
Alteryx
Alteryx
Created

Environment Details


When viewing the schedules in the Gallery and you go to sort the schedules by workflow name, they sort in a random way.
  • Alteryx Server
    • Version 2020.2.3+


Cause


When a schedule is created there is an optional Schedule Name field to name the schedule.


If this name field is left blank and the schedule is created, sorting by Workflow on the Schedules page will sort the list relative to the mongoid of the schedule. 

Red Square: Workflows scheduled WITHOUT optional schedule name and they sort by the mongoid of the schedule
Green Square: Workflows scheduled WITH optional schedule name and they sort by schedule name

image.png

To illustrate the mongoid part of the sort, below is a table of the same 7 schedules in the same order: 
image.png

Resolution


To fix the sort issue you can edit your schedules to have a schedule name equal to the workflow name and then the schedules will sort correctly.

Red arrow: Workflow name
Green Arrows: If you fill in schedule name, Schedule: {name} will appear


If there are a mixture of workflows with no schedule name and workflows with schedule name, sorting the schedule list by the Workflow column will sort in the table as such:

Schedules without a schedule name will sort by the mongoid of the schedule.
Schedules with a schedule name will sort by the schedule name. 


 
No ratings
Comments
Paul_Holden
8 - Asteroid

Notes

The the last two lines of that article look to be incorrect, I think that they should read:

 

Schedules without workflow schedule name by mongo id
Schedules with workflow schedule name

 

The article fails to mention that the schedules list is sorted by Schedule name even when the sort option on the Workflow name column is chosen?

The screen capture in the article even shows that the person choose to sort by Workflow and not by Schedule but that isn’t called out.

 

In the UI, if the Schedule does not have a name, then the Workflow name is shown (repeated) in the Schedule column. Because of this the only way to identify the where the Schedule name is missing is to notice that the rows are not correctly sorted.

 

Looking at the creation dates of the Schedules on our system that I have had to fix it would appear that earlier versions of the Gallery automatically copied the Workflow name into the Schedule name if the latter was not specified. I'm not sure why this was changed as it seems to be a sensible solution to the issues that have resulted from the changes in this version?

DanielG
10 - Fireball

@JamesHa -- is this going to be fixed in any future releases to just sort on Workflow Name to save us this extra non-intuitive step?

 

Thanks

JamesHa
Alteryx
Alteryx

@JohnPelletier could you help me out with @DanielG question?

JohnPelletier
Alteryx
Alteryx

@DanielG  and @JamesHa We'll work on getting that sorting to work more intuitively based on the selected column. Feel free to check again in May.