Hi,

In my index I have 2 fields

1. field 1 : City name 1 (cityname1)
2. field 2 : City name 2 (cityname2)

After indexing the index looks like this

Document 1 : cityname1= Los Angeles, cityname2=San Francisco
Document 1 : cityname1=New York , cityname2=Cupertino


In the UI I must show all cities (cityname1 or cityname2) in alphabetical order

so ideally I should get

Cupertino
Los Angeles
New York
San Francisco

In my code I am using new Sort(new SortField("cityname1",SortField.STRING),new SortField("cityname2",SortField.STRING));

But the outcome is that Lucene is sorting each sort field individually and coming like this
Los Angeles
San Fransisco
Cupertino
New York

Is there a way I can achieve the desired result or I have to write a custom sort?

Hi,
why don't you sort each city name in a separate Document ?

If you have an index containing


your resulting list will always be of two elements, nor Hibernate Search nor Lucene will be able to sort it in a list of 4 elements.

I would recommend you to implement the sort yourself. But Lucene.Net has an abstract class PriorityQueue that can be used in custom collectors (it is used internally in Lucene.Net while sorting (instead of collecting all results and then applying a sort on them) )

public class MyQueue : Lucene.Net.Util.PriorityQueue<int>
{
public MyQueue(int MaxSize) : base()
{
Initialize(MaxSize);
}

public override bool LessThan(int a, int b)
{
return a < b;
}
}

int queueSize = 3;
MyQueue pq = new MyQueue(queueSize);
pq.InsertWithOverflow(1);
pq.InsertWithOverflow(9);
pq.InsertWithOverflow(8);
pq.InsertWithOverflow(3);
pq.InsertWithOverflow(5);

int i1 = pq.Pop();
int i2 = pq.Pop();
int i3 = pq.Pop();


Hope this will help you ).