In my documents there are several fields, but for example say there are
three fields:

Description - text  - this variable text
Code - string - always a single character
Prefer - boolean

User searches on Description.

When returning results I have to order results as following:

Code = C
Code = B
Code = S
Code = N
Prefer = true and Code is NULL
Prefer = false and Code is NULL
Prefer is NULL and Code is NULL

How can this be achieved?

Thanks in advance!

Reply via email to