Question

Issue with ordering of documents in LF

Workflow Laserfiche

Updated February 6, 2015

asked on February 5, 2015

Hello,

I am having an issue with ordering of documents to be merged in LF. Say that I have an invoice that consists of many other smaller invoices:

Example: Invoice 12345 consists of 20 smaller invoices all labeled incrementally so:

123456-1

123456-2

123456-3

123456-4

123456-5

123456-6

123456-7

123456-8

123456-9

123456-10

123456-11

123456-12

123456-13

123456-14

123456-15

123456-16

123456-17

123456-18

123456-19

123456-20

When I bring these separate smaller invoices into LF, in order to merge into the larger invoice, LF orders the invoices as below:

123456-1

123456-10

123456-11

123456-12

123456-13

123456-14

123456-15

123456-16

123456-17

123456-18

123456-19

123456-2

123456-20

Etc.

Is there a way to control the order in which LF arranges the docs.

0 0

Replies

replied on February 5, 2015

Laserfiche treats the name of an entry as a string and will only sort on digit comparison. So it first compares the first digit, then the next and so on. This means that 10 comes before 2 because the first digit in ten is a 1 and 1 comes before 2. To order numerically, you need to pad your numbers with leading zeros to make them all the same number of digits.

001

002

003

...

010

011

012

...

100

Padding like this will make your names line up the way you want.

1 0

replied on February 6, 2015

Hello,

I wanted to add this Link here which gives an example of using Token Formatting which may help rename documents for this purpose.

Thanks

0 0

replied on February 5, 2015

Hi Darren,

Laserfiche currently doesn't have a way to sort non-numeric columns numerically. We do have this feature request filed in our system though.

Regards

0 0

You are not allowed to follow up in this post.

Question

Question

Issue with ordering of documents in LF

Replies

Sign in to reply to this post.