ontoportal-lirmm / ontologies_api

Hypermedia API for ontologies
http://data.agroportal.lirmm.fr/
Other
2 stars 7 forks source link

Bug in the paginated concepts sorted by date, that is empty after page 200 #25

Open syphax-bouazzouni opened 1 year ago

syphax-bouazzouni commented 1 year ago

Issue

The total page count is 316, but empty all the pages are empty after page 200.

The problem is that the count query that does not take into consideration the main query filters

Image

syphax-bouazzouni commented 1 year ago

The issue was that the pagination does not work with filters if the filters' patterns are not included in the SELECT clause.

For example, this does not work after some pages

SELECT ?id ?p ?v 
FROM ...
WHERE 
{
  ...
 FILTER (?p2 = "...")
} OFFSET 10 LIMIT 50 

But this does work for all pages

SELECT ?id ?p ?v ?p2
FROM ...
WHERE 
{
  ...
 FILTER (?p2 = "...")
} OFFSET 10 LIMIT 50 

It's not a perfect solution and will be removed when we go fully to Alegrogprah. So I will close it then. Done here https://github.com/ontoportal-lirmm/goo/pull/34

syphax-bouazzouni commented 11 months ago

This needs to be done for order_by patterns

syphax-bouazzouni commented 10 months ago

Can't be fixed for 4store