nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

SearchParameters and sorting by date

morgan_david

I'm using the Java foundation APIs for searching the repository and I'm trying to apply a sort on a date field.
Code example of what I'm trying to do:

From model:

<property name="ident:identDate">
    <type>d:date</type>
    <mandatory>true</mandatory>
</property>
‍‍‍‍‍‍

String sortField = "@ident\\:identDate"
boolean sortAsc = true;
searchParams.addSort(sortField, sortAsc);
‍‍‍‍‍

Now I'm able to sort by other properties in the model that are d:text. Is there something special that needs to be done to sort by dates?

Thank you.

Find more posts tagged with

Comments

morgan_david

So I've looked a little more into this. Lucene won't sort on a tokenized field. So I've added another field that mimics the date field except it's just an int and it's stored untokenized.

<property name="ident:identDateSort">
   <type>d:int</type>
   <mandatory>true</mandatory>
   <index enabled="true">
      <tokenised>false</tokenised>
   </index>
</property>
‍‍‍‍‍‍‍‍‍

Unfortunately things still aren't sorting. What am I doing wrong?

morgan_david

I figured out what I was doing wrong. I was passing the wrong field namespace. Once I passed in the right namespace and stopped escaping some characters sorting started working.

chrisb

I figured out what I was doing wrong. I was passing the wrong field namespace. Once I passed in the right namespace and stopped escaping some characters sorting started working.

I am trying to do the same thing RE: sorting. Would you mind posting the correct syntax for the example you gave above - would really help me out

Thanks,

Chris

morgan_david

No problem. Assuming your namespace is "http://www.example.com/name/space" and you want to sort of field "sort" then what you want to pass to addSort would be like so:

searchParams.addSort("@{http://www.example.com/name/space}sort", true);
‍‍‍

When building a query you want to escape any special characters for Lucene like '{', ':', and '}', but for sorting you do not want to escape these characters.

For performance sake it's best if your sort field is not a string if you can help it. String sorting is apparently the most expensive sort for Lucene.

chrisb

Thanks for the quick reply and the explanation - much appreciated, and exactly what I was after 😎 .

andy

Hi

You can sort on date properties even when tokenised. Date does not include time in the index by default. (It can be configured to use time and sort is still supported - we build the additional column required for sort internally in this configuration)

Stricly, lucene only fails to order if there is more than one token per doc (even if there are no docs for some and nonefor others)
This may have changed in later versions.

Andy