Sorting on custom attribute

Options
MarcusM
MarcusM
edited February 9, 2016 in Documentum #1

Hi

We have a problem that has currently bested 3 developers, so now it is time to reach out for some help!

We are trying to sort our inbox in webtop. Sorting on a default column is not a problem, however if we try to sort on a custom column it doesn't work. It is not like we get any errors, it just doesn't sort properly.

The custom column show up as they should, and if a user clicks on the header of a custom column it will sort as expected. I therefore assume that it is atleast somewhat correctly implemented.

Problem is that it is not enough. We want it to sort by a custom column by default.

At the moment we are using the following lines to sort our inbox:


IInbox inboxService = getInboxService();
inboxService.setSortBy("date_sent DESC", true);

And it works perfectly!

Although we would like it to be like this:


inboxService.setSortBy("caseDiaryNumber DESC", true);

Where "caseDiaryNumber" is a custom column that we have added and as previously mentioned it seems to be correctly implemented.

So the big question is:

Is it even possible to default sort on custom attributes and if so, then how?

Tagged:

Comments

  • Haroon_A
    Haroon_A
    edited February 9, 2016 #2
    Options

    What's the data type of "caseDiaryNumber"? If it's string, try to change it to all lower-case [or upper case], before sorting.

    I have had this problem once, and that appeared to resolve the problem.

Categories