Nested pagination for presenting a data set in a graphical user interface
Nested pagination for presenting a data set in a graphical user interface (GUI) including receiving a request for the data set to present in a GUI, wherein the request comprises a group name identifying a nested group of rows in the data set; selecting an anchor point from the data set using the group name, wherein the anchor point is within the group of rows identified by the group name; selecting, using the anchor point, a subset of the data set for presentation in the GUI, wherein the subset of the data set comprises the anchor point; and presenting the subset of the data set in the GUI.
1. A method of nested pagination for presenting a data set in a graphical user interface (GUI), the method comprising:
receiving a request for the data set to present in a GUI, wherein the request comprises a group name identifying a nested group of rows in the data set, the data set comprises data stored in a cloud-based data warehouse, and the GUI comprises a web browser;
selecting an anchor point from the data set using the group name, wherein the anchor point is within the group of rows identified by the group name;
selecting, using the anchor point, a subset of the data set for presentation in the GUI, wherein the subset of the data set comprises the anchor point; and
presenting the subset of the data set in the GUI.
2. The method of claim 1 , wherein selecting, using the anchor point, the subset of the data set for presentation in the GUI comprises selecting the subset of the data set for presentation in the GUI using a row limit and an offset from the anchor point.
3. The method of claim 1 ,
wherein the request for the data set to present in the GUI comprises a parent group name identifying a parent group to the nested group of rows in the data set, and
wherein selecting the anchor point from the data set using the group name comprises selecting a parent anchor point from within the nested group of rows.
4. The method of claim 1 , wherein receiving the request for the data set to present in the GUI comprises receiving an instruction to expand the group of rows.
5. The method of claim 1 , wherein receiving the request for the data set to present in the GUI comprises detecting that a user has scrolled to an edge of the subset of the data set.
6. The method of claim 1 , wherein the subset of the data set comprises at least one row from outside the nested group of rows.
7. The method of claim 1 , wherein the anchor point is selected without using a row number.
8. An apparatus for nested pagination for presenting a data set in a graphical user interface (GUI), the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
receiving a request for the data set to present in a GUI, wherein the request comprises a group name identifying a nested group of rows in the data set, the data set comprises data stored in a cloud-based data warehouse, and the GUI comprises a web browser;
selecting an anchor point from the data set using the group name, wherein the anchor point is within the group of rows identified by the group name;
selecting, using the anchor point, a subset of the data set for presentation in the GUI, wherein the subset of the data set comprises the anchor point; and
presenting the subset of the data set in the GUI.
9. The apparatus of claim 8 , wherein selecting, using the anchor point, the subset of the data set for presentation in the GUI comprises selecting the subset of the data set for presentation in the GUI using a row limit and an offset from the anchor point.
10. The apparatus of claim 8 ,
wherein the request for the data set to present in the GUI comprises a parent group name identifying a parent group to the nested group of rows in the data set, and
wherein selecting the anchor point from the data set using the group name comprises selecting a parent anchor point from within the nested group of rows.
11. The apparatus of claim 8 , wherein receiving the request for the data set to present in the GUI comprises receiving an instruction to expand the group of rows.
12. The apparatus of claim 8 , wherein receiving the request for the data set to present in the GUI comprises detecting that a user has scrolled to an edge of the subset of the data set.
13. The apparatus of claim 8 , wherein the subset of the data set comprises at least one row from outside the nested group of rows.
14. The apparatus of claim 8 , wherein the anchor point is selected without using a row number.
15. A computer program product for nested pagination for presenting a data set in a graphical user interface (GUI), the computer program product disposed upon a non-transitory computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving a request for the data set to present in a GUI, wherein the request comprises a group name identifying a nested group of rows in the data set, the data set comprises data stored in a cloud-based data warehouse, and the GUI comprises a web browser;
selecting an anchor point from the data set using the group name, wherein the anchor point is within the group of rows identified by the group name;
selecting, using the anchor point, a subset of the data set for presentation in the GUI, wherein the subset of the data set comprises the anchor point; and
presenting the subset of the data set in the GUI.
16. The computer program product of claim 15 , wherein selecting, using the anchor point, the subset of the data set for presentation in the GUI comprises selecting the subset of the data set for presentation in the GUI using a row limit and an offset from the anchor point.
17. The computer program product of claim 15 ,
wherein the request for the data set to present in the GUI comprises a parent group name identifying a parent group to the nested group of rows in the data set, and
wherein selecting the anchor point from the data set using the group name comprises selecting a parent anchor point from within the nested group of rows.
18. The computer program product of claim 15 , wherein receiving the request for the data set to present in the GUI comprises receiving an instruction to expand the group of rows.
19. The computer program product of claim 15 , wherein receiving the request for the data set to present in the GUI comprises detecting that a user has scrolled to an edge of the subset of the data set.
20. The computer program product of claim 15 , wherein the subset of the data set comprises at least one row from outside the nested group of rows.