Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Sorting Value Lists in Descending Order with "NULL" in the equation.


This topic is 4875 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have a task management program for my cabinetshop.

Tasks are assigned priority 1-2-3 from a valuelist.

There may be 10 items on the list but only three are in play at any time.

The focus for 1-2-3 essentially means:

Do this one now.

Do this one next.

Do this one if you something hangs you up on priority 1 or 2.

By constraining the priorities to 1-2-3 we minimize the things under consideration.

THE PROBLEM IS: when we perform a descending sort on this value list all of the tasks that have no priority assignments show up at the top of the list.

I would like the sort to be essentially equal to:

1

2

3

""

Is there anyway to keep the tasks that have not been assigned a priority at the bottom of the list?

Posted

Thanks Comment.

That link provided a good idea.

I did a work-around that set the value to 999 upon record creation.

This automatically put the "empty" fields at the bottom of the list.

I then conditionally colored the font to disappear on the layout so that it would not be so distracting.

Would be nice to have an option to dis-include these values in the list if null.

This topic is 4875 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.