Sorting value for the column

HCL Domino Domino Forum
1

Hello

how can i sort the value in the first column of the view

if column contain following thing

13a

131.a

14\A

14\B

13001\B

please let me know all the possible way to do it.

Regards & Thanks

dev

2

Subject: sorting value for the column

Mike thanks for your response.

actually it is text field where user can enter any certification request, as of now there is no validatoin on the form. so user can enter anycharacter anything else.

the purpose of sorting is,

13 should come first

13A should come next.

while 13\A should be next

whiel 13-A-02\should come next.

the business requirmenet does not have any predifined crierail for certificatoin required.

HELP:__

3

Subject: RE: sorting value for the column

There MUST be criteria - in fact, the criteria is your sentence explain what should go first and then next.

You will need to code that logic into a number field and use that to sort

4

Subject: sorting value for the column

Dev,

This has already been answered in your other thread

You are going to have to have a secondary, hidden field to control the sorting if the sorting that is visible to the user has no logic to it

Mike

5

Subject: RE: sorting value for the column

Mike,

could you please explore it in depth.?

Regards,

Dev

6

Subject: Duplicate - please ignore

7

Subject: RE: sorting value for the column

I highly doubt that he can – your desired sorting order makes absolutely no sense to anybody who has followed your threads. If you can’t explain the rules for sorting, you can’t code the sort.

8

Subject: RE: sorting value for the column

Where do I send my invoice? :slight_smile:

What is driving the sort order of your documents? What business logic is saying that the codes should appear in that order?

You will probably have to calculate the position when saving the document and set a number field. Then use that number field as a hidden column on the view to sort. The calculation of that number (and replacement of numbers on other documents to “slot them in”) is completely in your hands as I do not understand your sort order/number of documents/performance requirements etc