Methods and apparatuses for providing an infinitely scrolling accumulator
View Patent ↗A method, apparatus and computer program product are provided for implementing an infinitely scrolling accumulator. An example of the method includes providing, by a computer processor, a user interface comprising an available window and a selected window, the available window associated with an available window query and the selected window associated with a selected window query, displaying at least one record in the available window via the user interface, receiving, via the user interface, a selection of the at least one record displayed in the available window, modifying the available window query such that the available window query does not select the at least one record from a database, and modifying the selected window query such that the selected window query selects the at least one record from the database.
1. A method, executed by a computer processor of an apparatus, for implementing an infinitely scrolling accumulator, the method comprising:
providing, by the computer processor, a user interface comprising an available window and a selected window, the available window associated with an available window query and the selected window associated with a selected window query, wherein a first data structure is assigned to the available window query, the first data structure comprising one or more first filters configured to facilitate infinite scrolling in the available window, wherein a second data structure is assigned to the selected window query, the second data structure comprising one or more second filters configured to facilitate infinite scrolling in the selected window;
displaying at least one record in the available window via the user interface;
receiving, via the user interface, a selection of the at least one record displayed in the available window;
receiving an input indicating an intent to move the selected at least one record from the available window to the selected window;
based upon receiving the selection of the at least one record, modifying the first data structure by changing the one or more first filters and modifying the second data structure by changing the one or more second filters;
in response to receiving the input, modifying the available window query based on the one or more first filters in the first data structure such that the available window query does not select the at least one record from a database;
in response to receiving the input, modifying the selected window query based on the one or more second filters in the second data structure such that the selected window query selects the at least one record from the database; and
optimizing at least one of the available window query or the selected window query based upon at least one of the one or more first filters or the one or more second filters, wherein optimizing at least one of the available window query or the selected window query reduces a length of the available window query or a length of the selected window query.
2. The method of claim 1 , further comprising executing the available window query and the selected window query, wherein the results of the execution of the available window query and the selected window query are utilized to update the available window and the selected window, respectively.
3. The method of claim 1 , further comprising:
filtering the available window based on a filtering criterion;
receiving, via the user interface, a selection of an interface control to include all records corresponding to the filtering criterion;
determining a modification to the selected window query based on the filtering criterion; and
modifying the selected window query to select records matching the filtering criterion.
4. The method of claim 1 , further comprising modifying the available window query to exclude records matching the filtering criterion.
5. The method of claim 1 , wherein the available window and the selected window are implemented using an infinite scroll design pattern.
6. The method of claim 1 , further comprising:
causing execution of the available window query to obtain a set of available window query results;
determining a reduced subset of the available window query results, wherein the subset of available window query results contains fewer records than the set of available window query results; and
loading the reduced subset of available window query results into the available window of the user interface.
7. The method of claim 6 , wherein the reduced subset of available window query results is determined based at least in part on at least one of a position identifier associated with at least one record displayed within the available window or a page number associated with the at least one record displayed within the available window.
8. The method of claim 1 , wherein the first data structure and the second data structure are in JavaScript Object Notation (JSON) format.
9. An apparatus for implementing an infinitely scrolling accumulator, the apparatus comprising a computer processor and a memory, the computer processor configured by instructions stored in the memory to configure the apparatus to at least:
provide, by the computer processor, a user interface comprising an available window and a selected window, the available window associated with an available window query and the selected window associated with a selected window query, wherein a first data structure is assigned to the available window query, the first data structure comprising one or more first filters configured to facilitate infinite scrolling in the available window, wherein a second data structure is assigned to the selected window query, the second data structure comprising one or more second filters configured to facilitate infinite scrolling in the selected window;
display at least one record in the available window via the user interface;
receive, via the user interface, a selection of the at least one record displayed in the available window;
receive an input indicating an intent to move the selected at least one record from the available window to the selected window;
based upon receiving the selection of the at least one record, modify the first data structure by changing the one or more first filters and modify the second data structure by changing the one or more second filters;
in response to receiving the input, modify the available window query based on the one or more first filters in the first data structure such that the available window query does not select the at least one record from a database;
in response to receiving the input, modify the selected window query based on the one or more second filters in the second data structure such that the selected window query selects the at least one record from the database; and
optimizing at least one of the available window query or the selected window query based upon at least one of the one or more first filters or the one or more second filters, wherein optimizing at least one of the available window query or the selected window query reduces a length of the available window query or a length of the selected window query.
10. The apparatus of claim 9 , further configured to execute the available window query and the selected window query, wherein the results of the execution of the available window query and the selected window query are utilized to update the available window and the selected window, respectively.
11. The apparatus of claim 9 , further configured to:
filter the available window based on a filtering criterion;
receive, via the user interface, a selection of an interface control to include all records corresponding to the filtering criterion;
determine a modification to the selected window query based on the filtering criterion; and
modify the selected window query to select records matching the filtering criterion.
12. The apparatus of claim 11 , further configured to modify the available window query to exclude records matching the filtering criterion.
13. The apparatus of claim 9 , wherein the available window and the selected window are implemented using an infinite scroll design pattern.
14. The apparatus of claim 9 , further configured to:
cause execution of the available window query to obtain a set of available window query results;
determine a reduced subset of the available window query results, wherein the subset of available window query results contains fewer records than the set of available window query results; and
load the reduced subset of available window query results into the available window of the user interface.
15. The apparatus of claim 14 , wherein the reduced subset of available window query results is determined based at least in part on at least one of a position identifier associated with at least one record displayed within the available window or a page number associated with the at least one record displayed within the available window.
16. A non-transitory computer readable storage medium comprising instructions that, when executed by a computer processor of an apparatus, cause the computer processor to implement an infinitely scrolling accumulator, the instructions, when executed by the computer processor, are configured to cause the computer processor to at least:
provide, by the computer processor, a user interface comprising an available window and a selected window, the available window associated with an available window query and the selected window associated with a selected window query, wherein a first data structure is assigned to the available window query, the first data structure comprising one or more first filters configured to facilitate infinite scrolling in the available window, wherein a second data structure is assigned to the selected window query, the second data structure comprising one or more second filters configured to facilitate infinite scrolling in the selected window;
display at least one record in the available window via the user interface;
receive, via the user interface, a selection of the at least one record displayed in the available window;
receive an input indicating an intent to move the selected at least one record from the available window to the selected window;
based upon receiving the selection of the at least one record, modify the first data structure by changing the one or more first filters and modify the second data structure by changing the one or more second filters;
in response to receiving the input, modify the available window query based on the one or more first filters in the first data structure such that the available window query does not select the at least one record from a database;
in response to receiving the input, modify the selected window query based on the one or more second filters in the second data structure such that the selected window query selects the at least one record from the database; and
optimizing at least one of the available window query or the selected window query based upon at least one of the one or more first filters or the one or more second filters, wherein optimizing at least one of the available window query or the selected window query reduces a length of the available window query or a length of the selected window query.
17. The computer readable storage medium of claim 16 , further comprising instructions configured to execute the available window query and the selected window query, wherein the results of the execution of the available window query and the selected window query are utilized to update the available window and the selected window, respectively.
18. The computer readable storage medium of claim 16 , further comprising instructions configured to:
filter the available window based on a filtering criterion;
receive, via the user interface, a selection of an interface control to include all records corresponding to the filtering criterion;
determine a modification to the selected window query based on the filtering criterion; and
modify the selected window query to select records matching the filtering criterion.
19. The computer readable storage medium of claim 18 , further comprising instructions configured to modify the available window query to exclude records matching the filtering criterion.
20. The computer readable storage medium of claim 16 , wherein the available window and the selected window are implemented using an infinite scroll design pattern.