Submitted by WayneK on 2019/04/27 09:50
I want to sort a text priority column:
 
A, B, C, (blank)
 
But sorting gives me either:

1) (blank), A, B, C
or
2) C, B, A, (blank)
 
The default number priority column avoids this by using "5" as highest priority.  That's counter-intuitive to me.  "1" has always meant highest priority in my mind, and I'd prefer not to have to remember that in InfoQube, priorities are reversed.
 
Seems like there should be a simple solution.
 
Wayne
112p

Comments

Hi Wayne,
 
I agree with you, but the standard when sorting ascending is to put blanks at the start of the list. Not much I can do about that.
 
Of course, you could filter out blanks...
Another solution is to use Group by and close the Blank group when you don't want to see it
Lastly, you could use a calculated field to change the blank ones to Z
 
[edit]
If you use the grid source sort, there is a way ! This sort string sorts items by Priority, with empty ones at the end:
 
[Priority] is not null, [Priority]
 
(this first sorts tasks with a priority on top, then sorts these by priority)
See 5. Sorting and Grouping Items on how to use the source sort
[/edit]
 
 
Pierre_Admin
IQ Designer
 

Pierre,
 
Thanks for the ideas.  I always appreciate your input because even if I don't use a suggestion in this particular application, it helps me learn about InfoQube's capabilities in ways that might be used elsewhere.
 
In this case, I think I've settled on the simple:
 
1) Put priority text field in a form
2) Select all unassigned items (by manual selection, or filter for blanks in priority field)
3) Use form to assign priority "Z" to all selected items
4) This sorts the items to the bottom and flags them as having "unassigned" priority
 
Wayne