Hi,

I'm having a problem using "order by" in a ITQL query when the field
used for sorting is empty.

Imagine this query:

**********************************************************************
select
    $pid $dateinitial
from <#ri>
where
    $pid <http://roda.dgarq.gov.pt/#description-dateinitial> $dateinitial
order by $pid
limit 3  offset 0

--- Results ---

"pid","dateinitial"
info:fedora/roda:168,
info:fedora/roda:1930,
info:fedora/roda:1931,
**********************************************************************
Note that the second field $dateinitial is empty for all values.

Now, if i do the same query but ordering by $dateinitial. Like this:
**********************************************************************
select
    $pid $dateinitial
from <#ri>
where
    $pid <http://roda.dgarq.gov.pt/#description-dateinitial> $dateinitial
order by $dateinital
limit 3  offset 0

--- Result is error ---

org.trippi.TrippiException: ITQL query failed: empty String
        at org.trippi.impl.kowari.KowariSession.query(KowariSession.java:256)
        at 
org.trippi.impl.base.ConcurrentTriplestoreReader.findTuples(ConcurrentTriplestoreReader.java:79)
...
**********************************************************************

Does anybody knows a solution arround this? I want to be able to sort
by any field, even when it is empty.

Best regards,
Rui Castro

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Fedora-commons-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fedora-commons-developers

Reply via email to