Databases
StackOverflow2013
Postsdbo
POElasticsearch get matching documents after specific document id
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POElasticsearch get matching documents after specific document id
    primarykey
    data
    text
    <p>When I search for documents I took the first 10 and give them to the view, if the user scrolls to the end of the list the next 10 elements should be displayed. </p> <p>I know the last document id of the displayed documents, now I have to get the next 10. Basically I would perform the exact same search with an offset of 10 but it would be much better to be able to search with the same query, putting the document id of the last retrieved document to it and retrieve the matching documents after the document with that id.</p> <p>Is that possible with elasticsearch?</p> <p>=== UPDATE</p> <p>I want to point out my issue a bit more, because it seems it is not clear enough as it is described right now. Sorry for that.</p> <p>The case:</p> <p>You have a kind of feed, the feed will grow every second. If a user goes to the feed he gets the most recent 10 entries, if he scrolls down he wants to get the next 10 entries. </p> <p>Because the feed is growing every second, a usual offset / limit (from / size in elasticsearch) can't solve this problem, you would display already displayed entries or completely newer entries, depending on the time between first request (first 10 entries) and the request for the next entries.</p> <p>The request to get the next 10 elements AFTER the already displayed entries gives the backend the id of the last entry which got displayed. The backend knows to ignore all entries before this specific one. </p> <p>At the moment I'm handling this in code, I request the list with all matching entries from Elasticsearch and iterate it, this way I can do everything I want (no surprise) and extract the needed chunk of entires.</p> <p>My question is: Is there is a build in solution for this issue in elasticsearch. Because solving the problem on my way is not the fastest.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmaddin2code
    1. USmaddin2code
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI don't understand the difference. Its just an additional page part that you need to add to the query to get the next page. You can create a construct that creates the page query part for you that you can append to the query
      singulars
      1. POElasticsearch get matching documents after specific document id
      1. USgeeky_sh
    2. COIt makes a difference. Think about the page like a twitter feed, if the user scrolls down and is ready to get the next elements, it could happen (while the user was reading the fist 10 elements) the feed got new entries. If you select via a simple offset the next 10 elements, the user will retrieve elements he already had.
      singulars
      1. POElasticsearch get matching documents after specific document id
      1. USmaddin2code
    3. COYou can exclude some ids with boolean query
      singulars
      1. POElasticsearch get matching documents after specific document id
      1. USremiheens
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload