Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
Tracked by #262
syphax-bouazzouni opened this issue Dec 19, 2022 · 3 comments
Assignees
Labels

Comments

@syphax-bouazzouni
Copy link

syphax-bouazzouni commented Dec 19, 2022

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 syphax-bouazzouni changed the title Fix a bug in the paginated concepts sorted by date, that is empty after page 6 Bug in the paginated concepts sorted by date, that is empty after page 200 Dec 19, 2022
@syphax-bouazzouni
Copy link
Author

syphax-bouazzouni commented Apr 28, 2023

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 ontoportal-lirmm/goo#34

@syphax-bouazzouni
Copy link
Author

This needs to be done for order_by patterns

@syphax-bouazzouni
Copy link
Author

Can't be fixed for 4store

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant