You are viewing limited content. For full access, please sign in.

Question

Question

Is it possible to sort in numerical order with columns in LF Client?

asked on June 2, 2014

I have a client that would like to sort in numerical order with columns in the Laserfiche Client.  The issue is that the columns order as such:

1

1000

1001

1002

13

145

1452

900

901

902

903

etc.

 

The issue is a bit more complex, however.  These aren't only number, they're alphanumeric codes (Ordinance or Resolution Numbers).  So in practice, it's ordering:

1000-R-13

1001-R-13

1002-R-13

953-R-13

954-R-13

 

Is there any way to list the column values like this?

953-R-13

954-R-13

1000-R-13

1001-R-13

1002-R-13

 

Thanks.

0 0

Answer

APPROVED ANSWER
replied on June 2, 2014

It isn't possible to sort numerically on a non-numeric field. You would need to either change the format to have left padded zeros (e.e. 0953-R-13) or put the numeric part in its own number field and sort on that.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.