Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Headerdescription
totalAnchorstotal number of anchors
resultIndexrequested index of anchor
anchorSizerequested number of anchors

Query

QueryDescriptionDecision
SELECT id FROM anchor order by id LIMIT : anchorSize OFFSET : (resultIndex -1) * :anchorSize query list of anchors 
SELECT id, anchor_id AS anchorId, xpath, parent_id AS parentId, CAST(attributes AS TEXT) AS attributes FROM FRAGMENT WHERE anchor_id IN :anchorList AND xpath ~ :xpathRegexquery fragments for list of anchors from above query

...